spoco Posted February 23, 2009 Share Posted February 23, 2009 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 More sharing options...
fenway Posted February 24, 2009 Share Posted February 24, 2009 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. Link to comment https://forums.phpfreaks.com/topic/146580-one-field-is-not-writing-correctly/#findComment-770177 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.