Re: [PHP-DB] $db=new mysqli fails while $db=mysqli_connect succeeds in PHP/MySQL 5
|Why don't you try this:| |?php| |$mysqli = new mysqli(localhost, my_user, my_password, world);| || |/* check connection */| |if (mysqli_connect_errno()) {| |printf(Connect failed: %s\n, mysqli_connect_error());| |exit();| |}| || |printf(Host information: %s\n, $mysqli-host_info);| || |/* close connection */| |$mysqli-close();| |?| I took this script from the php manual so why don't you try it and see what |mysqli_connect_error will do for you. In that you will debug the previous script and find out what went wrong.| Linux NG/Lists wrote: Goltsios Theodore wrote: Well if you are in the unix case then you should check if your php supports mysqli :-) . In either case unix or not you could use phpinfo: ?php phpinfo(); ? Oh, sorry, I thought I posted this before. Looks like I didn't. I'm pretty sure it supports mysqli: './configure' '--prefix=/usr/local/php5' '--with-config-file-path=/usr/local/etc/php5/cgi' '--with-xml' '--enable-bcmath' '--enable-calendar' '--with-curl' '--with-dom' '--with-dom-xslt' '--with-dom-exslt' '--enable-exif' '--with-swf=/usr/local/flash' '--enable-ftp' '--with-gd' '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr' '--with-xpm-dir=/usr/X11R6' '--with-gettext' '--with-imap=/usr/local/imap-2004g' '--enable-mbstring' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-mcrypt' '--with-mhash' '--enable-magic-quotes' '--with-mysqli' '--with-mysql=/usr' '--with-openssl' '--enable-discard-path' '--with-pear' '--with-pspell' '--enable-sockets' '--enable-track-vars' '--with-ttf' '--with-freetype-dir=/usr' '--enable-gd-native-ttf' '--with-zip' '--with-zlib' The 'mysqli_connect(...' call works, just not 'new mysqli(...' If mysqli wasn't supported, then both would fail, right? Whil This will show a lot useful information about what your web server and your php can or cannot do. Linux NG/Lists wrote: The book I'm working with (PHP MySQL Web Dev, Welling/Thompson) specifically defines the 'new mysqli' syntax. So I'm guessing I don't have something configured right? If one works the other should too. Your code here looks fine according to the manual (http://www.php.net/manual/en/function.mysqli-connect.php) - can you send us exactly what you have? OK, here's what I've got, cut and pasted directly out of the script: body ?php echo('Today is... ' . date('l, F dS Y. ').'br' ); ? ?php error_reporting(E_ALL); ini_set('display_errors','On'); ? ?php $db=new mysqli(localhost,whil,secret,test); echo '$db is:'.$db.':'; $conn = mysqli_connect(localhost,whil,secret,test); echo '$conn is:'.$conn.':'; ? /body 1. If I comment out the $db and echo $db lines, the next two lines, $conn and echo $conn generate the following: Today is... Monday, August 27th 2007. $conn is:Object id #1: 2. If I remove the $db and echo $db comments, I get the following: Today is... Monday, August 27th 2007. Fatal error: Call to undefined function new mysqli() in index_listtest.php on line 17 I'm soo puzzled. :) Whil
Re: [PHP-DB] $db=new mysqli fails while $db=mysqli_connect succeeds in PHP/MySQL 5
Reposting the code sorry: ?php $mysqli = new mysqli(localhost, my_user, my_password, world); /* check connection */ if (mysqli_connect_errno()) { printf(Connect failed: %s\n, mysqli_connect_error()); exit(); } printf(Host information: %s\n, $mysqli-host_info); /* close connection */ $mysqli-close(); ? Linux NG/Lists wrote: Goltsios Theodore wrote: Well if you are in the unix case then you should check if your php supports mysqli :-) . In either case unix or not you could use phpinfo: ?php phpinfo(); ? Oh, sorry, I thought I posted this before. Looks like I didn't. I'm pretty sure it supports mysqli: './configure' '--prefix=/usr/local/php5' '--with-config-file-path=/usr/local/etc/php5/cgi' '--with-xml' '--enable-bcmath' '--enable-calendar' '--with-curl' '--with-dom' '--with-dom-xslt' '--with-dom-exslt' '--enable-exif' '--with-swf=/usr/local/flash' '--enable-ftp' '--with-gd' '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr' '--with-xpm-dir=/usr/X11R6' '--with-gettext' '--with-imap=/usr/local/imap-2004g' '--enable-mbstring' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-mcrypt' '--with-mhash' '--enable-magic-quotes' '--with-mysqli' '--with-mysql=/usr' '--with-openssl' '--enable-discard-path' '--with-pear' '--with-pspell' '--enable-sockets' '--enable-track-vars' '--with-ttf' '--with-freetype-dir=/usr' '--enable-gd-native-ttf' '--with-zip' '--with-zlib' The 'mysqli_connect(...' call works, just not 'new mysqli(...' If mysqli wasn't supported, then both would fail, right? Whil This will show a lot useful information about what your web server and your php can or cannot do. Linux NG/Lists wrote: The book I'm working with (PHP MySQL Web Dev, Welling/Thompson) specifically defines the 'new mysqli' syntax. So I'm guessing I don't have something configured right? If one works the other should too. Your code here looks fine according to the manual (http://www.php.net/manual/en/function.mysqli-connect.php) - can you send us exactly what you have? OK, here's what I've got, cut and pasted directly out of the script: body ?php echo('Today is... ' . date('l, F dS Y. ').'br' ); ? ?php error_reporting(E_ALL); ini_set('display_errors','On'); ? ?php $db=new mysqli(localhost,whil,secret,test); echo '$db is:'.$db.':'; $conn = mysqli_connect(localhost,whil,secret,test); echo '$conn is:'.$conn.':'; ? /body 1. If I comment out the $db and echo $db lines, the next two lines, $conn and echo $conn generate the following: Today is... Monday, August 27th 2007. $conn is:Object id #1: 2. If I remove the $db and echo $db comments, I get the following: Today is... Monday, August 27th 2007. Fatal error: Call to undefined function new mysqli() in index_listtest.php on line 17 I'm soo puzzled. :) Whil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] $db=new mysqli fails while $db=mysqli_connect succeeds in PHP/MySQL 5
Well if you are in the unix case then you should check if your php supports mysqli :-) . In either case unix or not you could use phpinfo: ?php phpinfo(); ? This will show a lot useful information about what your web server and your php can or cannot do. Linux NG/Lists wrote: The book I'm working with (PHP MySQL Web Dev, Welling/Thompson) specifically defines the 'new mysqli' syntax. So I'm guessing I don't have something configured right? If one works the other should too. Your code here looks fine according to the manual (http://www.php.net/manual/en/function.mysqli-connect.php) - can you send us exactly what you have? OK, here's what I've got, cut and pasted directly out of the script: body ?php echo('Today is... ' . date('l, F dS Y. ').'br' ); ? ?php error_reporting(E_ALL); ini_set('display_errors','On'); ? ?php $db=new mysqli(localhost,whil,secret,test); echo '$db is:'.$db.':'; $conn = mysqli_connect(localhost,whil,secret,test); echo '$conn is:'.$conn.':'; ? /body 1. If I comment out the $db and echo $db lines, the next two lines, $conn and echo $conn generate the following: Today is... Monday, August 27th 2007. $conn is:Object id #1: 2. If I remove the $db and echo $db comments, I get the following: Today is... Monday, August 27th 2007. Fatal error: Call to undefined function new mysqli() in index_listtest.php on line 17 I'm soo puzzled. :) Whil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] $db=new mysqli fails while $db=mysqli_connect succeeds in PHP/MySQL 5
Goltsios Theodore wrote: Well if you are in the unix case then you should check if your php supports mysqli :-) . In either case unix or not you could use phpinfo: ?php phpinfo(); ? Oh, sorry, I thought I posted this before. Looks like I didn't. I'm pretty sure it supports mysqli: './configure' '--prefix=/usr/local/php5' '--with-config-file-path=/usr/local/etc/php5/cgi' '--with-xml' '--enable-bcmath' '--enable-calendar' '--with-curl' '--with-dom' '--with-dom-xslt' '--with-dom-exslt' '--enable-exif' '--with-swf=/usr/local/flash' '--enable-ftp' '--with-gd' '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr' '--with-xpm-dir=/usr/X11R6' '--with-gettext' '--with-imap=/usr/local/imap-2004g' '--enable-mbstring' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-mcrypt' '--with-mhash' '--enable-magic-quotes' '--with-mysqli' '--with-mysql=/usr' '--with-openssl' '--enable-discard-path' '--with-pear' '--with-pspell' '--enable-sockets' '--enable-track-vars' '--with-ttf' '--with-freetype-dir=/usr' '--enable-gd-native-ttf' '--with-zip' '--with-zlib' The 'mysqli_connect(...' call works, just not 'new mysqli(...' If mysqli wasn't supported, then both would fail, right? Whil This will show a lot useful information about what your web server and your php can or cannot do. Linux NG/Lists wrote: The book I'm working with (PHP MySQL Web Dev, Welling/Thompson) specifically defines the 'new mysqli' syntax. So I'm guessing I don't have something configured right? If one works the other should too. Your code here looks fine according to the manual (http://www.php.net/manual/en/function.mysqli-connect.php) - can you send us exactly what you have? OK, here's what I've got, cut and pasted directly out of the script: body ?php echo('Today is... ' . date('l, F dS Y. ').'br' ); ? ?php error_reporting(E_ALL); ini_set('display_errors','On'); ? ?php $db=new mysqli(localhost,whil,secret,test); echo '$db is:'.$db.':'; $conn = mysqli_connect(localhost,whil,secret,test); echo '$conn is:'.$conn.':'; ? /body 1. If I comment out the $db and echo $db lines, the next two lines, $conn and echo $conn generate the following: Today is... Monday, August 27th 2007. $conn is:Object id #1: 2. If I remove the $db and echo $db comments, I get the following: Today is... Monday, August 27th 2007. Fatal error: Call to undefined function new mysqli() in index_listtest.php on line 17 I'm soo puzzled. :) Whil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] $db=new mysqli fails while $db=mysqli_connect succeeds in PHP/MySQL 5
The book I'm working with (PHP MySQL Web Dev, Welling/Thompson) specifically defines the 'new mysqli' syntax. So I'm guessing I don't have something configured right? If one works the other should too. Your code here looks fine according to the manual (http://www.php.net/manual/en/function.mysqli-connect.php) - can you send us exactly what you have? OK, here's what I've got, cut and pasted directly out of the script: body ?php echo('Today is... ' . date('l, F dS Y. ').'br' ); ? ?php error_reporting(E_ALL); ini_set('display_errors','On'); ? ?php $db=new mysqli(localhost,whil,secret,test); echo '$db is:'.$db.':'; $conn = mysqli_connect(localhost,whil,secret,test); echo '$conn is:'.$conn.':'; ? /body 1. If I comment out the $db and echo $db lines, the next two lines, $conn and echo $conn generate the following: Today is... Monday, August 27th 2007. $conn is:Object id #1: 2. If I remove the $db and echo $db comments, I get the following: Today is... Monday, August 27th 2007. Fatal error: Call to undefined function new mysqli() in index_listtest.php on line 17 I'm soo puzzled. :) Whil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] $db=new mysqli fails while $db=mysqli_connect succeeds in PHP/MySQL 5
Linux NG/Lists wrote: From a php-general thread earlier: ?php $db=new mysqli('localhost','whil','secret','test'); ? generates: Fatal error: Call to undefined function new mysqli() in index.php on line 24 while ?php $conn = mysqli_connect(localhost,whil,secret,test); echo 'conn good: '.$conn.' :very good indeedbr'; ? generates success: conn good: Object id #1 :very good indeed The book I'm working with (PHP MySQL Web Dev, Welling/Thompson) specifically defines the 'new mysqli' syntax. So I'm guessing I don't have something configured right? If one works the other should too. Your code here looks fine according to the manual (http://www.php.net/manual/en/function.mysqli-connect.php) - can you send us exactly what you have? -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] $db=new mysqli fails while $db=mysqli_connect succeeds in PHP/MySQL 5
From a php-general thread earlier: ?php $db=new mysqli('localhost','whil','secret','test'); ? generates: Fatal error: Call to undefined function new mysqli() in index.php on line 24 while ?php $conn = mysqli_connect(localhost,whil,secret,test); echo 'conn good: '.$conn.' :very good indeedbr'; ? generates success: conn good: Object id #1 :very good indeed The book I'm working with (PHP MySQL Web Dev, Welling/Thompson) specifically defines the 'new mysqli' syntax. So I'm guessing I don't have something configured right? Whil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php