Jump to content
Marcos Vinícius

[Resolvido] Consulta Mysqli não retorna resultados

Recommended Posts

Prezados,

 

Estou tentando fazer uma consulta que soma os valores de um campo em determinado mês/ano mas não estou conseguindo fazer funcionar. Alguém tem uma ideia do que pode ser?

 

"SELECT sum(caepf) AS scaepf    
FROM atend 
WHERE 
date_format(data, '%Y-%m') <= date_format('$d', '%Y-%m')
AND date_format(data, '%Y-%m') >= date_format('$d', '%Y-%m')
AND pav = '$nome_pav'
AND dr = '$dr' ";

 

Share this post


Link to post
Share on other sites

Olá @Marcos Vinícius, tudo tranquilo?

 

O que você quer dizer com "não estou conseguindo fazer funcionar"? Aparece algum erro ou simplesmente não retorna registros?

 

Vou te dar algumas sugestões:

1 - Tenho quase certeza que o problema é pelo fato de que "data" é uma palavra reservada no Mysql, e sua consulta deve estar sendo mal interpretada pelo banco.

Veja: https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-D

Como resolver: uso correto das aspas para nomes de colunas e tabelas (no caso, crase).

"SELECT sum(`caepf`) AS `scaepf`
FROM `atend`
WHERE 
date_format(`data`, '%Y-%m') <= date_format('$d', '%Y-%m')
AND date_format(`data`, '%Y-%m') >= date_format('$d', '%Y-%m')
AND `pav` = '$nome_pav'
AND `dr` = '$dr' ";

 

2 - Verifique se as variáveis estão corretas.

Pela sintaxe, eu chutaria que você está utilizando um sprintf dentro do PHP, e nesse caso iria sugerir que você jogasse essa string do SELECT em um echo para verificar se todas as informações estão coerentes com suas intenções.

 

3 - Verifique se a coluna data possui tipo DATE, DATETIME, TIMESTAMP ou similares, pois apenas tipos específicos possuem recursos de comparação com datas.

 

Sem muita relevância com o problema, mas sugiro também que considere utilizar nomes mais sugestivos e padronizados para as tabelas e colunas. "pav", "dr", "atend" ou "scaepf" certamente possuem variações mais compreensíveis que facilitarão sua organização.

 

Espero que consiga resolver. Qualquer coisa é só postar :)

Share this post


Link to post
Share on other sites

Obrigado Matheus,

 

Acabei fazendo de outra forma e consegui...

 

No lugar de usar o date_format() usei YEAR() e MONTH()

 

Quanto aos nomes, agradeço também. Usei esses porque são nomes usuais onde trabalho. Por exemplo, pav é abreviatura de "ponto de atendimento virtual"

 

