Jason Pruim wrote:
Okay... So I know this is a stupid question... But I've been staring at
my code for far too long and now it's still not working so I thought I
would show it to all of you and see if you can tell me where I'm being
stupid :)
this is dbmysqliconnect.php:
<?php
function dbmysqliconnect($server, $username, $password,
$database, $link) {
$link = mysqli_init();
mysqli_real_connect($link, $server, $username,
$password, $database) or die('could not connect: '.mysqli_connect_error());
if (mysqli_connect_errno($link)) {
printf("Connect failed: %s\n",
mysqli_connect_error($link));
exit();
}
return $link;
}
?>
this is a snipet of my index.php file:
<?PHP
include("php.ini.php");
include("defaults.php");
include("dbmysqliconnect.php");
include("notify_email.php");
include("send_email.php");
$link = dbmysqliconnect($server, $username, $password,
$database, $link);
//Do NOT insert or update sales rep database through this
method... Only included to be supplied to the notify_email function. JP
$salesRepID = $_POST['salesRepID'];
$stmt = mysqli_stmt_init($link);
//Create the statement
mysqli_stmt_prepare($stmt, "UPDATE database.table (
FName, LName, email,
phone, url, record,
subscribed, date,
IPAddress, Business,
Address1, City,
State, Zip,
Coffee, Meeting,
areaPlans)
VALUES
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
// Error checking. JP
echo "<BR>Print of post:<BR>";
print_R($_POST);
echo "<BR>dump of the statement:<BR>";
var_dump($stmt);
mysqli_stmt_bind_param($stmt, 'sssssssssssssssss',
$_POST['txtFName'],
$_POST['txtLName'], _POST['txtEmail'], $_POST['txtPhone'],
$_POST['txturl'], $_POST['record'],
$_POST['subscribed'],
$date, $_SERVER['REMOTE_ADDR'], $_POST['txtBusiness'],
$_POST['txtAddress1'], $_POST['txtCity'], $_POST['txtState'],
_POST['txtZip'],
$_POST['rdoCoffee'],
$_POST['rdoTime'], $_POST['areaPlans'])
or die(mysqli_error($link)); <--------LINE 67
echo "<BR>Dump of stmt:<BR>";
var_dump($stmt);
//Add the record
mysqli_stmt_execute($stmt) or die(mysqli_error($link));
printf("Error: %d.\n", mysqli_stmt_error($stmt));
printf("%d Row Inserted.\n", mysqli_stmt_affected_rows($stmt));
$check = mysqli_stmt_error($stmt);
echo "<BR>$checkdate<BR>";
notify_email($Record, $salesRepID);
?>
The error that I am getting is:
Warning: mysqli_stmt_bind_param() [function.mysqli-stmt-bind-param]:
invalid object or resource mysqli_stmt in
/public_html/purl/purlprocess.php on line 67
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near '( FName,
LName, email, phone, url, recor' at line 1
Am I just going crazy or is there something really wrong?
Okay.. I'm done... First stupid question of the year... Only 3,349,587
more to go for the year! :P
--
Jason Pruim
japruim@xxxxxxxxxx
616.399.2355
Maybe try enclosing your field names in backticks?
Jay
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
