insert form into sql

truck7758 · February 21, 2008

Hi all,

Can anyone see why this form wont insert the data into my sql database? When i click submit i get a blank page and the data doesn't submit.

<?php

if (!isset($_POST['submit'])) { // if page is not submitted to itself echo the form

?>

<p>

</a>

Date: <? print strftime("%d/%m/%Y"); ?>

</p>

<h1 align="center">Create New Supplier</h1>

<table>

<tr>

<td align="center">Website:</td>

</tr>

<tr>

</tr>

<tr>

<td align="center">Account No:</td>

<td align="center">Account Manager:</td>

<td align="center">Account Login:</td>

<td align="center">Account Password:</td>

</tr>

<tr>

</tr>

<tr>

<td align="center">Address:</td>

<td align="center">Other Info:</td>

</tr>

</tr>

</table>

<input type="submit" value="Submit" name="submit" STYLE="font-family:sans-serif; font-size:large;

font-style:italic; background:red; color:black; width:6em; height:1.5em">

</form>

<?

} else {

$host = "localhost";

$username = "username";

$password = "password";

$database = "orders";

$mysqli = mysqli_connect('localhost','uname','password');

$mysqli->select_db('supplier');

$name = $_POST["name"];

$telno = $_POST["telno"];

$fax = $_POST["fax"];

$website = $_POST["website"];

$email = $_POST["email"];

$accnumber = $_POST["accnumber"];

$accmanager = $_POST["accmanager"];

$acclogin = $_POST["acclogin"];

$accpassword = $_POST["accpassword"];

$address = $_POST["address"];

$other = $_POST["other"];

$name = addslashes($name);

$telno= addslashes($telno);

$fax = addslashes($fax);

$website= addslashes($website);

$email= addslashes($email);

$accnumber= addslashes($accnumber);

$accmanager = addslashes($accmanager);

$acclogin = addslashes($acclogin);

$accpassword = addslashes($accpassword);

$address = addslashes($address);

$other = addslashes($other);

if(!$mysqli)

{

echo " Error: could not connect to database.";

exit;

}

$sql="INSERT INTO `supplier`

(`name`,

`address`,

`telno`,

`fax`,

`website`,

`accountno`,

`accountmanager`,

`email`,

`accountlogin`,

`accountpwd`,

`otherinfo`)

VALUES ('".$name."',

'".$address."',

'".$telno."',

'".$fax."',

'".$website."',

'".$accnumber."',

'".$accmanager."',

'".$email."',

'".$acclogin."',

'".$accpassword."',

'".$other."')";

$result = mysqli_query($mysqli, $sql, MYSQLI_USE_RESULT);

if($result)

{

echo mysqli_affected_rows($mysqli)." .Supplier Table Updated.";

}

?>

Cheers,

Mike

themistral · February 21, 2008

Try echoing or printing out the query and then try running it in the database - you may have typed a wrong fieldname or something.

truck7758 · February 21, 2008

Hi,

I have just done this in mysql and it inserted into the table:

INSERT INTO `supplier`
(`name`,
`address`,
`telno`,
`fax`,
`website`,
`accountno`,
`accountmanager`,
`email`,
`accountlogin`,
`accountpwd`,
`otherinfo`)
values
("test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test");

i also echo'd $sql and i get the following:

INSERT INTO `supplier` (`name`, `address`, `telno`, `fax`, `website`, `accountno`, `accountmanager`, `email`, `accountlogin`, `accountpwd`, `otherinfo`) VALUES ('mike', '25 dkfhj,kf wffjkk fefe fedfgggdf m1 1jg', '12345678', '87654321', 'www.test.co.uk', '7758', 'me', 'michael@test.co.uk', 'test', '1234', 'asefjsd sdfgvsdfgdfg sdfgsdf')

This seems correct to me.

Thanks,

Mike

aschk · February 21, 2008

Your script is setting the $user/$pass variables etc, but never actually uses them.

See your following snippet of code:

$username = "username";
$password = "password";
$database = "orders";

$mysqli = mysqli_connect('localhost','uname','password');

Therefore I expect that you're not actually connecting to the database in the first place. I would verify this as it seems inconsistent.

Also, you might consider using mysqli_error() to see what your error is (i.e. why it's not working...)

truck7758 · February 21, 2008

Hi aschk,

how do i go about using mysqli_error?

Thanks,

Mike

truck7758 · February 21, 2008

ok, underneath:

if($result)

i inserted the following:

printf("Errormessage: %s\n", mysqli_error($result));

Now when i click submit it says:

4294967295 .Supplier Table Updated.

Any ideas?

Cheers,

Mike

aschk · February 21, 2008

Specify the connection to mysqli_error

e.g.

echo mysqli_error($mysqli);

What does MYSQLI_USE_RESULT do?

truck7758 · February 21, 2008

i have just tried adding echo mysqli_error($mysqli); underneath if($result).

I get the same message as before.

im not sure what MYSQLI_USE_RESULT does but i just took it out and it makes no difference.

Cheers,

Mike

truck7758 · February 21, 2008

Any ideas???

thanks

Sign In

insert form into sql

Recommended Posts

truck7758

Link to comment

Share on other sites

themistral

Link to comment

Share on other sites

truck7758

Link to comment

Share on other sites

aschk

Link to comment

Share on other sites

truck7758

Link to comment

Share on other sites

truck7758

Link to comment

Share on other sites

aschk

Link to comment

Share on other sites

truck7758

Link to comment

Share on other sites

truck7758

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information