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
