A problem inserting details into database

fadinha

Hey,

I'm having a problem with saving details to database from form. It says that the new details are added but nothing has added at all.

FORM:

<form method="post" id="NewMethodCard" name="NewMethodCard" action="saveNewMethod.php">
		<table>
		<tr><td>
		Anna menetelmäkortille nimi: </td>
		<td><input type="text" name="MCname" size="40"></td></tr>
		<tr><td colspan="2">
		<textarea name="MCcontent" id="MCcontent" rows="10" cols="50"></textarea>
		<script language="javascript1.2">make_wyzz('MCcontent');</script></td></tr>
		<tr><td><input type="submit" name="submit" value="TALLENNA"></td>
		<td><input type="submit" name="cancel" value="PERUUTA"></td></tr>
		</table></form>

And the php code:

<?php
if(!session_is_registered('username')) :
header('Location: ../pages/login.php');
endif;
include('../pages/db.php');
if(isset($_POST['MCname']) && ($_POST['MCcontent'])){

$username = $_SESSION['username'];
$result = mysql_query("SELECT userID FROM users WHERE username='$username'");
$row = mysql_fetch_array($result);
//SET THE DETAILS TO VARIABLES
$userID = $row['userID'];
$MCname = $_POST['MCname'];
$MCcontent = $_POST['MCcontent'];

mysql_query("INSERT INTO mcards VALUES ('NULL','$MCname','$MCcontent',CURDATE(),'$userID')");

		header ("Location: methods.php?msg=New_Method_Added");
}
else {
	header ("Location: add_mcard.php?msg=dowload_error");
}

?>

laserlight

Do some error checking, e.g.,

if (mysql_query("INSERT INTO mcards VALUES ('NULL','$MCname','$MCcontent',CURDATE(),'$userID')")) {
	header("Location: methods.php?msg=New_Method_Added");
} else {
	header("Location: add_mcard.php?msg=dowload_error");
}

Incidentally, note that the URL of a location header should be an absolute URL in order to comply with HTTP/1.1. Also, you should have an exit or die right after sending a location header otherwise the rest of the script will still be executed.

fadinha

Not working yet 🙁
it doesn't insert any info...

laserlight

What is your current code? Do you have error_reporting set to E_ALL?

fadinha

Hmm, now I put the code check up the queries...and it's actually sending me to the index....

bradgrafelman

Try building the INSERT query in a variable and echo() it before sending it to the SQL server. That way, you can examine the query yourself to see if it looks right. Paste it here for us to see as well.