nomadrw Posted January 20, 2010 Share Posted January 20, 2010 Hello Everyone: I'm trying to figure out why I not getting a display for my code and why the info is not going to the db. This code is based on a Book called "PHP, MYSQL and Apache" By C Meloni. I modified a little. The db and user has full grant privileges. <?php if (($_POST[op] != "add") || ($_GET[master_id] != "")) { //haven't seen the form, so show it $display_block = " <h1>Add an Entry</h1> <form method=\"post\" action=\"$_SERVER[php_SELF]\">"; if ($_GET[master_id] != "") { //connect to database $conn = mysql_connect("localhost", "nomad", "nomad") or die(mysql_error()); mysql_select_db("teamvelo",$conn) or die(mysql_error()); //get first, last names for display/tests validity $get_names = "select concat_ws(' ', f_name, l_name) as display_name from master_name where id = $_GET[master_id]"; $get_names_res = mysql_query($get_names) or die(mysql_error()); if (mysql_num_rows($get_names_res) == 1) { $display_name = mysql_result($get_names_res,0,'display_name'); } } if ($display_name != "") { $display_block .= "<P>Adding information for <strong>$display_name</strong>:</p>"; } else { $display_block .= " <P><strong>First/Last Names:</strong><br> <input type=\"text\" name=\"f_name\" size=30 maxlength=75> <input type=\"text\" name=\"l_name\" size=30 maxlength=75>"; } $display_block .= "<P><strong>Address:</strong><br> <input type=\"text\" name=\"address\" size=30> <P><strong>City/State/Zip:</strong><br> <input type=\"text\" name=\"city\" size=30 maxlength=50> <input type=\"text\" name=\"state\" size=5 maxlength=2> <input type=\"text\" name=\"zipcode\" size=10 maxlength=10> <P><strong>Telephone Number:</strong><br> <input type=\"text\" name=\"tel_number\" size=30 maxlength=25> <P><strong>Cell Number:</strong><br> <input type=\"text\" name=\"cell_number\" size=30 maxlength=25> <P><strong>Email Address:</strong><br> <input type=\"text\" name=\"email\" size=30 maxlength=150> <P><strong>Emergency Name:</strong><br> <input type=\"text\" name=\"contact_name\" size=30 maxlength=75> <P><strong>Emergency Phone:</strong><br> <input type=\"text\" name=\"contact_phone\" size=25 maxlength=25> <p><input type=\"submit\" name=\"submit\" value=\"Add Entry\"></p> </FORM>"; } else if ($_POST[op] == "add") { //time to add to tables, so check for required fields if ((($_POST[f_name] == "") || ($_POST[l_name] == "")) && ($_POST[master_id] == "")) { header("Location: addentry2.php"); exit; } //connect to database $conn = mysql_connect("localhost", "nomad", "nomad") or die(mysql_error()); mysql_select_db("teamvelo",$conn) or die(mysql_error()); if ($_POST[master_id] == "") { //add to master_name table $add_master = "insert into master_name values ('', now(), now(), '$_POST[f_name]', '$_POST[l_name]')"; mysql_query($add_master) or die(mysql_error()); //get master_id for use with other tables $master_id = mysql_insert_id(); } else { $master_id = $_POST[master_id]; } if (($_POST[address]) || ($_POST[city]) || ($_POST[state]) || ($_POST[zipcode])) { //something relevant, so add to address table $add_address = "replace into address values ('', $master_id, now(), now(), '$_POST[address]', '$_POST[city]', '$_POST[state]', '$_POST[zipcode]')"; mysql_query($add_address) or die(mysql_error()); } if ($_POST[tel_number]) { //something relevant, so add to telephone table $add_tel = "replace into telephone values ('', $master_id, now(), now(), '$_POST[tel_number]')"; mysql_query($add_tel) or die(mysql_error()); } if ($_POST[cell_number]) { //something relevant, so add to fax table $add_cell = "replace into cell values ('', $master_id, now(), now(), '$_POST[cell_number]')"; mysql_query($add_cell) or die(mysql_error()); } if ($_POST[email]) { //something relevant, so add to email table $add_email = "replace into email values ('', $master_id, now(), now(), '$_POST[email]')"; mysql_query($add_email) or die(mysql_error()); } if ($_POST[emergency]) { //something relevant, so add to notes table $add_emergency = "replace into emergency values ('', $master_id, now(), now(), '$_POST[contact_name]', '$_POST[contact_phone]')"; mysql_query($add_emergency) or die(mysql_error()); } $display_block = "<h1>Entry Added</h1> <P>Your entry has been added. Would you like to <a href=\"addentry2.php\">add another</a>?</p>"; } ?> <HTML> <HEAD> <TITLE>Add an Entry</TITLE> </HEAD> <BODY> <?php echo $display_block; ?> </BODY> </HTML> Here is my db and tables CREATE TABLE `teamvelo`.`master_name` ( `id` INT NOT NULL AUTO_INCREMENT , `date_added` DATETIME NOT NULL , `date_modified` DATETIME NOT NULL , `f_name` VARCHAR( 75 ) NOT NULL , `l_name` VARCHAR( 75 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM ; CREATE TABLE `teamvelo`.`address` ( `id` INT NOT NULL AUTO_INCREMENT , `user_id` MEDIUMINT( 11 ) NOT NULL , `date_added` DATETIME NOT NULL , `date_modified` DATETIME NOT NULL , `address` VARCHAR( 255 ) NOT NULL , `city` VARCHAR( 50 ) NOT NULL , `state` CHAR( 2 ) NOT NULL , `zipcode` VARCHAR( 10 ) NOT NULL , `enum` ENUM( 'home', 'work', 'other' ) NOT NULL , PRIMARY KEY ( `id` ) CREATE TABLE `teamvelo`.`telephone` ( `id` INT NOT NULL AUTO_INCREMENT , `master_id` MEDIUMINT( 11 ) NOT NULL , `date_added` DATETIME NOT NULL , `date_modified` DATETIME NOT NULL , `tel_number` VARCHAR( 25 ) NOT NULL , `type` ENUM( 'home', 'work', 'other' ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM ; CREATE TABLE `teamvelo`.`cell` ( `id` INT NOT NULL AUTO_INCREMENT , `master_id` MEDIUMINT( 11 ) NOT NULL , `date_added` DATETIME NOT NULL , `date_modified` DATETIME NOT NULL , `cell_number` VARCHAR( 25 ) NOT NULL , `type` ENUM( 'home', 'work', 'other' ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM ; Any help would be great. Damon PS I trying to learn PHP Link to comment https://forums.phpfreaks.com/topic/189240-data-is-to-writing-to-the-db/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.