What exactly does this mean? First the error, then the code...
Fatal error: Call to a member function on a non-object in newmeeting.php on line 42
Code:
<?php
$db = mysql_connect("localhost","USERUSERUSER","PWPWPWPW");
mysql_select_db("DBDBDBDBDB") or die ("Cannot connect to database");
?>
<html>
<head>
<title>Input New Meeting</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<?php
if(isset($_POST['submit'])) {
if(!get_magic_quotes_gpc()) {
$_POST['meeting_name'] = addslashes($_POST['meeting_name']);
$_POST['city'] = addslashes($_POST['city']);
$_POST['address'] = addslashes($_POST['address']);
$_POST['dow'] = addslashes($_POST['dow']);
$_POST['time'] = addslashes($_POST['time']);
$_POST['codes'] = addslashes($_POST['codes']);
}
$dateadded = date('m d, Y');
$insert = "INSERT INTO meetings (
meeting_name,
city,
address,
dow,
time,
codes,
dateadded)
VALUES (
'".$_POST['meeting_name']."',
'".$_POST['city']."',
'".$_POST['address']."',
'".$_POST['dow']."',
'".$_POST['time']."',
'".$_POST['codes']."',
'$dateadded')";
$add_member = $db_object->query($insert);
if(DB::isError($add_member)) {
die($add_member->getMessage());
}
$db_object->disconnect();
?>
<h1>Meeting has been entered!</h1>
<p>Thank you for the update. The meeting is now in the database!</p>
<?php
}
else { // if form hasn't been submitted
?>
<h1>Input New Meeting</h1>
<form action="<?=$HTTP_SERVER_VARS['PHP_SELF']?>" method="post">
<table align="center" border="1"
cellspacing="0" cellpadding="3">
<tr><td>Meeting Name*:</td><td>
<input type="text" name="meeting_name" maxlength="100">
</td></tr>
<tr><td>City*:</td><td>
<input type="test" name="city" maxlength="25">
</td></tr>
<tr><td>Address*:</td><td>
<input type="test" name="address" maxlength="100">
</td></tr>
<tr><td>Day of Week*:</td><td>
<input type="text" name="dow" maxlength="10">
</td></tr>
<tr><td>Time:</td><td>
<input type="text" name="time" maxlength="10">
</td></tr>
<tr><td>Codes (see below):</td><td>
<input type="text" name="codes" maxlength="100">
</td></tr>
<tr><td colspan="2" align="center">
<input type="submit" name="submit" value="Submit Meeting to Database">
</td></tr>
</table>
</form>
<?php
}
?>
</body>
</html>
Thanks in advance!
David Mosher