Insert into Mulitple Tables

anevins · March 10, 2011

Hi there,

I have a form which I want to submit data into my tables.

There are going to be 4 tables involved with this form, and these 4 tables should relate to one another in some sort of way.

My problem is either PHP or MySQL, but I keep getting a warning which I can't figure out.

I remember this warning appearing even if the code before it is wrong, therefore I am not relying on it.

This is what the error says:

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in G:\xampp\htdocs\xampp\dsa\wp3.php on line 40

Here's my code:

<html>
<head>
<title>WP3</title>
</head>
<body>
<form id="search" name="search" id="search" method="get" action="searchresults.php" />
<input type="text" name="terms" value="Search..." />
<input class="button" type="submit" name="Search" value="Search" />
</form>

<?php

include_once('connectvars.php');

$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);


if(isset($_POST['report'])){

$firstname = mysqli_real_escape_string($dbc, trim($_POST['firstName']));
$middlename = mysqli_real_escape_string($dbc, trim($_POST['middleName']));
$lastname = mysqli_real_escape_string($dbc, trim($_POST['lastName']));
$image = mysqli_real_escape_string($dbc, trim($_POST['image']));
$phone = mysqli_real_escape_string($dbc, trim($_POST['phone']));
$organisation = mysqli_real_escape_string($dbc, trim($_POST['organisation']));
$street = mysqli_real_escape_string($dbc, trim($_POST['street']));
$town = mysqli_real_escape_string($dbc, trim($_POST['town']));
$city = mysqli_real_escape_string($dbc, trim($_POST['city']));


if (!empty($firstname) && !empty($middlename) && !empty($lastname) && !empty($image) && !empty($phone) && !empty($organisation) && !empty($city)) {

	$query = "INSERT INTO report (organisation, phoneNo) VALUES ('$organisation', '$phone');
			  INSERT INTO person (firstName, middleName, lastName) VALUES ('$firstname', '$middlename', '$lastname');
			  INSERT INTO identification (image) VALUES ('$image');
			  INSERT INTO location (street, town, city) VALUES ('$street', '$town', '$city')";

	$data = mysqli_query($dbc, $query);

		if (mysqli_num_rows($data) == 0) {

		mysqli_query($dbc, $query);
		echo "Thank you, your report has been received.";

		}

	else {
        // An account already exists for this username, so display an error message
        echo '<p>This report already exists.</p>';
        $username = "";
	}
}	
else echo "Please enter all of the fields";	
}

?>

<form id="report_sighting" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<h2>Report a sighting</h2>
<table>
	<tr>
		<td>
			<label>First name:</label>
		</td>
		<td>
			<input type="text" id="firstname" name="firstName" value="<?php if (!empty($firstname)) echo $firstname; ?>" />
		</td>
	</tr>
	<tr>
		<td>
			<label>Middle name:</label>
		</td>
		<td>
			<input type="text" id="middlename" name="middleName" value="<?php if (!empty($middlename)) echo $middlename; ?>" />
		</td>
	</tr>
	<tr>
		<td>
			<label>Last name:</label>
		</td>
		<td>
			<input type="text" id="lastname" name="lastName" value="<?php if (!empty($lastname)) echo $lastname; ?>" />
		</td>
	<tr>
		<td>
			<label>Upload Identification:</label>
		</td>
		<td>
			<input type="file" id="image" name="image" />
		</td>
	<tr>
	<tr>
		<td>
			<label>Contact phone number: </label>
		</td>
		<td>
			<input type="text" id="phone" name="phone" />
		</td>
	<tr>
	<tr>
		<td>
			<label>Organisation: </label>
		</td>
		<td>
			<input type="text" id="organisation" name="organisation" />
		</td>
	</tr>
	<tr>
		<td>
			<label>Street seen: </label>
		</td>
		<td>
			<input type="text" id="street" name="street" />
		</td>
	</tr>
	<tr>
		<td>
			<label>Town seen: </label>
		</td>
		<td>
			<input type="text" id="town" name="town" />
		</td>
	</tr>
	<tr>
		<td>
			<label>City seen: </label>
		</td>
		<td>
			<input type="text" id="city" name="city" />
		</td>
	</tr>
	<tr>
		<td>
			 
		</td>
		<td>
			<input type="submit" value="Report" name="report" />
		</td>
	</tr>
</table>
</form>
<form id="add_subject" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<h2>Add a new missing memory stick</h2>
<table>

	<tr>
		<td>
			<label>ISBN</label>
		</td>
		<td>
			<input type="text" id="isbn" name="isbn" value="<?php if (!empty($isbn)) echo $isbn; ?>" />
		</td>
	</tr>
	<tr>
		<td>
			<label>Size:</label>
		</td>
		<td>
			<input type="text" id="size" name="size" value="<?php if (!empty($size)) echo $size; ?>" />
		</td>
	</tr>
	<tr>
		<td>
			<label>Colour:</label>
		</td>
		<td>
			<input type="text" id="colour" name="colour" value="<?php if (!empty($colour)) echo $colour; ?>" />
		</td>
	<tr>
		<td>
			<label>Model / make:</label>
		</td>
		<td>
			<input type="text" id="model" name="model" value="<?php if (!empty($model)) echo $model;?>" />
		</td>
	<tr>
		<td>
			 
		</td>
		<td>
			<input type="submit" value="Add" name="add" />
		</td>
	</tr>
</table>
</form>

</body>
</html>

I think that MySQL statement is alright because I just tried it out and it was inserting.

Could anyone help me out here please?

Thanks.

fenway · March 11, 2011

That's your entire script -- narrow it down.

Sign In

Insert into Mulitple Tables

Recommended Posts

anevins

Link to comment

Share on other sites

fenway

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information