De qualquer forma, agradeço muito suas considerações e o tempo que você dedicou!!!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By Felper
      Criei um sistema de login com php e mysql mas não consigo realizar o login mesmo tendo certeza de que os dados foram cadastrados com sucesso. Não sei o que fiz de errado. Vejam o código:
      <?php $login2 = $_POST['loginlogar']; $senha2 = $_POST['senhalogar']; $link = mysqli_connect("localhost", "root", "", "bancolanche") or die("<h1>Não foi possível conectar!!</h1>". mysqli_error()); $banco = mysqli_select_db($link, "bancolanche") or die("<h1>Não foi possível abrir banco de dados!!</h1>". mysqli_error()); $sql = "SELECT login, senha FROM users"; $resulta = mysqli_query($link, $sql); while ($book = $resulta->fetch_object()) { $logindb = $book->login; $senhadb = $book->senha; } if($login2 == "" || $senha2 == ""){ $_SESSION['msg'] = "<h1 style='color:red'>Erro ao logar! Há campos de preenchimento obrigatório em branco.</h1>"; header("Location: logar.php"); } else { if($logindb==$login2 && $senhadb==$senha2){ $_SESSION['msg'] = "<h1 style='color:green'>Logoff realizado com sucesso!</h1>"; header("Location: index.html"); } else { $_SESSION['msg'] = "<h1 style='color:red'>Erro ao logar! Usuário inexistente ou senha incorreta.</h1>"; header("Location: logar.php"); } } mysqli_close($link); ?>  
    • By r.guerra
      Salve galera, boa tarde a todos.
      estou tendo um problema que ainda nao consegui enxergar... faço uma consulta mysql que funciona normalmente no proprio ambiente(mysql) mas ao solicitar a exibição do campo via php gera nao exibe e me tras um alerta.
       
      ****codigo php
      function monta_avaliacao($cpf){
          $query = mysqli_query($_SESSION["conector"],"SELECT c.*, a. cliente AS clientes FROM clientes AS c INNER JOIN avaliacoes AS a ON c.id = a.cliente WHERE c.cpf='$cpf'");
           $dados = mysqli_fetch_assoc($query);
          print $dados['c.cpf'];
           }
       
      *****sainda no html
      Notice: Undefined index: c.cpf in C:\xampp\htdocs\acus\inclusoes\funcoes.php on line 29
      Notice: Undefined index: a.pe in C:\xampp\htdocs\acus\inclusoes\funcoes.php on line 30
       
      tenho um arquivo com as funções, e apenas mando os parametros.
    • By EvertonFD
      ola senhores estou estudando php e msqli estou com uma dificuldade para fazer um ranking prq o o time joga como visitantes mas as vezes como mandante então preciso somar quando ele aparece nas duas situações. por exemplo {time 1x time2} e {time 3 x time 1} fiz uma tabela de enfrentamento que já serve como agenda. o problema é não consigo trazer os esse dados so vem de uma situação e não das duas. caso alguem possa me ajudar ou dar uma outra ideia de como fazer esse ranking agradeço. esse é o codigo que estou usando.
      SELECT id, timea_id, SUM(gola), timeb_id, SUM(golb) FROM agenda WHERE timea_id=2  
    • By Giuliano Maffei
      Oi Pessoal, sou novo por aqui.
      Agradeço se alguém puder me ajudar.
      Tenho um banco de dados com a tabela abaixo:
      DB pets
      ------------------------------------------------------------------------------------
      | id | pet_tutor | pet_name | pet_species | pet_breed  |
      ------------------------------------------------------------------------------------
      | 1  |        José |             Rex |                   1 |    Vira-latas |
      | 2  |      Paulo |      Bichano |                  2 |        Siamês |
      | 3  |       João |             Max |                  1 | Lhasa-apso |
      ------------------------------------------------------------------------------------
       
      Fiz o código abaixo:
      $species_lang = array('0' => 'Selecionar','1' => 'Cachorro', '2' => 'Gatos', '3' => 'Acarás');
       
      SELECT (pets.id as id, pet_tutor, pet_name, {(" . $species_lang['pet_species'] . ")}, pet_breed FROM pets)
       
      Resultado:
      -----------------------------------------------------------------------------------
      | id | pet_tutor | pet_name | pet_species | pet_breed  |
      ------------------------------------------------------------------------------------
      | 1  |        José |             Rex |                        | Vira-latas |
      | 2  |       Paulo |    Bichano |                        |     Siamês |
      | 3  |        João |           Max |                        | Lhasa-apso |

      -----------------------------------------------------------------------------------
      Porque não consigo carregar o campo 'pet_species' com a raça do pet. Alguém tem uma luz pra me ajudar?
       
      Obrigado
    • By Sergio0175
      Estou tendo problema na hora de fazer a conexão entre o PHP e o Mysqli.
       
      Comando usado:
       
      <?
      $host="localhost";
      $port=3306;
      $socket="";
      $user="root";
      $password="1234";
      $dbname="dnagerae";
      $con = new mysqli($host, $user, $password, $dbname, $port, $socket)
          or die ('Could not connect to the database server' . mysqli_connect_error());
          
          
      //$con->close();
      ?>
       
      Resposta:
       
      Fatal error: Class 'mysqli' not found in C:\Apache24\htdocs\dnagerae\teste_.php on line 10
       
      já fiz todas as configurações possíveis e nada de conexão.
       
      estou utilizando o Apache :
       
      Apache/2.4.46 (Win64) PHP/5.6.22  
      MYSQL versão 8
       
       
       
       
      System Windows NT MRJO50214410 6.1 build 7601 (Windows 7 Professional Edition Service Pack 1) AMD64 Build Date May 25 2016 22:05:53 Compiler MSVC11 (Visual C++ 2012) Architecture x64 Configure Command cscript /nologo configure.js "--enable-snapshot-build" "--disable-isapi" "--enable-debug-pack" "--without-mssql" "--without-pdo-mssql" "--without-pi3web" "--with-pdo-oci=c:\php-sdk\oracle\x64\instantclient_12_1\sdk,shared" "--with-oci8-12c=c:\php-sdk\oracle\x64\instantclient_12_1\sdk,shared" "--enable-object-out-dir=../obj/" "--enable-com-dotnet=shared" "--with-mcrypt=static" "--without-analyzer" "--with-pgo" Server API Apache 2.0 Handler Virtual Directory Support enabled Configuration File (php.ini) Path C:\Windows Loaded Configuration File (none) Scan this dir for additional .ini files (none) Additional .ini files parsed (none) PHP API 20131106 PHP Extension 20131226 Zend Extension 220131226 Zend Extension Build API220131226,TS,VC11 PHP Extension Build API20131226,TS,VC11 Debug Build no Thread Safety enabled Zend Signal Handling disabled Zend Memory Manager enabled Zend Multibyte Support disabled IPv6 Support enabled DTrace Support disabled Registered PHP Streams php, file, glob, data, http, ftp, zip, compress.zlib, phar Registered Stream Socket Transports tcp, udp Registered Stream Filters convert.iconv.*, mcrypt.*, mdecrypt.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, zlib.* This program makes use of the Zend Scripting Language Engine:
      Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies Configuration
      apache2handler
      Apache Version Apache/2.4.46 (Win64) PHP/5.6.22 Apache API Version 20120211 Server Administrator admin@example.com Hostname:Port MRJO50214410.correiosnet.int:0 Max Requests Per Child: 0 - Keep Alive: on - Max Per Connection: 100 Timeouts Connection: 60 - Keep-Alive: 5 Virtual Server No Server Root C:/Apache24 Loaded Modules core mod_win32 mpm_winnt http_core mod_so mod_actions mod_alias mod_allowmethods mod_asis mod_auth_basic mod_authn_core mod_authn_file mod_authz_core mod_authz_groupfile mod_authz_host mod_authz_user mod_autoindex mod_cgi mod_dir mod_env mod_include mod_isapi mod_log_config mod_mime mod_negotiation mod_session mod_session_cookie mod_session_crypto mod_session_dbd mod_setenvif mod_php5 Directive Local Value Master Value engine 1 1 last_modified 0 0 xbithack 0 0 Apache Environment
      Variable Value HTTP_ACCEPT text/html, application/xhtml+xml, */* HTTP_ACCEPT_LANGUAGE pt-BR HTTP_USER_AGENT Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko HTTP_ACCEPT_ENCODING gzip, deflate HTTP_HOST localhost HTTP_CONNECTION Keep-Alive PATH C:\PHP\;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x64;C:\Program Files\MySQL\MySQL Utilities 1.6\; SystemRoot C:\Windows COMSPEC C:\Windows\system32\cmd.exe PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC WINDIR C:\Windows SERVER_SIGNATURE no value SERVER_SOFTWARE Apache/2.4.46 (Win64) PHP/5.6.22 SERVER_NAME localhost SERVER_ADDR 127.0.0.1 SERVER_PORT 80 REMOTE_ADDR 127.0.0.1 DOCUMENT_ROOT C:/Apache24/htdocs REQUEST_SCHEME http CONTEXT_PREFIX no value CONTEXT_DOCUMENT_ROOT C:/Apache24/htdocs SERVER_ADMIN admin@example.com SCRIPT_FILENAME C:/Apache24/htdocs/teste.php REMOTE_PORT 61292 GATEWAY_INTERFACE CGI/1.1 SERVER_PROTOCOL HTTP/1.1 REQUEST_METHOD GET QUERY_STRING no value REQUEST_URI /teste.php SCRIPT_NAME /teste.php HTTP Headers Information
      HTTP Request Headers HTTP Request GET /teste.php HTTP/1.1 Accept text/html, application/xhtml+xml, */* Accept-Language pt-BR User-Agent Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko Accept-Encoding gzip, deflate Host localhost Connection Keep-Alive HTTP Response Headers X-Powered-By PHP/5.6.22 bcmath
      BCMath support enabled Directive Local Value Master Value bcmath.scale 0 0 calendar
      Calendar support enabled Core
      PHP Version 5.6.22 Directive Local Value Master Value allow_url_fopen On On allow_url_include Off Off always_populate_raw_post_data 0 0 arg_separator.input & & arg_separator.output & & asp_tags Off Off auto_append_file no value no value auto_globals_jit On On auto_prepend_file no value no value browscap no value no value default_charset UTF-8 UTF-8 default_mimetype text/html text/html disable_classes no value no value disable_functions no value no value display_errors On On display_startup_errors Off Off doc_root no value no value docref_ext no value no value docref_root no value no value enable_dl On On enable_post_data_reading On On error_append_string no value no value error_log no value no value error_prepend_string no value no value error_reporting no value no value exit_on_timeout Off Off expose_php On On extension_dir C:\php\ext C:\php\ext file_uploads On On highlight.comment #FF8000 #FF8000 highlight.default #0000BB #0000BB highlight.html #000000 #000000 highlight.keyword #007700 #007700 highlight.string #DD0000 #DD0000 html_errors On On ignore_repeated_errors Off Off ignore_repeated_source Off Off ignore_user_abort Off Off implicit_flush Off Off include_path .;C:\php\pear .;C:\php\pear input_encoding no value no value internal_encoding no value no value log_errors Off Off log_errors_max_len 1024 1024 mail.add_x_header Off Off mail.force_extra_parameters no value no value mail.log no value no value max_execution_time 30 30 max_file_uploads 20 20 max_input_nesting_level 64 64 max_input_time -1 -1 max_input_vars 1000 1000 memory_limit 128M 128M open_basedir no value no value output_buffering 0 0 output_encoding no value no value output_handler no value no value post_max_size 8M 8M precision 14 14 realpath_cache_size 16K 16K realpath_cache_ttl 120 120 register_argc_argv On On report_memleaks On On report_zend_debug On On request_order no value no value sendmail_from no value no value sendmail_path no value no value serialize_precision 17 17 short_open_tag On On SMTP localhost localhost smtp_port 25 25 sql.safe_mode Off Off sys_temp_dir no value no value track_errors Off Off unserialize_callback_func no value no value upload_max_filesize 2M 2M upload_tmp_dir no value no value user_dir no value no value user_ini.cache_ttl 300 300 user_ini.filename .user.ini .user.ini variables_order EGPCS EGPCS windows.show_crt_warning Off Off xmlrpc_error_number 0 0 xmlrpc_errors Off Off zend.detect_unicode On On zend.enable_gc On On zend.multibyte Off Off zend.script_encoding no value no value ctype
      ctype functions enabled date

      Warning: phpinfo(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in C:\Apache24\htdocs\teste.php on line 1 date/time support enabled "Olson" Timezone Database Version 2016.3 Timezone Database internal Default timezone UTC Directive Local Value Master Value date.default_latitude 31.7667 31.7667 date.default_longitude 35.2333 35.2333 date.sunrise_zenith 90.583333 90.583333 date.sunset_zenith 90.583333 90.583333 date.timezone no value no value dom
      DOM/XML enabled DOM/XML API Version 20031129 libxml Version 2.9.3 HTML Support enabled XPath Support enabled XPointer Support enabled Schema Support enabled RelaxNG Support enabled ereg
      Regex Library Bundled library enabled filter
      Input Validation and Filtering enabled Revision $Id: 0a967738ca580e8bfdacb06853749743fc79b969 $ Directive Local Value Master Value filter.default unsafe_raw unsafe_raw filter.default_flags no value no value ftp
      FTP support enabled hash
      hash support enabled Hashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b fnv132 fnv1a32 fnv164 fnv1a64 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5 iconv
      iconv support enabled iconv implementation "libiconv" iconv library version 1.14 Directive Local Value Master Value iconv.input_encoding no value no value iconv.internal_encoding no value no value iconv.output_encoding no value no value json
      json support enabled json version 1.2.1 libxml
      libXML support active libXML Compiled Version 2.9.3 libXML Loaded Version 20903 libXML streams enabled mcrypt
      mcrypt support enabled mcrypt_filter support enabled Version 2.5.8 Api No 20021217 Supported ciphers cast-128 gost rijndael-128 twofish cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes arcfour Supported modes cbc cfb ctr ecb ncfb nofb ofb stream Directive Local Value Master Value mcrypt.algorithms_dir no value no value mcrypt.modes_dir no value no value mhash
      MHASH support Enabled MHASH API Version Emulated Support mysqlnd
      mysqlnd enabled Version mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ Compression supported core SSL supported extended SSL not supported Command buffer size 4096 Read buffer size 32768 Read timeout 31536000 Collecting statistics Yes Collecting memory statistics No Tracing n/a Loaded plugins mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password API Extensions no value mysqlnd statistics   bytes_sent 0 bytes_received 0 packets_sent 0 packets_received 0 protocol_overhead_in 0 protocol_overhead_out 0 bytes_received_ok_packet 0 bytes_received_eof_packet 0 bytes_received_rset_header_packet 0 bytes_received_rset_field_meta_packet 0 bytes_received_rset_row_packet 0 bytes_received_prepare_response_packet 0 bytes_received_change_user_packet 0 packets_sent_command 0 packets_received_ok 0 packets_received_eof 0 packets_received_rset_header 0 packets_received_rset_field_meta 0 packets_received_rset_row 0 packets_received_prepare_response 0 packets_received_change_user 0 result_set_queries 0 non_result_set_queries 0 no_index_used 0 bad_index_used 0 slow_queries 0 buffered_sets 0 unbuffered_sets 0 ps_buffered_sets 0 ps_unbuffered_sets 0 flushed_normal_sets 0 flushed_ps_sets 0 ps_prepared_never_executed 0 ps_prepared_once_executed 0 rows_fetched_from_server_normal 0 rows_fetched_from_server_ps 0 rows_buffered_from_client_normal 0 rows_buffered_from_client_ps 0 rows_fetched_from_client_normal_buffered 0 rows_fetched_from_client_normal_unbuffered 0 rows_fetched_from_client_ps_buffered 0 rows_fetched_from_client_ps_unbuffered 0 rows_fetched_from_client_ps_cursor 0 rows_affected_normal 0 rows_affected_ps 0 rows_skipped_normal 0 rows_skipped_ps 0 copy_on_write_saved 0 copy_on_write_performed 0 command_buffer_too_small 0 connect_success 0 connect_failure 0 connection_reused 0 reconnect 0 pconnect_success 0 active_connections 0 active_persistent_connections 0 explicit_close 0 implicit_close 0 disconnect_close 0 in_middle_of_command_close 0 explicit_free_result 0 implicit_free_result 0 explicit_stmt_close 0 implicit_stmt_close 0 mem_emalloc_count 0 mem_emalloc_amount 0 mem_ecalloc_count 0 mem_ecalloc_amount 0 mem_erealloc_count 0 mem_erealloc_amount 0 mem_efree_count 0 mem_efree_amount 0 mem_malloc_count 0 mem_malloc_amount 0 mem_calloc_count 0 mem_calloc_amount 0 mem_realloc_count 0 mem_realloc_amount 0 mem_free_count 0 mem_free_amount 0 mem_estrndup_count 0 mem_strndup_count 0 mem_estndup_count 0 mem_strdup_count 0 proto_text_fetched_null 0 proto_text_fetched_bit 0 proto_text_fetched_tinyint 0 proto_text_fetched_short 0 proto_text_fetched_int24 0 proto_text_fetched_int 0 proto_text_fetched_bigint 0 proto_text_fetched_decimal 0 proto_text_fetched_float 0 proto_text_fetched_double 0 proto_text_fetched_date 0 proto_text_fetched_year 0 proto_text_fetched_time 0 proto_text_fetched_datetime 0 proto_text_fetched_timestamp 0 proto_text_fetched_string 0 proto_text_fetched_blob 0 proto_text_fetched_enum 0 proto_text_fetched_set 0 proto_text_fetched_geometry 0 proto_text_fetched_other 0 proto_binary_fetched_null 0 proto_binary_fetched_bit 0 proto_binary_fetched_tinyint 0 proto_binary_fetched_short 0 proto_binary_fetched_int24 0 proto_binary_fetched_int 0 proto_binary_fetched_bigint 0 proto_binary_fetched_decimal 0 proto_binary_fetched_float 0 proto_binary_fetched_double 0 proto_binary_fetched_date 0 proto_binary_fetched_year 0 proto_binary_fetched_time 0 proto_binary_fetched_datetime 0 proto_binary_fetched_timestamp 0 proto_binary_fetched_string 0 proto_binary_fetched_json 0 proto_binary_fetched_blob 0 proto_binary_fetched_enum 0 proto_binary_fetched_set 0 proto_binary_fetched_geometry 0 proto_binary_fetched_other 0 init_command_executed_count 0 init_command_failed_count 0 com_quit 0 com_init_db 0 com_query 0 com_field_list 0 com_create_db 0 com_drop_db 0 com_refresh 0 com_shutdown 0 com_statistics 0 com_process_info 0 com_connect 0 com_process_kill 0 com_debug 0 com_ping 0 com_time 0 com_delayed_insert 0 com_change_user 0 com_binlog_dump 0 com_table_dump 0 com_connect_out 0 com_register_slave 0 com_stmt_prepare 0 com_stmt_execute 0 com_stmt_send_long_data 0 com_stmt_close 0 com_stmt_reset 0 com_stmt_set_option 0 com_stmt_fetch 0 com_deamon 0 bytes_received_real_data_normal 0 bytes_received_real_data_ps 0 odbc
      ODBC Support enabled Active Persistent Links 0 Active Links 0 ODBC library Win32 Directive Local Value Master Value odbc.allow_persistent On On odbc.check_persistent On On odbc.default_cursortype Static cursor Static cursor odbc.default_db no value no value odbc.default_pw no value no value odbc.default_user no value no value odbc.defaultbinmode return as is return as is odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes odbc.max_links Unlimited Unlimited odbc.max_persistent Unlimited Unlimited pcre
      PCRE (Perl Compatible Regular Expressions) Support enabled PCRE Library Version 8.38 2015-11-23 Directive Local Value Master Value pcre.backtrack_limit 1000000 1000000 pcre.recursion_limit 100000 100000 PDO
      PDO support enabled PDO drivers no value Phar
      Phar: PHP Archive support enabled Phar EXT version 2.0.2 Phar API version 1.1.1 SVN revision $Id: 14b80e175ed4d5bf11c890e1f30ea8225935b16c $ Phar-based phar archives enabled Tar-based phar archives enabled ZIP-based phar archives enabled gzip compression enabled bzip2 compression disabled (install pecl/bz2) OpenSSL support disabled (install ext/openssl) Phar based on pear/PHP_Archive, original concept by Davey Shafik.
      Phar fully realized by Gregory Beaver and Marcus Boerger.
      Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle. Directive Local Value Master Value phar.cache_list no value no value phar.readonly On On phar.require_hash On On Reflection
      Reflection enabled Version $Id: fbcf7a77ca8e3d4cd7501de8025235b947b8240f $ session
      Session Support enabled Registered save handlers files user Registered serializer handlers php_serialize php php_binary wddx Directive Local Value Master Value session.auto_start Off Off session.cache_expire 180 180 session.cache_limiter nocache nocache session.cookie_domain no value no value session.cookie_httponly Off Off session.cookie_lifetime 0 0 session.cookie_path / / session.cookie_secure Off Off session.entropy_file no value no value session.entropy_length 0 0 session.gc_divisor 100 100 session.gc_maxlifetime 1440 1440 session.gc_probability 1 1 session.hash_bits_per_character 4 4 session.hash_function 0 0 session.name PHPSESSID PHPSESSID session.referer_check no value no value session.save_handler files files session.save_path no value no value session.serialize_handler php php session.upload_progress.cleanup On On session.upload_progress.enabled On On session.upload_progress.freq 1% 1% session.upload_progress.min_freq 1 1 session.upload_progress.name PHP_SESSION_UPLOAD_PROGRESS PHP_SESSION_UPLOAD_PROGRESS session.upload_progress.prefix upload_progress_ upload_progress_ session.use_cookies On On session.use_only_cookies On On session.use_strict_mode Off Off session.use_trans_sid 0 0 SimpleXML
      Simplexml support enabled Revision $Id: 07fc6546e896094aed794aea4691f0151774d955 $ Schema support enabled SPL
      SPL support enabled Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException standard
      Dynamic Library Support enabled Internal Sendmail Support for Windows enabled Directive Local Value Master Value assert.active 1 1 assert.bail 0 0 assert.callback no value no value assert.quiet_eval 0 0 assert.warning 1 1 auto_detect_line_endings 0 0 default_socket_timeout 60 60 from no value no value url_rewriter.tags a=href,area=href,frame=src,form=,fieldset= a=href,area=href,frame=src,form=,fieldset= user_agent no value no value tokenizer
      Tokenizer Support enabled wddx
      WDDX Support enabled WDDX Session Serializer enabled xml
      XML Support active XML Namespace Support active libxml2 Version 2.9.3 xmlreader
      XMLReader enabled xmlwriter
      XMLWriter enabled zip
      Zip enabled Zip version 1.12.5 Libzip version 0.11.2 zlib
      ZLib Support enabled Stream Wrapper compress.zlib:// Stream Filter zlib.inflate, zlib.deflate Compiled Version 1.2.7.3 Linked Version 1.2.7.3 Directive Local Value Master Value zlib.output_compression Off Off zlib.output_compression_level -1 -1 zlib.output_handler no value no value Additional Modules
      Module Name Environment
      Variable Value ALLUSERSPROFILE C:\ProgramData APPDATA C:\Windows\syswow64\config\systemprofile\AppData\Roaming CommonProgramFiles C:\Program Files\Common Files CommonProgramFiles(x86) C:\Program Files (x86)\Common Files CommonProgramW6432 C:\Program Files\Common Files COMPUTERNAME MRJO50214410 ComSpec C:\Windows\system32\cmd.exe FP_NO_HOST_CHECK NO JAVA_TOOL_OPTIONS -Duser.timezone=America/Sao_Paulo LOCALAPPDATA C:\Windows\syswow64\config\systemprofile\AppData\Local NUMBER_OF_PROCESSORS 2 OS Windows_NT Path C:\PHP\;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x64;C:\Program Files\MySQL\MySQL Utilities 1.6\; PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC PHPRC C:\PHP\ PROCESSOR_ARCHITECTURE AMD64 PROCESSOR_IDENTIFIER Intel64 Family 6 Model 58 Stepping 9, GenuineIntel PROCESSOR_LEVEL 6 PROCESSOR_REVISION 3a09 ProgramData C:\ProgramData ProgramFiles C:\Program Files ProgramFiles(x86) C:\Program Files (x86) ProgramW6432 C:\Program Files PSModulePath C:\Windows\system32\WindowsPowerShell\v1.0\Modules\ PUBLIC C:\Users\Public SystemDrive C: SystemRoot C:\Windows TEMP C:\Windows\TEMP TMP C:\Windows\TEMP UATDATA C:\Windows\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77 USERDOMAIN CORREIOSNET USERNAME MRJO50214410$ USERPROFILE C:\Windows\syswow64\config\systemprofile windir C:\Windows windows_tracing_flags 3 windows_tracing_logfile C:\BVTBin\Tests\installpackage\csilogfile.log WIX C:\Program Files (x86)\WiX Toolset v3.11\ AP_PARENT_PID 1904 PHP Variables
      Variable Value _SERVER["HTTP_ACCEPT"] text/html, application/xhtml+xml, */* _SERVER["HTTP_ACCEPT_LANGUAGE"] pt-BR _SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko _SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate _SERVER["HTTP_HOST"] localhost _SERVER["HTTP_CONNECTION"] Keep-Alive _SERVER["PATH"] C:\PHP\;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x64;C:\Program Files\MySQL\MySQL Utilities 1.6\; _SERVER["SystemRoot"] C:\Windows _SERVER["COMSPEC"] C:\Windows\system32\cmd.exe _SERVER["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC _SERVER["WINDIR"] C:\Windows _SERVER["SERVER_SIGNATURE"] no value _SERVER["SERVER_SOFTWARE"] Apache/2.4.46 (Win64) PHP/5.6.22 _SERVER["SERVER_NAME"] localhost _SERVER["SERVER_ADDR"] 127.0.0.1 _SERVER["SERVER_PORT"] 80 _SERVER["REMOTE_ADDR"] 127.0.0.1 _SERVER["DOCUMENT_ROOT"] C:/Apache24/htdocs _SERVER["REQUEST_SCHEME"] http _SERVER["CONTEXT_PREFIX"] no value _SERVER["CONTEXT_DOCUMENT_ROOT"] C:/Apache24/htdocs _SERVER["SERVER_ADMIN"] admin@example.com _SERVER["SCRIPT_FILENAME"] C:/Apache24/htdocs/teste.php _SERVER["REMOTE_PORT"] 61292 _SERVER["GATEWAY_INTERFACE"] CGI/1.1 _SERVER["SERVER_PROTOCOL"] HTTP/1.1 _SERVER["REQUEST_METHOD"] GET _SERVER["QUERY_STRING"] no value _SERVER["REQUEST_URI"] /teste.php _SERVER["SCRIPT_NAME"] /teste.php _SERVER["PHP_SELF"] /teste.php _SERVER["REQUEST_TIME_FLOAT"] 1605720446.991 _SERVER["REQUEST_TIME"] 1605720446 _SERVER["argv"] Array ( ) _SERVER["argc"] 0 _ENV["ALLUSERSPROFILE"] C:\ProgramData _ENV["APPDATA"] C:\Windows\syswow64\config\systemprofile\AppData\Roaming _ENV["CommonProgramFiles"] C:\Program Files\Common Files _ENV["CommonProgramFiles(x86)"] C:\Program Files (x86)\Common Files _ENV["CommonProgramW6432"] C:\Program Files\Common Files _ENV["COMPUTERNAME"] MRJO50214410 _ENV["ComSpec"] C:\Windows\system32\cmd.exe _ENV["FP_NO_HOST_CHECK"] NO _ENV["JAVA_TOOL_OPTIONS"] -Duser.timezone=America/Sao_Paulo _ENV["LOCALAPPDATA"] C:\Windows\syswow64\config\systemprofile\AppData\Local _ENV["NUMBER_OF_PROCESSORS"] 2 _ENV["OS"] Windows_NT _ENV["Path"] C:\PHP\;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x64;C:\Program Files\MySQL\MySQL Utilities 1.6\; _ENV["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC _ENV["PHPRC"] C:\PHP\ _ENV["PROCESSOR_ARCHITECTURE"] AMD64 _ENV["PROCESSOR_IDENTIFIER"] Intel64 Family 6 Model 58 Stepping 9, GenuineIntel _ENV["PROCESSOR_LEVEL"] 6 _ENV["PROCESSOR_REVISION"] 3a09 _ENV["ProgramData"] C:\ProgramData _ENV["ProgramFiles"] C:\Program Files _ENV["ProgramFiles(x86)"] C:\Program Files (x86) _ENV["ProgramW6432"] C:\Program Files _ENV["PSModulePath"] C:\Windows\system32\WindowsPowerShell\v1.0\Modules\ _ENV["PUBLIC"] C:\Users\Public _ENV["SystemDrive"] C: _ENV["SystemRoot"] C:\Windows _ENV["TEMP"] C:\Windows\TEMP _ENV["TMP"] C:\Windows\TEMP _ENV["UATDATA"] C:\Windows\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77 _ENV["USERDOMAIN"] CORREIOSNET _ENV["USERNAME"] MRJO50214410$ _ENV["USERPROFILE"] C:\Windows\syswow64\config\systemprofile _ENV["windir"] C:\Windows _ENV["windows_tracing_flags"] 3 _ENV["windows_tracing_logfile"] C:\BVTBin\Tests\installpackage\csilogfile.log _ENV["WIX"] C:\Program Files (x86)\WiX Toolset v3.11\ _ENV["AP_PARENT_PID"] 1904 PHP Credits
      PHP Group Thies C. Arntzen, Stig Bakken, Shane Caraveo, Andi Gutmans, Rasmus Lerdorf, Sam Ruby, Sascha Schumann, Zeev Suraski, Jim Winstead, Andrei Zmievski Language Design & Concept Andi Gutmans, Rasmus Lerdorf, Zeev Suraski, Marcus Boerger PHP Authors Contribution Authors Zend Scripting Language Engine Andi Gutmans, Zeev Suraski, Stanislav Malyshev, Marcus Boerger, Dmitry Stogov, Xinchen Hui, Nikita Popov Extension Module API Andi Gutmans, Zeev Suraski, Andrei Zmievski UNIX Build and Modularization Stig Bakken, Sascha Schumann, Jani Taskinen Windows Port Shane Caraveo, Zeev Suraski, Wez Furlong, Pierre-Alain Joye, Anatol Belski Server API (SAPI) Abstraction Layer Andi Gutmans, Shane Caraveo, Zeev Suraski Streams Abstraction Layer Wez Furlong, Sara Golemon PHP Data Objects Layer Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky Output Handler Zeev Suraski, Thies C. Arntzen, Marcus Boerger, Michael Wallner SAPI Modules Contribution Authors AOLserver Sascha Schumann Apache 1.3 (apache_hooks) Rasmus Lerdorf, Zeev Suraski, Stig Bakken, David Sklar, George Schlossnagle, Lukas Schroeder Apache 1.3 Rasmus Lerdorf, Zeev Suraski, Stig Bakken, David Sklar Apache 2.0 Filter Sascha Schumann, Aaron Bannert Apache 2.0 Handler Ian Holsman, Justin Erenkrantz (based on Apache 2.0 Filter code) Caudium / Roxen David Hedbor CGI / FastCGI Rasmus Lerdorf, Stig Bakken, Shane Caraveo, Dmitry Stogov CLI Edin Kadribasic, Marcus Boerger, Johannes Schlueter, Moriyoshi Koizumi, Xinchen Hui Continuity Alex Leigh (based on nsapi code) Embed Edin Kadribasic FastCGI Process Manager Andrei Nigmatulin, dreamcat4, Antony Dovgal, Jerome Loyet ISAPI Andi Gutmans, Zeev Suraski litespeed George Wang NSAPI Jayakumar Muthukumarasamy, Uwe Schindler phpdbg Felipe Pena, Joe Watkins, Bob Weinand phttpd Thies C. Arntzen pi3web Holger Zimmermann Sendmail Milter Harald Radi thttpd Sascha Schumann tux Sascha Schumann WebJames Alex Waugh Module Authors Module Authors BC Math Andi Gutmans Bzip2 Sterling Hughes Calendar Shane Caraveo, Colin Viebrock, Hartmut Holzgraefe, Wez Furlong COM and .Net Wez Furlong ctype Hartmut Holzgraefe cURL Sterling Hughes Date/Time Support Derick Rethans DB-LIB (MS SQL, Sybase) Wez Furlong, Frank M. Kromann DBA Sascha Schumann, Marcus Boerger DOM Christian Stocker, Rob Richards, Marcus Boerger enchant Pierre-Alain Joye, Ilia Alshanetsky ereg Rasmus Lerdorf, Jim Winstead, Jaakko Hyvätti EXIF Rasmus Lerdorf, Marcus Boerger fileinfo Ilia Alshanetsky, Pierre Alain Joye, Scott MacVicar, Derick Rethans Firebird driver for PDO Ard Biesheuvel FTP Stefan Esser, Andrew Skalski GD imaging Rasmus Lerdorf, Stig Bakken, Jim Winstead, Jouni Ahto, Ilia Alshanetsky, Pierre-Alain Joye, Marcus Boerger GetText Alex Plotnick GNU GMP support Stanislav Malyshev Iconv Rui Hirokawa, Stig Bakken, Moriyoshi Koizumi IMAP Rex Logan, Mark Musone, Brian Wang, Kaj-Michael Lang, Antoni Pamies Olive, Rasmus Lerdorf, Andrew Skalski, Chuck Hagenbuch, Daniel R Kalowsky Input Filter Rasmus Lerdorf, Derick Rethans, Pierre-Alain Joye, Ilia Alshanetsky InterBase Jouni Ahto, Andrew Avdeev, Ard Biesheuvel Internationalization Ed Batutis, Vladimir Iordanov, Dmitry Lakhtyuk, Stanislav Malyshev, Vadim Savchuk, Kirti Velankar JSON Omar Kilani, Scott MacVicar LDAP Amitay Isaacs, Eric Warnke, Rasmus Lerdorf, Gerrit Thomson, Stig Venaas LIBXML Christian Stocker, Rob Richards, Marcus Boerger, Wez Furlong, Shane Caraveo mcrypt Sascha Schumann, Derick Rethans MS SQL Frank M. Kromann Multibyte String Functions Tsukada Takuya, Rui Hirokawa MySQL driver for PDO George Schlossnagle, Wez Furlong, Ilia Alshanetsky, Johannes Schlueter MySQL Zeev Suraski, Zak Greant, Georg Richter, Andrey Hristov MySQLi Zak Greant, Georg Richter, Andrey Hristov, Ulf Wendel MySQLnd Andrey Hristov, Ulf Wendel, Georg Richter, Johannes Schlüter OCI8 Stig Bakken, Thies C. Arntzen, Andy Sautins, David Benson, Maxim Maletsky, Harald Radi, Antony Dovgal, Andi Gutmans, Wez Furlong, Christopher Jones, Oracle Corporation ODBC driver for PDO Wez Furlong ODBC Stig Bakken, Andreas Karajannis, Frank M. Kromann, Daniel R. Kalowsky OpenSSL Stig Venaas, Wez Furlong, Sascha Kettler, Scott MacVicar Oracle (OCI) driver for PDO Wez Furlong pcntl Jason Greene, Arnaud Le Blanc Perl Compatible Regexps Andrei Zmievski PHP Archive Gregory Beaver, Marcus Boerger PHP Data Objects Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky PHP hash Sara Golemon, Rasmus Lerdorf, Stefan Esser, Michael Wallner, Scott MacVicar Posix Kristian Koehntopp PostgreSQL driver for PDO Edin Kadribasic, Ilia Alshanetsky PostgreSQL Jouni Ahto, Zeev Suraski, Yasuo Ohgaki, Chris Kings-Lynne Pspell Vlad Krupin Readline Thies C. Arntzen Recode Kristian Koehntopp Reflection Marcus Boerger, Timm Friebe, George Schlossnagle, Andrei Zmievski, Johannes Schlueter Sessions Sascha Schumann, Andrei Zmievski Shared Memory Operations Slava Poliakov, Ilia Alshanetsky SimpleXML Sterling Hughes, Marcus Boerger, Rob Richards SNMP Rasmus Lerdorf, Harrie Hazewinkel, Mike Jackson, Steven Lawrance, Johann Hanne, Boris Lytochkin SOAP Brad Lafountain, Shane Caraveo, Dmitry Stogov Sockets Chris Vandomelen, Sterling Hughes, Daniel Beulshausen, Jason Greene SPL Marcus Boerger, Etienne Kneuss SQLite 3.x driver for PDO Wez Furlong SQLite3 Scott MacVicar, Ilia Alshanetsky, Brad Dewar Sybase-CT Zeev Suraski, Tom May, Timm Friebe System V Message based IPC Wez Furlong System V Semaphores Tom May System V Shared Memory Christian Cartus tidy John Coggeshall, Ilia Alshanetsky tokenizer Andrei Zmievski, Johannes Schlueter WDDX Andrei Zmievski XML Stig Bakken, Thies C. Arntzen, Sterling Hughes XMLReader Rob Richards xmlrpc Dan Libby XMLWriter Rob Richards, Pierre-Alain Joye XSL Christian Stocker, Rob Richards Zip Pierre-Alain Joye, Remi Collet Zlib Rasmus Lerdorf, Stefan Roehrich, Zeev Suraski, Jade Nicoletti, Michael Wallner PHP Documentation Authors Mehdi Achour, Friedhelm Betz, Antony Dovgal, Nuno Lopes, Hannes Magnusson, Georg Richter, Damien Seguy, Jakub Vrana, Adam Harvey, Peter Cowburn Editor Philip Olson User Note Maintainers Daniel P. Brown, Thiago Henrique Pojda Other Contributors Previously active authors, editors and other contributors are listed in the manual. PHP Quality Assurance Team Ilia Alshanetsky, Joerg Behrens, Antony Dovgal, Stefan Esser, Moriyoshi Koizumi, Magnus Maatta, Sebastian Nohn, Derick Rethans, Melvyn Sopacua, Jani Taskinen, Pierre-Alain Joye, Dmitry Stogov, Felipe Pena, David Soria Parra, Stanislav Malyshev, Julien Pauli, Stephen Zarkos, Anatol Belski, Remi Collet, Ferenc Kovacs Websites and Infrastructure team PHP Websites Team Rasmus Lerdorf, Hannes Magnusson, Philip Olson, Lukas Kahwe Smith, Pierre-Alain Joye, Kalle Sommer Nielsen, Peter Cowburn, Adam Harvey, Ferenc Kovacs, Levi Morrison Event Maintainers Damien Seguy, Daniel P. Brown Network Infrastructure Daniel P. Brown Windows Infrastructure Alex Schoenmaker  
       
       
       
       
×

Important Information

Ao usar o fórum, você concorda com nossos Terms of Use.