inserting twice into database

Lemonboi

I've done up my code and for some unknown reason to me, i get two entries for each submission the second entry however is blank data to the database

Here's my code

memtest.php
$page = array();
$page['title'] = 'EquityApex';

include('memheader.htm');

?>
<p>Test form fill out</p>
<form name="form1" method="post" action="memtest2.php">
<p>First Name
<input type="text" name="1entry1">
</p>
<p>Last Name
<input type="text" name="1entry2">
</p>
<p>Street
<input type="text" name="2entry1">
</p>
<p>Suburb
<input type="text" name="2entry2">
</p>
<p>Age
<input type="text" name="3entry1">
</p>
<p>height
<input type="text" name="3entry2">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
</form>
<p>
<?php

include('memfooter.htm');

connect.php
<?php
// Login & Session example by sde
// connect.php

// replace with your db info
$host = "localhost";
$user = "myusername";
$pass = "password";
$db = "mydatabase";

$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($db) or die ("Unable to select database!");
?>

memtest2.php
<?php

$page = array();
$page['title'] = 'EquityApex';

include('memheader.htm');

include('connect.php');

$query = "INSERT INTO 3test (3entry1, 3entry2) VALUES ('{$POST['3entry1']}', '{$POST['3entry2']}')";
$result = mysql_query($query) or die("Error in query :$query. ".mysql_error());

mysql_close($connection);

echo "completed";

include('memfooter.htm');

cheese

Hi Lemonboi,

I take it that you are not getting any errors shown? Have you tried echoing out all the variables / arrays to do some on screen checking?

Cheers,

Neil.

Lemonboi

I'm getting no errors

Ok, i put it in to echo the variables from the following code
<?php

$page = array();
$page['title'] = 'EquityApex';

include('memheader.htm');

include('connect.php');
$username = $SESSION['username'];
function definitions ($item) {
$$item = $POST['$item'];
}
definitions (entry11);
definitions (entry12);
definitions (entry21);
definitions (entry22);
definitions (entry31);
definitions (entry32);

echo "$entry11 ,";
echo "$entry12 ,";
echo "$entry21 ,";
echo "$entry22 ,";
echo "$entry31 ,";
echo "$entry32 </br>";

$query = "INSERT INTO 1test (1entry1, 1entry2) VALUES ('$entry11', '$entry12')";
$result = mysql_query($query) or die("Error in query :$query. ".mysql_error());
echo "$query </br>";
echo "$result </br>";
unset ($query, $result);
$query = "INSERT INTO 2test (2entry1, 2entry2) VALUES ('$entry21', '$entry22')";
$result = mysql_query($query) or die("Error in query :$query. ".mysql_error());
echo "$query </br>";
echo "$result </br>";
unset ($query, $result);
$query = "INSERT INTO 3test (3entry1, 3entry2) VALUES ('$entry31', '$entry32')";
$result = mysql_query($query) or die("Error in query :$query. ".mysql_error());
echo "$query </br>";
echo "$result </br>";
unset ($query, $result);

mysql_close($connection);

echo "completed";

include('memfooter.htm');

And the echo came back with this

sam23 ,but23 ,bell23 ,wer23 ,23 ,189
INSERT INTO 1test (1entry1, 1entry2) VALUES ('sam23', 'but23')
1
INSERT INTO 2test (2entry1, 2entry2) VALUES ('bell23', 'wer23')
1
INSERT INTO 3test (3entry1, 3entry2) VALUES ('23', '189')
1
completed

So the above entry happens to the database as described, but I'm getting another set of entries that are placing blank data in the net recordset of the table.

cheese

OK,

From what you are saying I take it that a blank line is being put in to all three tables.

Are you sure there is nothing strange in your includes?

Try commenting out the include for connection and just add the absolute minimum code that is required for connection in to the page.

Also, remove the memheader and memfooter includes (well comment them out).

Another thing to try is to not bother to unset $query and $result, try using $query1, $query2 and $query3. The same with $result.

Once we can get it working we can work backwards to see why it doesn't work at the moment.

Cheers,

Neil.

Lemonboi

OK, stripped back to the basics and that seems to work perfectly, i'll start adding one thing in at a time and see what happens

