Jump to content

One field is not writing correctly


spoco

Recommended Posts

I am trying to write a PHP script that will write data to a MySQL database (obviously). However, the e-mail field is not working. (everything is NULL when data is entered). Is there something wrong in my coding?

 

Form Page

<? 
require_once("all_includes.php");
session_start();
check_valid_user();
$conn = new db_conn();

//get user id
$id = $_SESSION['emp_sess_uid'];

$count = 6;

//get values
for ($i=1; $i<=$count; $i++){
$name[$i] = addslashes(trim($_POST['ref_name' . $i]));
$position[$i] = addslashes(trim($_POST['ref_pos' . $i]));
$street[$i] = addslashes(trim($_POST['ref_street' . $i]));
$city[$i] = addslashes(trim($_POST['ref_city' . $i]));
$state[$i] = addslashes(trim($_POST['ref_state' . $i]));
$zip[$i] = addslashes(trim($_POST['ref_zip' . $i]));

$phone1_[$i] = addslashes(trim($_POST['ref_phone1_' . $i]));
$phone2_[$i] = addslashes(trim($_POST['ref_phone2_' . $i]));
$phone3_[$i] = addslashes(trim($_POST['ref_phone3_' . $i]));
$phone[$i] = $phone1_[$i].$phone2_[$i].$phone3_[$i];
$email[$i] = addslashes(trim($_POST['ref_email' . $i]));
}
//do records already exist?
for ($i=1; $i<=$count; $i++){
$ref_exists[$i] = $conn->record_exists_with_num('refs',$id,$i);
//echo $i . ": ".$ref_exists[$i];
}


//construct query
//construct fail_to_reemploy queries
for ($i=1; $i<=$count; $i++){
if (!$ref_exists[$i]){
	$query 	= "insert into refs (";
	$query .= "id, num, name, position, ";
	$query .= "street, city, state, zip, phone, email) ";
	$query .= "values ($id, ";
	$query .= $i . ", ";
	$query .= "'" . $name[$i] . "', ";
	$query .= "'" . $position[$i] . "', ";
	$query .= "'" . $street[$i] . "', ";
	$query .= "'" . $city[$i] . "', ";
	$query .= "'" . $state[$i] . "', ";
        $query .= "zip = " . $zip[$i] . ", ";
        $query .= "phone = " . $phone[$i] . " ";
        $query .= "email = " . $email[$i] . " ";
        $query .= " where id=$id ";

}
else{
	$query  = "update refs set ";
	$query .= "name = '" . $name[$i] . "', ";
	$query .= "position = '" . $position[$i] . "', ";
	$query .= "street = '" . $street[$i] . "', ";
	$query .= "city = '" . $city[$i] . "', ";
	$query .= "state = '" . $state[$i] . "', ";
        $query .= "zip = " . $zip[$i] . ", ";
        $query .= "phone = " . $phone[$i] . " ";
        $query .= "email = " . $email[$i] . " ";
        $query .= " where id=$id ";

	$query .= "and num=$i";
}
//echo "<br>query: ".$query;

//execute query
$conn->query($query);
}

header("Location:".$page8);
?>

 

Post Page

<? 
require_once("all_includes.php");
session_start();
check_valid_user();
$conn = new db_conn();

//get user id
$id = $_SESSION['emp_sess_uid'];

$count = 6;

//get values
for ($i=1; $i<=$count; $i++){
$name[$i] = addslashes(trim($_POST['ref_name' . $i]));
$position[$i] = addslashes(trim($_POST['ref_pos' . $i]));
$street[$i] = addslashes(trim($_POST['ref_street' . $i]));
$city[$i] = addslashes(trim($_POST['ref_city' . $i]));
$state[$i] = addslashes(trim($_POST['ref_state' . $i]));
$zip[$i] = addslashes(trim($_POST['ref_zip' . $i]));

$phone1_[$i] = addslashes(trim($_POST['ref_phone1_' . $i]));
$phone2_[$i] = addslashes(trim($_POST['ref_phone2_' . $i]));
$phone3_[$i] = addslashes(trim($_POST['ref_phone3_' . $i]));
$phone[$i] = $phone1_[$i].$phone2_[$i].$phone3_[$i];
$email[$i] = addslashes(trim($_POST['ref_email' . $i]));
}
//do records already exist?
for ($i=1; $i<=$count; $i++){
$ref_exists[$i] = $conn->record_exists_with_num('refs',$id,$i);
//echo $i . ": ".$ref_exists[$i];
}


//construct query
//construct fail_to_reemploy queries
for ($i=1; $i<=$count; $i++){
if (!$ref_exists[$i]){
	$query 	= "insert into refs (";
	$query .= "id, num, name, position, ";
	$query .= "street, city, state, zip, phone, email) ";
	$query .= "values ($id, ";
	$query .= $i . ", ";
	$query .= "'" . $name[$i] . "', ";
	$query .= "'" . $position[$i] . "', ";
	$query .= "'" . $street[$i] . "', ";
	$query .= "'" . $city[$i] . "', ";
	$query .= "'" . $state[$i] . "', ";
        $query .= "zip = " . $zip[$i] . ", ";
        $query .= "phone = " . $phone[$i] . " ";
        $query .= "email = " . $email[$i] . " ";
        $query .= " where id=$id ";

}
else{
	$query  = "update refs set ";
	$query .= "name = '" . $name[$i] . "', ";
	$query .= "position = '" . $position[$i] . "', ";
	$query .= "street = '" . $street[$i] . "', ";
	$query .= "city = '" . $city[$i] . "', ";
	$query .= "state = '" . $state[$i] . "', ";
        $query .= "zip = " . $zip[$i] . ", ";
        $query .= "phone = " . $phone[$i] . " ";
        $query .= "email = " . $email[$i] . " ";
        $query .= " where id=$id ";

	$query .= "and num=$i";
}
//echo "<br>query: ".$query;

//execute query
$conn->query($query);
}

header("Location:".$page8);
?>

Link to comment
https://forums.phpfreaks.com/topic/146580-one-field-is-not-writing-correctly/
Share on other sites

Don't just post your entire script -- no one has to time to read them.

 

What does "e-mail field not working" actually mean?

 

You're manually stitching together LOTS of fields without a DB class, so there are bound to be errors... yet you haven't provided us with the RAW query string that is being sent to the server.

 

Try again.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.