How to extract array contents?

conjurer

Hi, trying to get connected to a database I have set up and see the contents.

I got some code setup and it seems to be connecting, but the output just gives the array # and the word array like this:

User: Conjurer - Password: 3x1yzn1

Attempting to connect to database

Connected successfully! <<<--- this line prints even when I don't connect!
Number of rows: 231
0: Array
1: Array
2: Array
3: Array
4: Array
5: Array
6: Array
7: Array
8: Array
9: Array

The code I am using is here:

<?php
session_start();
//create short variable names
$username ="Conjurer";
$passwd = "3x1yzn1";

// include function files for this application
//require_once('includes/member_fns.php5');
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
	<title>Test for OMGMA Connection</title>

</head>

<body>
	<?php
	echo "<p>User: $username   -    Password:   $passwd </p>";
	echo "<p>Attempting to connect to database</p>";
	 $db= new mysqli("localhost", "omgma_omgmauser", "3x1yzn1", "omgma_members") or die ('I cannot connect to the database because: ' . mysql_error());

	if ($db)
{
	echo "<p>Connected successfully!</p>";  //this seems to print whether I connect or not!
		}
else
{	echo 	 'Error: could not connect to database @ line 29';
}

$query = "select user_id, last_name, first_name from directory ";
$result = mysqli_query($db, $query);
$num_results = mysqli_num_rows($result);
echo "<p>Number of rows: $num_results</p>";

for ($i=0; $i <10; $i++)
{
	$row = mysqli_fetch_assoc($result);
	echo "<p>$i: $row</p>";
}

?>


</body>
</html>

My select query was to pull three fields: user_id, last_name, first_name

What do I need to change so I can see the first few rows of these three fields?

Also, why is this test for the connection not working? It executes the echo "<p>Connected successfully!</p>"; whether I did or didn't connect successfully.


	if ($db)
{
	echo "<p>Connected successfully!</p>";  //this seems to print whether I connect or not!
		}
else
{	echo 	 'Error: could not connect to database @ line 29';
}

Thanks, getting close I think. 🙂

bpat1434

You can extract the information using [man]extract[/man] or properly reference it using $row['user_id'], $row['last_name'], $row['first_name'] and display those as needed.

As for connecting:
1.) How do you know you're not connecting?
2.) Try using: if(is_object($db)) { echo '<b>Connected Successfully</b>'; }
If an object isn't returned, it's not connected. You could also use if($db===false) { DIDN'T CONNECT }

conjurer

Thanks,

I know it wasn't connecting cause I tested it with a bad password. I got error messages about it not connecting but it was still printing the "Connected successfully" line.

Off to try this. Thanks for the link to extract.

conjurer

Ok - I used the names in the $row variables and that works when I connect.

I then tested the code where I want it to say if I connected or not. It doesn't work!
I put a bogus password in the following code:

	 $db= new mysqli("localhost", "omgma_omgmauser", "omXXXX3", "omgma_members") or die ('I cannot connect to the database because: ' . mysql_error());

	if(is_object($db))
{
	echo "<p>Connected successfully!</p>";
		}
else
{	echo 	 'Error: could not connect to database @ line 29';
}

When I run that I get an error message where it can't connect, then it prints the "Connected successfully!" line.
So it says it connected successfully whether it did or didn't!

Whys is that not working?

Here is the output I get with the wrong password:

Warning: mysqli::mysqli() [function.mysqli-mysqli]: (28000/1045): Access denied for user 'omgma_omgmauser'@'localhost' (using password: YES) in /home/omgma/public_html/Fresh_start/test.php5 on line 22

Connected successfully!

bpat1434

try directly testing its falsity.. if ($db==false) { NOT CONNECTED }