1--TEST-- 2mysql_query() 3--SKIPIF-- 4<?php 5require_once('skipif.inc'); 6require_once('skipifconnectfailure.inc'); 7?> 8--FILE-- 9<?php 10include_once("connect.inc"); 11 12$tmp = NULL; 13$link = NULL; 14 15if (!is_null($tmp = @mysql_query())) 16 printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 17 18if (false !== ($tmp = @mysql_query($link))) 19 printf("[002] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); 20 21require('table.inc'); 22 23if (NULL !== ($tmp = @mysql_query("SELECT 1 AS a", $link, "foo"))) 24 printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 25 26if (false !== ($tmp = mysql_query('THIS IS NOT SQL', $link))) 27 printf("[004] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); 28 29if (false !== ($tmp = mysql_query("SELECT 'this is sql but with backslash g'\g", $link))) 30 printf("[005] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); 31 32if ((0 === mysql_errno($link)) || ('' == mysql_error($link))) 33 printf("[006] mysql_errno()/mysql_error should return some error\n"); 34 35if (!$res = mysql_query("SELECT 'this is sql but with semicolon' AS valid ; ", $link)) 36 printf("[007] [%d] %s\n", mysql_errno($link), mysql_error($link)); 37 38var_dump(mysql_fetch_assoc($res)); 39mysql_free_result($res); 40 41if (!$res = mysql_query("SELECT 'a' AS ''", $link)) 42 printf("[007a] [%d] %s\n", mysql_errno($link), mysql_error($link)); 43 44var_dump($tmp = mysql_fetch_assoc($res)); 45var_dump($tmp[""]); 46mysql_free_result($res); 47 48if (false !== ($res = mysql_query("SELECT 'this is sql but with semicolon' AS valid ; SHOW VARIABLES", $link))) 49 printf("[008] [%d] %s\n", mysql_errno($link), mysql_error($link)); 50 51if (mysql_query('DROP PROCEDURE IF EXISTS p', $link)) { 52 // let's try to play with stored procedures 53 if (mysql_query('CREATE PROCEDURE p(OUT ver_param VARCHAR(25)) BEGIN SELECT VERSION() INTO ver_param; END;', $link)) { 54 $res = mysql_query('CALL p(@version)', $link); 55 $res = mysql_query('SELECT @version AS p_version', $link); 56 $tmp = mysql_fetch_assoc($res); 57 if (!isset($tmp['p_version']) || ('' == $tmp['p_version'])) { 58 printf("[009] Result seems wrong, dumping\n"); 59 var_dump($tmp); 60 } 61 if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && !is_unicode($tmp['p_version'])) { 62 printf("[010] Expecting unicode string, dumping\n"); 63 var_dump($tmp); 64 } 65 mysql_free_result($res); 66 } else { 67 printf("[011] [%d] %s\n", mysql_errno($link), mysql_error($link)); 68 } 69 70 mysql_query('DROP FUNCTION IF EXISTS f', $link); 71 if (mysql_query('CREATE FUNCTION f( ver_param VARCHAR(25)) RETURNS VARCHAR(25) DETERMINISTIC RETURN ver_param;', $link)) { 72 $res = mysql_query('SELECT f(VERSION()) AS f_version', $link); 73 $tmp = mysql_fetch_assoc($res); 74 if (!isset($tmp['f_version']) || ('' == $tmp['f_version'])) { 75 printf("[012] Result seems wrong, dumping\n"); 76 var_dump($tmp); 77 } 78 if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && !is_unicode($tmp['f_version'])) { 79 printf("[013] Expecting unicode string, dumping\n"); 80 var_dump($tmp); 81 } 82 mysql_free_result($res); 83 } else { 84 printf("[014] [%d] %s\n", mysql_errno($link), mysql_error($link)); 85 } 86} 87 88mysql_close($link); 89 90if (false !== ($tmp = mysql_query("SELECT id FROM test", $link))) 91 printf("[011] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); 92 93print "done!"; 94?> 95--CLEAN-- 96<?php 97require_once('connect.inc'); 98 99// connect + select_db 100if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) { 101 printf("[clean] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 102 $host, $myhost, $user, $db, $port, $socket); 103} 104 105if (!mysql_query('DROP TABLE IF EXISTS test', $link)) { 106 printf("[clean] Failed to drop test table: [%d] %s\n", mysql_errno($link), mysql_error($link)); 107} 108 109/* MySQL server may not support this - ignore errors */ 110@mysql_query('DROP PROCEDURE IF EXISTS p', $link); 111@mysql_query('DROP FUNCTION IF EXISTS f', $link); 112 113mysql_close($link); 114?> 115--EXPECTF-- 116Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d 117array(1) { 118 [%u|b%"valid"]=> 119 %unicode|string%(30) "this is sql but with semicolon" 120} 121array(1) { 122 [%u|b%""]=> 123 %unicode|string%(1) "a" 124} 125%unicode|string%(1) "a" 126 127Warning: mysql_query(): %d is not a valid MySQL-Link resource in %s on line %d 128done! 129