Lemonboi

Ok, i started adding the
include('connect.php');
not a problem

then added in
include('memfooter.htm');
I get the blank entry happening

remove
include('memfooter.htm');
replace
include('memheader.htm'); withouth the 'auth.php'
I get the blank entry as well

NExt progression, I take the code from memfooter and insert it directly into my script page and I get the blank entries

kept removing lots of things from the footer html until not much left and decide instead to include it in the php and echo the footer. I no longer get the blank insert 😃 I'm getting somewhere

I replace all the footer code into the memtest2.php and echo it, and it all wokrs with no blank inserts

<?php

$page = array();
$page['title'] = 'EquityApex';
//include('memheader.htm');
include('connect.php');

function definitions ($item) {
$$item = $_POST['$item'];
}
definitions (entry11);
definitions (entry12);
definitions (entry21);
definitions (entry22);
definitions (entry31);
definitions (entry32);

echo "$entry11 ,";
echo "$entry12 ,";
echo "$entry21 ,";
echo "$entry22 ,";
echo "$entry31 ,";
echo "$entry32 </br>";

$query1 = "INSERT INTO 1test (1entry1, 1entry2) VALUES ('$entry11', '$entry12')";
$result1 = mysql_query($query1) or die("Error in query :$query. ".mysql_error());
echo "$query1 </br>";
echo "$result1 </br>";
$query2 = "INSERT INTO 2test (2entry1, 2entry2) VALUES ('$entry21', '$entry22')";
$result2 = mysql_query($query2) or die("Error in query :$query. ".mysql_error());
echo "$query2 </br>";
echo "$result2 </br>";
$query3 = "INSERT INTO 3test (3entry1, 3entry2) VALUES ('$entry31', '$entry32')";
$result3 = mysql_query($query3) or die("Error in query :$query. ".mysql_error());
echo "$query3 </br>";
echo "$result3 </br>";

mysql_close($connection);

echo "completed";
echo"</div></td>
</tr>
<tr>";
echo "<td valign=\"top\">";
echo "<div class=\"style4\" id=\"siteInfo\"><img width=\"44\" height=\"22\"> <a href=\"#\" class=\"style4\">About Us</a> | <a href=\"#\" class=\"style4\">Site Map</a> | <a href=\"#\" class=\"style4\">Privacy Policy</a> | <a href=\"#\" class=\"style4\">Contact Us</a> | &copy\;2004 EquityApex</div>";
echo "</td>";
echo "</tr>";
echo "</table>";
echo "</body>";
echo "</html>";
?>

cheese

Well, this bit isn't really my kind of thing, but try changing the 'memfooter.htm' to 'memfooter.txt' and see what that does for you.

I always call my includes something.txt files and make them as PHP files with php start and finish tags......

As I say, I'm not sure about this, but give it a go.... nowt to lose !!

Cheers,

Neil.

Lemonboi

I don't know why I did this, but I just did I put in condiontal statments and joined the two scripts and IT WORKS!!

<?php

include('memheader.htm');

$page = array();
$page['title'] = 'EquityApex';

if (!isset($POST['Submit'])) {
?>
<p>Test form fill out</p>
<form name="form1" method="post" action="<?=$SERVER['PHP_SELF']?>">
<p>First Name
<input type="text" name="entry11">
</p>
<p>Last Name
<input type="text" name="entry12">
</p>
<p>Street
<input type="text" name="entry21">
</p>
<p>Suburb
<input type="text" name="entry22">
</p>
<p>Age
<input type="text" name="entry31">
</p>
<p>height
<input type="text" name="entry32">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
</form>
<p>
<?php
}
else{
include('connect.php');

function definitions ($item) {
$$item = $_POST['$item'];
}
definitions (entry11);
definitions (entry12);
definitions (entry21);
definitions (entry22);
definitions (entry31);
definitions (entry32);

echo "$entry11 ,";
echo "$entry12 ,";
echo "$entry21 ,";
echo "$entry22 ,";
echo "$entry31 ,";
echo "$entry32 </br>";

mysql_close($connection);

echo "completed";
}
include('memfooter.htm')
?>