Jump to content

Basic PHP/MySQL Code problem


ZandarGlass

Recommended Posts

My apologies if I've placed this in the wrong section. It concerns a basic connection to n SQL database, and doing a simple count of the records.

I'm learning from DAVID POWERS PHPSOLOUTIONS book. Examples in his book show connecting to the local db differently than my host wants me to connect, and I believe therin lies the issue. If I can figure out the method or problem I'm having, I'll be very thankful.
 

I'm just connecting to a database, running one query, and counting records. The code that I altered, and I am trying to use, looks like this:
 

 

<?php
//Sample Database Connection Syntax for PHP and MySQL.
include ('/includes/imageconn.inc.php');
include ('/includes/imagetableconn.inc.php');

mysql_select_db($dbname);

# Check If Record Exists

$sql = "SELECT * FROM $usertable";

$result = $conn->query($sql) or die(mysqli_error());

$numrows = $result->num_rows;


?>
<html>
<head>
<title>PHP Test</title>
</head>
<body>
<?php echo $numrows; ?>
</body>
</html>

-----------------------------------------------------------------------

 

My imageconn.inc.php file holds a set of variables needed for the connection. I have verified it works (online, where I want), using other simple pages I made.

 

This is the imagetableconn.inc.php file. It contains one line of code (which also works in the test file the host sent me).

 

$conn = mysql_connect($hostname, $username, $password) or die ('Error connecting to mysql');

 

-------------------------------------------------------------------------

 

I'm pretty sure the problem lies in this line (which is from the BOOK, which I can't figure out how to modify for my online needs):
 

$result = $conn->query($sql) or die(mysqli_error());

 

 

My error message: Fatal error: Call to a member function query() on a non-object in D:\Hosting\4641474\html\testimagedb1.php on line 12
 

Link to comment
Share on other sites

You're mixing procedural code with object oriented code!

You're also mixing mysql_* with mysqli_*

 

Try to connect with this!

$conn =  new mysqli($hostname, $username, $password, $dbname);
// check if connection attempt returned an error number
if(mysqli_connect_errno()){
     echo 'Error connecting to database!';
     exit; # kill script; couldn't connect to database
}

Delete this because we're are not using msyql_*   we're using mysqli, which is what you want to use! 

mysql_select_db($dbname);
Edited by objnoob
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.