Problems Insert New Customer

[phpboyhelp]

Hey

I have still having problems inserting a customer into the database. I have done everything i could think off.

Here is the errors that i am getting with the code below:

Error 1

Warning: mysqli_prepare() expects parameter 1 to be mysqli, resource given in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 28

Here is the code for it

$statement = mysqli_prepare($connection, $QUERY);

Error 2

Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, null given in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 42

Here is the code for it (The Problem is somewhere is this code)

mysqli_stmt_bind_param($statement,
			            "sssssssssss",   

						$_POST['title'],
						$_POST['name'],
						$_POST['surname'],
						$_POST['firstadd'],
						$_POST['secondadd'],
						$_POST['city'],
						$_POST['postcode'],
						$_POST['phone'],
						$_POST['email'],
						$_POST['user'],
						$_POST['password']);

Error 3

Warning: mysqli_stmt_errno() expects parameter 1 to be mysqli_stmt, null given in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 48

Here is the code for it (The Problem is again somewhere is this code)

switch(mysqli_stmt_errno($statement))
		{
			case 0:
					 $addcottageComplete = true;
			     	 $addcottageOutcomeMessage = "Customer " . $_POST['name'] . " added";
				 break;

		default:
				$addcottageComplete = true;
		    	$addcottageOutcomeMessage = mysqli_stmt_error($statement);
		}

Error 4

Warning: mysqli_stmt_close() expects parameter 1 to be mysqli_stmt, null given in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 64

mysqli_stmt_close($statement);

Could anyone help me to fix these errors please.

[bradgrafelman]

Where is $connection defined? Show us that code.

[phpboyhelp]

This is the code foer the $Connection

//connect to mysql and select database

			$connection = mysql_connect ($dbhost, $dbuser, $dbpass);
			mysql_select_db("$db_name") or die ("Can  not connect to the database");

[bradgrafelman]

Well then there's your problem - you use the mysql library to connect, but then you're trying to use commands from the mysqli library afterwards.

[phpboyhelp]

What code do i need to insert into it to make it work. I tried everything but nothing works

[halojoy]

hello

It will not work to mix MySQL functions with MySQLi.
There are 2 different MySQL DATABASE handlers:

1. Normal mysql functions: http://docs.php.net/mysql

2. MySQLi — The MySQLi class
   http://docs.php.net/manual/en/book.mysqli.php
   Stands for: MySQL Improved Extension

To use MySQLi you have to connect using the Mysqli connection.
There are 2 ways to connect to the excellent MySQLi
( something like ~4 times faster than mysql, for some procedures! )

Either by using mysqli via mysqli_functions() or
by create an new mysqli-object:

<?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();
?>

Using as functions:

<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");

/* check connection */
if (!$link) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

printf("Host information: %s\n", mysqli_get_host_info($link));

/* close connection */
mysqli_close($link);
?>

http://docs.php.net/manual/en/mysqli.connect.php

regars 🙂
halojoy

[phpboyhelp]

I ma still having problems trying to insert a customer into the database. what code do i need to have to make it right

[laserlight]

What problems are you having, and what is the relevant current code?

[phpboyhelp]

i am having problems with the mysqli and the connection. i keep getting this error with this line of code

Error
Warning: mysqli_prepare() expects parameter 1 to be mysqli, resource given in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 28

$statement = mysqli_prepare($connection, $QUERY);

[laserlight]

Okay, it looks like you did not do the fix as bradgrafelman pointed out.

Instead of:

$connection = mysql_connect ($dbhost, $dbuser, $dbpass);
mysql_select_db("$db_name") or die ("Can  not connect to the database");

Try:

$connection = new mysqli($dbhost, $dbuser, $dbpass, $db_name);
$statement = $connection->prepare($QUERY);

[phpboyhelp]

I have done that and i have now got two errors:

Error 1
Warning: mysqli::mysqli(): (HY000/2005): Unknown MySQL server host 'mysql.cs07.cse.dmu.ac.uk:3306' (11004) in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 6

Here is the code:

$connection = new mysqli($dbhost, $dbuser, $dbpass, $db_name);

Error 2
Warning: mysqli_select_db() expects exactly 2 parameters, 1 given in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 8

Here is the code:

mysqli_select_db("$db_name") or die ("Can  not connect to the database");

[laserlight]

Warning: mysqli::mysqli(): (HY000/2005): Unknown MySQL server host 'mysql.cs07.cse.dmu.ac.uk:3306' (11004) in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 6

You're specifying the port number along with the host. If I remember correct, 3306 is the default port for MySQL, but you could try either:

$dbhost = 'mysql.cs07.cse.dmu.ac.uk';
$connection = new mysqli($dbhost, $dbuser, $dbpass, $db_name);

or

$dbhost = 'mysql.cs07.cse.dmu.ac.uk';
$dbport = 3306;
$connection = new mysqli($dbhost, $dbuser, $dbpass, $db_name, $dbport);

Warning: mysqli_select_db() expects exactly 2 parameters, 1 given in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 8

There is no need to use mysqli_select_db() since the database has been specified when creating the mysqli object. If you do not want to specify the database when creating the mysqli object, or want to select another database, write:

$connection->select_db($dbname);

[phpboyhelp]

Thanks for that, now just got to sort 3 problems:

Error 1
Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 49

Here is the code:

mysqli_stmt_bind_param($statement,
			            "ssssssissss",   

						$_POST['title'],
						$_POST['name'],
						$_POST['surname'],
						$_POST['firstadd'],
						$_POST['secondadd'],
						$_POST['city'],
						$_POST['postcode'],
						$_POST['phone'],
						$_POST['email'],
						$_POST['user'],
						$_POST['password']);

Error 2
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 52

Here is the code:

$db_name= mysql_query($QUERY, $connection);

Error 3
Warning: mysqli_stmt_errno() expects parameter 1 to be mysqli_stmt, boolean given in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 55

switch(mysqli_stmt_errno($statement))

[laserlight]

Error 1
Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 49

How did you get $statement in the first place?

Error 2
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 52

Why are you using mysql_query()? You need to get this clear: the MySQL extension and the MySQLi extension are two different extensions. You cannot use mysql_query() with mysqli.

Error 3
Warning: mysqli_stmt_errno() expects parameter 1 to be mysqli_stmt, boolean given in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 55

Again, how did you get $statement?

I suggest that you post the smallest and simplest script that demonstrates the problem. Posting snippets is usually okay, but here you keep on missing the important parts.

[phpboyhelp]

Here is the full code that i am using

<?php

		//require_once ("../../includes/connection/login_connect-cottage.php");

		//connect to mysql and select database
		$dbhost = 'host';
		$dbuser = 'user';
		$dbpass = 'pass';
		$db_name = 'p04294726db';
		$tbl_name = 'customers';
		$dbport = 3306;
		$connection = new mysqli($dbhost, $dbuser, $dbpass, $db_name, $dbport, $tbl_name); 

		$connection->select_db($db_name); 

		//select the database
		//$db_name = 'p04294726db';
		//mysql_select_db($db_name);

		//create the query
		$QUERY = "INSERT INTO $tbl_name (title, name, surname, addressone, addresstwo, city, postcode, phone, email, username, password; values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,))";

		$title = $_POST['title'];
		$forename = $_POST['name'];
    	$surname = $_POST['surname'];
		$addressone = $_POST['firstadd'];
		$addresstwo= $_POST['secondadd'];
		$city = $_POST['city'];
		$postcode = $_POST['postcode'];
    	$phone = $_POST['phone'];
		$email = $_POST['email'];
		$username = $_POST['user'];
		$password = $_POST['password'];

	$statement = $connection->prepare($QUERY); 

	mysqli_stmt_bind_param($statement,
		            "ssssssisss",   
					$_POST['title'],
					$_POST['name'],
					$_POST['surname'],
					$_POST['firstadd'],
					$_POST['secondadd'],
					$_POST['city'],
					$_POST['postcode'],
					$_POST['phone'],
					$_POST['email'],
					$_POST['user'],
					$_POST['password']);

	//execute the query
	$db_name= mysql_query($QUERY, $connection);


	switch(mysqli_stmt_errno($statement))
	{
		case 0:
				 $addcottageComplete = true;
		     	 $addcottageOutcomeMessage = "Customer " . $_POST['name'] . " added";
			 break;

		default:
				$addcottageComplete = true;
		    	$addcottageOutcomeMessage = mysqli_stmt_error($statement);
		}

		echo $addcottageOutcomeMessage;

		include ("index.html");

		mysqli_stmt_close($statement);

		mysqli_close($connection);
		?>

[laserlight]

You're looking to write something like this:

<?php
if (isset($_POST['title'], $_POST['name'], $_POST['surname'], $_POST['firstadd'],
          $_POST['secondadd'], $_POST['city'], POST['postcode'], $_POST['phone'],
          $_POST['email'], $_POST['user'], $_POST['password'])) {
    //connect to mysql and select database
    $dbhost = '****';
    $dbuser = '****';
    $dbpass = '****';
    $db_name = '****';
    $tbl_name = 'customers';
    $connection = new mysqli($dbhost, $dbuser, $dbpass, $db_name);

//create the query
$query = "INSERT INTO $tbl_name
          (title, name, surname, addressone, addresstwo, city,
           postcode, phone, email, username, `password`)
          VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

$statement = $connection->prepare($query);

$statement->bind_param('ssssssissss',
                       $_POST['title'],
                       $_POST['name'],
                       $_POST['surname'],
                       $_POST['firstadd'],
                       $_POST['secondadd'],
                       $_POST['city'],
                       $_POST['postcode'],
                       $_POST['phone'],
                       $_POST['email'],
                       $_POST['user'],
                       $_POST['password']);

$statement->execute();

$addcottageOutcomeMessage = '';
switch($statement->errno)
{
case 0:
    $addcottageComplete = true;
    $addcottageOutcomeMessage = "Customer " . htmlspecialchars($_POST['name']) . " added";
    break;

default:
    $addcottageComplete = true;
    $addcottageOutcomeMessage = $statement->error;
}

echo $addcottageOutcomeMessage;

include 'index.html';

$statement->close();
$connection->close();
} else {
    echo 'Missing input.';
}
?>

Notice how I consistently use the object oriented mysqli interface, and call execute() instead of mysql_query(). I also corrected the SQL statement itself, and checked that the incoming variables existed before using them.

[phpboyhelp]

I done that coding you said, but i have to two errors:

Error 1
Fatal error: Call to a member function bind_param() on a non-object in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 21

Here is the Code

$statement->bind_param('ssssssisss', (Line 21 is here)
                           $_POST['title'],
                           $_POST['name'],
                           $_POST['surname'],
                           $_POST['firstadd'],
                           $_POST['secondadd'],
                           $_POST['city'],
                           $_POST['postcode'],
                           $_POST['phone'],
                           $_POST['email'],
                           $_POST['user'],
                           $_POST['password']);

Error 2
Fatal error: Call to a member function execute() on a non-object in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 23

Here is the code

$statement->execute();

But here is the full code for extra help

<?php
if (isset($_POST['title'], $_POST['name'], $_POST['surname'], $_POST['firstadd'],
          $_POST['secondadd'], $_POST['city'], $_POST['postcode'], $_POST['phone'],
          $_POST['email'], $_POST['user'], $_POST['password'])) {
    //connect to mysql and select database
    $dbhost = ****
    $dbuser = ****
    $dbpass = ****
    $db_name = ****
    $tbl_name = ****
    $connection = new mysqli($dbhost, $dbuser, $dbpass,$db_name);

//create the query
$query = "INSERT INTO $tbl_name
          (title, name, surname, addressone, addresstwo, city,
           postcode, phone, email, username, password)
          VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

$statement = $connection->prepare($query);



$statement->execute();

$addcottageOutcomeMessage = 'Customer Added';
switch($statement->errno)
{
case 0:
    $addcottageComplete = true;
    $addcottageOutcomeMessage = "Customer " . htmlspecialchars($_POST['name']) . " added";
    break;

default:
    $addcottageComplete = true;
    $addcottageOutcomeMessage = $statement->error;
}

echo $addcottageOutcomeMessage;

include 'index.html';

$statement->close();
$connection->close();
} else {
    echo 'Missing input.';
}
?> 

[halojoy]

phpboyhelp wrote:

I done that coding you said, but i have to two errors:

Error 1
Fatal error: Call to a member function bind_param() on a non-object in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 21
Error 2
Fatal error: Call to a member function execute() on a non-object in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 23

Here is the code

$statement->execute();

Hello, fellow PHP User!!!
halojoy here to help you, again ....
🙂
The guy who helped you, laserlight, forgot to mention
you should always test your connection, for any errors.
He maybe took it for granted you should do this.
Or maybe that guy was in a big, big hurry .. for something important.

You can get the best help by reading PHP homepage Manual
with documentation of all MySQLi functions.
.... hmm Didn't I post you all the links, in MY FIRST POST here ???
Maybe I do remember wrong, or ... 😉
.. anyway:
http://docs.php.net/mysqli_connect

Regards 🙂
halojoy

<?php

// create a NEW mysqli connection Object
$connection = new mysqli($dbhost, $dbuser, $dbpass,$db_name);

/* check connection */
if (mysqli_connect_errno()) {
    printf( "Connect failed: %s\n", mysqli_connect_error() );
    exit();
}
/* else, if connection okay, print the info, just for fun !! */
printf( "Host information: %s\n", $mysqli->host_info );

//create the query
//$query = "INSERT INTO $tbl_name

?>