[DoxramosPS]

After my Mysqli call the remainder of my webpage is not showing.

   $db = new mysqli($host, $user, $pass, $dbname);
	if(mysqli_connect_errno())
{
    die('The connection to the database could not be established.');
}	
$query = 'SELECT * FROM pages where name="Index"';
$result = $db->query($query);
$total_results = $result->num_rows;
while ($row = $result->fetch_object())
{				
				echo '<title>';
	            echo $row->title;
				echo '</title>';
            }
				$result->free();
?>

I'm not sure how to describe it other than that, so attached are 2000 words.
With MySQLI
Without MySQLI
Thanks for any help.

[CTphpnwb]

Check your error log.
$row should be an array, not an object.
http://www.php.net/m...fetch-array.php

[DoxramosPS]

Any idea why this doesn't work?

<?php
$link = mysqli_connect("$server", "$user", "$pass", "$webdb");

if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

$query = "SELECT title FROM pages WHERE name='Index'";
$result = mysqli_query($link, $query);

$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
echo '<title>';
printf ("%s (%s)\n", $row["title"]);
echo '</title>';

mysqli_free_result($result);

mysqli_close($link);
?>

The end goal is to have the title pulled from the database which I was able to succeed with mysql connections, but having issues with mysqli doing the same thing.
Also; I echoed the query and the row['title'] without the html inside and it is pulling the info and performing the query successfully.

This post has been edited by DoxramosPS: 14 October 2012 - 01:48 PM

[CTphpnwb]

Why is printf set to print two strings when you only have one?

[DoxramosPS]

That's because I screwed it up when looking through. It's resolved now where I used a simple echo rather then a printf

[Dormilich]

tip: var_dump() can output any datatype for debugging.