By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,051 Members | 1,258 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,051 IT Pros & Developers. It's quick & easy.

got trouble connection to mysql5 using php5...need help

P: n/a
my environment:
===========================
-php ver 5.2.0
-mysql 5
-windows xp
-apache 2
-all of these are on the same machine

my code:
==========================
<html>
<body>

<?php
echo "browsing users";

$conn=new mysqli("localhost","dba","masterkey","tms");
if(mysqli_connect_errno()){
echo "Connection Error";
exit;
}

$query="select username from reg_user";
$result=$conn->query($query);
$num_results=$result->num_rows;

echo "<p>num of records found: ".$num_results."</p>";
for($i=0; $i<$num_results; $i++){
$row=$result->fetch_assoc();
echo "<br/Username: ";
echo stripslashes($row['username']);
}
$result->free();
$conn->close();
?>

</body>
</html>
problem
==========================
-if i run the code the only thing that shows is "browsing users".
-this line >echo "<p>num of records found: ".$num_results."</p>"; <<
is not also showing up
-is there something wrong with my code...logic..or syntax?
-or i wasnt able to obtain communication with mysql that's why nothing
appears. and if so, what have gone wrong why i cannot to mysql?

Jan 18 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
so**********@yahoo.com wrote:
my environment:
===========================
-php ver 5.2.0
-mysql 5
-windows xp
-apache 2
-all of these are on the same machine

my code:
==========================
<html>
<body>

<?php
echo "browsing users";

$conn=new mysqli("localhost","dba","masterkey","tms");
if(mysqli_connect_errno()){
echo "Connection Error";
exit;
}

$query="select username from reg_user";
$result=$conn->query($query);
$num_results=$result->num_rows;

echo "<p>num of records found: ".$num_results."</p>";
for($i=0; $i<$num_results; $i++){
$row=$result->fetch_assoc();
echo "<br/Username: ";
echo stripslashes($row['username']);
}
$result->free();
$conn->close();
?>

</body>
</html>
problem
==========================
-if i run the code the only thing that shows is "browsing users".
-this line >echo "<p>num of records found: ".$num_results."</p>"; <<
is not also showing up
-is there something wrong with my code...logic..or syntax?
-or i wasnt able to obtain communication with mysql that's why nothing
appears. and if so, what have gone wrong why i cannot to mysql?
Which Database abstraction layer are you using?

$conn=new mysqli("localhost","dba","masterkey","tms");
is only valid if some classdefinition of mysqli exists.

And did you try to connect to the database without the abstractionlayer?
Also check if you updated your php.ini so it uses mysqli.dll instead of
mysql.dll.
In such cases I always check first if things connect succesfull by using php
native commands first before using the abstractionlayer.

Regards,
Erwin Moller
Jan 18 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.