turpentyne

I'm stumped on what's causing this problem. $descriptor2 is entering "0". But $_POST['States'] does have a value. I put $testable in as a variable to test that in place of descriptor2 and it works just fine. $descriptor1 = isset($_GET['id']) ? (int)$_GET['id'] : null; $descriptor2 = isset($_POST['States']) ? (int)$_POST['state'] : null; $descriptor3 = isset($_POST['continent_regions']) ? (int)$_POST['continent_regions'] : null; $descriptor4 = isset($_POST['Continents']) ? (int)$_POST['Continents'] : null; $descriptor5 = isset($_POST['Country']) ? (int)$_POST['Country'] : null; $testable = $_POST['States']; // my test variable $query = "INSERT INTO plant_locations_link(plant_id,state,continent_regions,continents,country) VALUES ($descriptor1,$descriptor2,$descriptor3,$descriptor4,$descriptor5)"; // if I change descriptor2 to testable, it inputs the number I need.

I want to search a database and get items that appear in the connector database twice with either variable 1 or 23. So if I search for any items that have been entered with both 1 and 23 variables, then I want to pull that item's id. AND gives me nothing. OR gives me all the results of 1 and all the results of 23 item_id | variable ------------+---------------- 211924 | 1 ------------+---------------- 211924 | 23 ------------+---------------- This query below gives me no results, when I want to get 1 result: 211924 SELECT item_id FROM `connect_tables` JOIN items ON connect_tables.item_id = items.item_id WHERE connect_tables.term_id LIKE 1 AND connect_tables.item_id LIKE 23 This query gives me every item that has been entered with 23 or 24, not with both. SELECT item_id FROM `connect_tables` JOIN items ON connect_tables.item_id = items.item_id WHERE connect_tables.term_id LIKE 1 OR connect_tables.item_id LIKE 23 I hope that made sense.

This may sound like an odd thought, but us beginners come up with weird ideas sometimes. I'm trying to solve a "three letters or less" search. Basically if the user enters 4 words or more, my script does a fulltext search. If they do 3 letters or less, it does a basic search. But how can I write the script so that it only searches for those matching letters that have either a space in front or at the end... or that start with the three letters searched. so, if they type in "elm" I want to get "chinese elm" I want to get "Elmendorf's onion" I don't want to get "engelman's spruce"... or at the very least have results with no space on either side be at the end of the results? right now, I'm just doing a basic search and a basic search that concatenates two fields: $data = mysql_query("SELECT * FROM plantae WHERE common_name_english LIKE '%$item%'"); $data = mysql_query("SELECT * FROM plantae WHERE CONCAT(taxonomic_genus,' ',scientific_name) LIKE '%$item%'");

actually... I wonder if I could just set it to check what the user entered... if they entered 3 or less characters, maybe I could run a simple query to handle the search? Does that seem like a feasible option?

ah! it was apparently just a lack of apostrophes around $item now I have to figure out a more difficult issue. There's a limit of 4 characters to the search. I need to figure out how to allow 3 and even a selected few 2-word terms. the reason is because there are some very common terms that are only three words which are applicable to my database of plants. elm, oak for example. They would not be searchable if there was no allowance for 3 letters.

Let me correct myself. The error is "Query failed: Unknown column 'searched term' in 'field list'" Did I write my query wrong?

hmmm.. ok. I've changed the query like below, and left the rest from fetch_array down the same. Is that not something I can do??? I'm no getting: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource $item = $_REQUEST['find']; $query = "SELECT *, MATCH(scientific_name, common_name_english) AGAINST ($item) AS score from table WHERE MATCH (scientific_name, common_name_english) AGAINST($item) order by score desc"; //$data = mysql_query("SELECT * FROM plantae WHERE common_name_english LIKE '%$item%'"); $data = mysql_query($query); while($row = mysql_fetch_array($data)){ echo ' etcetera '; }

I was showing a friend what I've been working on, and as I watched him type in an entry to search - then not get a result that I know was indeed in the database I realized I needed to accommodate "user laziness." He didn't use punctuation. So I'm trying to figure out how to make that a nonfactor in searches. In other words, my database may have an entry called "St. Patrick's Cathedral" If somebody types "st patricks cathedral" I want the result to still show up. Here's what I'm using right now: if(isset($_POST[submitted])) { $item = $_REQUEST['find']; $filter1 = trim($_POST['filter1']); if ($filter1 == 'sci-names') { $data = mysql_query("SELECT * FROM table WHERE CONCAT(taxonomic_genus,' ',scientific_name) LIKE '%$item%'");

hmmm.. maybe I spoke too soon... This worked for me. I assume this is an ok/secure way to do it? $author = "(abbreviated name with.) second abbrev. name." $splitter = split('[()]', $author); $firstname = $splitter[1]; $secondname = $splitter[2]; echo $firstname.' and '.$secondname;

This is probably a simple one. I just couldn't find a tutorial to the specific thing I'm trying. I have a string that looks like: "(abbreviated name with.) second abbrev. name." I'm trying to find a way to break this apart so I can have: $var1 = "abbreviated name with." $var2 = "second abbrev. name." I've looked at substr and a couple others and I'm not sure quite how to do this, because the ')' could be in a differing location.

yep! I got it! There was just some extra coding in there that was screwing things up because it was no longer relevant. Thanks again!

oh wow! Thanks! I wasn't expecting that much help! I'm testing now, and i got an error I've never seen before: Access denied for user 'ODBC'@'localhost' New to me. What causes this one?

ah! ok.. I got mixed up on that. I didn't realize I had to do mysql_query, then fetch_array. Now that that's good, any thoughts on how I compare the result with a different array and use the remainder I get to delete entries? I've got this now (the delete is toward the bottom - I just included the rest to help clarify what i'm doing a little): if (isset($_POST['submit'])){ require ('db.php'); $id1 = $_POST['plant_id']; $imploder=implode(',', $_POST['option2']); $exploder = explode(',', $imploder); foreach($exploder as $value) { $add = "INSERT INTO plant_edible_link(plant_id, edible_id) VALUES ($id1, $value) ON DUPLICATE KEY UPDATE plant_id = $id1, edible_id = $value"; $result2 = mysql_query($add) or die(mysql_error()); // NOW THE DELETES $checker = "SELECT id FROM edible_uses"; $result2 = mysql_query($checker) or die(mysql_error()); while($row = mysql_fetch_array($result2)) { // Here's what I'm trying to figure out.. $deletes = array_diff($row,$exploder); // $delete = "DELETE FROM plant_edible_link(plant_id, edible_id) VALUES ($id1, $value) WHERE plant_id = $id AND edible_id = $deletes"; }

I've got to be missing something pretty basic here.. considering the query is pretty basic. I'm trying to figure out how to pull a query as an array so I can compare it against another array (array_diff) I'm doing a mysql_fetch_array, and I'm getting an error ( mysql_fetch_array(): supplied argument is not a valid MySQL result resource): I've done a mysql_query and I get results. The table name and all that is correct. I'm stumped. This seems like a pretty simple query? I tried mysql_fetch_assoc as well. Same result? I tried it with an extra set of parenthesis around it. nope.

oops! the execute mistake was just from copying/pasting into this forum.. The where clause is what I was trying to use to see if it would work... Everything works, but I don't know how to overlook duplicates. I put a key on the table, and that's what's halting the query. It's a page that has several checkboxes to loop through and a hidden field that generates $id. I'm not sure if I understand the question on $value... I guess I thought that was being created by the " foreach($exploder as $value) " part. here's what I have now. it works, but it's giving me the notice that there is a " Duplicate entry '24-1' for key 'plant_id' ". I'm not sure where to go from here. if (isset($_POST['submit'])){ require ('db'); $id1 = $_POST['plant_id']; $imploder=implode(',', $_POST['option2']); //echo $imploder."<br>"; $exploder = explode(',', $imploder); //print_r($exploder); //$add_plants = array_diff($cats,$mysql_cats); //$delete_plants = array_diff($mysql_cats,$cats); foreach($exploder as $value) { $add = "INSERT INTO table(plant_id, edible_id) VALUES ($id1, $value)"; $delete = "DELETE FROM table WHERE plant_id = $id1 and edible_id NOT IN $exploder"; $result2 = mysql_query($add) or die(mysql_error()); if (mysql_affected_rows() > 0) { echo '<div style="position:relative; left:16px; top:216px;"><font color="red">your plant has been updated</font></div>'; } };

I'm figuring out a code that runs through several checkboxes, then checks the mysql table to enter any checked boxes if they don't already exist, and to delete any entries that might exist matching the unchecked boxes. This is as far as I've gotten. I had it working, but it chokes on the table key. I want to skip over existing entries... if (isset($_POST['submit'])){ require ('db.php'); $id1 = $_POST['plant_id']; $imploder=implode(',', $_POST['option2']); $exploder = explode(',', $imploder); foreach($exploder as $value) { $add = "INSERT INTO table(plant_id, edible_id) VALUES ($id1, $value) WHERE plant_id = $id AND edible_id != $value"; $delete = "DELETE FROM table WHERE plant_id = $id1 and edible_id NOT IN $exploder"; }; $result2 = mysql_query($add) or die(mysql_error()); if (mysql_affected_rows() > 0) { echo '<div style="position:relative; left:16px; top:216px;"><font color="red">updated!</font></div>'; } } ?>

An update: I've gotten this far, but it still doesn't work at all. function changecolor(picName,imgName) { var leafcolor = document.getElementById('picName').src; if (leafcolor == "/images/leaf_shapes/entire/transparent1.gif") { document.getElementById('picName').src="/images/leaf_shapes/entire/leafbg_green.gif" } else { imgOn = eval(imgName + ".src"); document[picName].src= imgOn; } }

I have this code that simply changes an image when something is selected in a form. It finds this image name "pic4" and changes its file path "transparent1.gif" to green.gif, or orange.gif, depending on what was selected. The image code at the start: <IMG SRC="images/leaf_shapes/entire/transparent1.gif" name="pic4" width="250" height="350" border="0"> But I want it to only do so if "pic4" is still "transparent1.gif" as there's another button choice that it could be overriding. Any thoughts on how? I'm new to javascript. function change1(picName,imgName) { if (document.images) { imgOn=eval(imgName + ".src"); document[picName].src= imgOn; } }

I think I got this part figured out. It was simpler than I thought. I have the dropdowns set with an onselect function that changes an $_Get item in the url and reloads the page. But now I need to figure out another snippet. Is there a snippet to present the dropdowns based on the url _gets that are already at the top? If I select one button, it works fine. If I select a second button, it works - but loses the first button's choice.

From a previous search page that passes form variables via _GET to a new results.php page. On this page, I'm building a form down the side, to refine the search results. But I can't seem to remember the javascript to put into the form to update several $_Get variables in the url, and reload the page, so that the php runs and narrows results. I'm sure it was pretty simple. I just don't remember and can't seem to find something does/explains what I want. thanks!

I'm very out of practice, and trying to figure out old broken code. From a previous search page, results are pulled from the database, and the variables are passed. At first it works, but then, when I click on the pagination links to see the next page of results, it stops working. The next page appears with no info. Here's the code, I think it has something to do with the passed variables toward the bottom of the code, but I can't figure out what to do. <code> <?php require ('databaseconnection'); $display = 2; // it's intentionally only 2 for the moment to test pagination if (isset($_GET['np'])) { $num_pages = $_GET['np']; } else { $data = "SELECT COUNT(*), `descriptors`.*, `plantae`.* FROM `descriptors` LEFT JOIN `plantae` ON (`descriptors`.`plant_id` = `plantae`.`plant_name`) WHERE `leaf_shape` LIKE '%$s1%' AND `leaf_venation` LIKE '%$s3%' AND `leaf_margin` LIKE '%$s4%'"; $result = mysql_query ($data); if (!$result) { die("Oops, my query failed. The query is: <br>$data<br>The error is:<br>".mysql_error()); } $row = mysql_fetch_array($result, MYSQL_NUM); //row 40 above seems to be where a problem is $num_records = $row[0]; if ($num_records > $display) { $num_pages = ceil ($num_records/$display); } else { $num_pages = 1; } } if (isset($_GET['s'])) { $start = $_GET['s']; } else { $start = 0; } if(isset($_GET[submitted])) { // Now collect all info into $item variable $shape = $_GET['s1']; $color = $_GET['s2']; $vein = $_GET['s3']; $margin = $_GET['s4']; // This will take all info from database where row tutorial is $item and collects it into $data variable $data = mysql_query("SELECT `descriptors`.* ,`plantae`.* FROM `descriptors` LEFT JOIN `plantae` ON (`descriptors`.`plant_id` = `plantae`.`plant_name`) WHERE `leaf_shape` LIKE '%$s1%' AND `leaf_venation` LIKE '%$s3%' AND 'leaf_margin' LIKE '%$s4%' ORDER BY `plantae`.`scientific_name` ASC LIMIT $start, $display"); //chs added this in... echo '<table align="center" cellspacing="0" cellpading-"5"> <tr> <td align="left"><b></b></td> <td align="left"><b></b></td> <td align="left"><b>Leaf margin</b></td> <td align="left"><b>Leaf venation</b></td> </tr> '; while($row = mysql_fetch_array($data)){ echo '<tr> <td align="left"> <a href="view_plant.php?id=' . $row['plant_name'] . '">View plant</a> </td> <td align="left"> </td> <td align="left">' . $row['scientific_name'] . '</td> <td align="left">' . $row['common_name'] . '</td> <td align="left">' . $row['leaf_shape'] . '</td> </tr>'; } echo '</table>'; } if ($num_pages > 1) { echo '<br /><p>'; $current_page = ($start/$display) + 1; if ($current_page != 1) { echo '<a href="leafsearch4c.php?s=' . ($start - $display) . '&np=;' . $num_pages . '&s1=' . $s1 . '&s2=' . $s2 . '&s3=' . $s3 . '&s4=' . $s4 . '">Previous</a> '; } for ($i = 1; $i <= $num_pages; $i++) { if($i != $current_page) { echo '<a href="leafsearch4c.php?s=' . (($display * ($i - 1))) . '$np=' . $num_pages . '&s1=' . $s1 . '&s2=' . $s2 . '&s3=' . $s3 . '&s4=' . $s4 .'">' . $i . '</a>'; } else { echo $i . ' '; } } if ($current_page != $num_pages) { echo '<a href="leafsearch4c.php?s=' . ($start + $display) . '$np=' . $num_pages . '&s1=' . $s1 . '&s2=' . $s2 . '&s3=' . $s3 . '&s4=' . $s4 .'"> Next</a>'; } } //added curly ?></code>

It's been a while since I sat down to build some pages and teach myself php. So now that I've started back up, I'm at a loss for what I've done. I deleted a file, and have to rebuild from an old broken version: I have a form that submits a query to the database, but the results pages is giving me this error: Oops, my query failed. The query is: SELECT COUNT 'descriptors'.* ,'plantae'.* FROM 'descriptors' LEFT JOIN 'plantae' ON ('descriptors'.'plant_id' = 'plantae'.'plant_name') WHERE 'leaf_shape' LIKE '%auriculate%' AND 'leaf_venation' LIKE '%%' AND 'leaf_margin' LIKE '%%' The error is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.* ,'plantae'.* FROM ' at line 2 But I'm not seeing what the syntax error is. Here's the code: <?php require ('connection.php'); $display = 2; // it's intentionally only 2 for the moment if (isset($_GET['np'])) { $num_pages = $_GET['np']; } else { $data = "SELECT COUNT 'descriptors'.* ,'plantae'.* FROM 'descriptors' LEFT JOIN 'plantae' ON ('descriptors'.'plant_id' = 'plantae'.'plant_name') WHERE 'leaf_shape' LIKE '%$s1%' AND 'leaf_venation' LIKE '%$s3%' AND 'leaf_margin' LIKE '%$s4%'"; $result = mysql_query ($data); if (!$result) { die("Oops, my query failed. The query is: <br>$data<br>The error is:<br>".mysql_error()); } $row = mysql_fetch_array($result, MYSQL_NUM); $num_records = $row[0]; if ($num_records > $display) { $num_pages = ceil ($num_records/$display); } else { $num_pages = 1; } } if (isset($_GET['s'])) { $start = $_GET['s']; } else { $start = 0; } if(isset($_POST[submitted])) { // Now collect all info into $item variable $shape = $_POST['s1']; $color = $_POST['s2']; $vein = $_POST['s3']; $margin = $_POST['s4']; // This will take all info from database where row tutorial is $item and collects it into $data variable $data = mysql_query("SELECT 'descriptors'.* ,'plantae'.* FROM 'descriptors' LEFT JOIN 'plantae' ON ('descriptors'.'plant_id' = 'plantae'.'plant_name') WHERE 'leaf_shape` LIKE '%$s1%' AND 'leaf_venation' LIKE '%$s3%' AND 'leaf_margin' LIKE '%$s4%' ORDER BY 'plantae'.'scientific_name` ASC LIMIT $start, $display"); //chs added this in... echo '<table align="center" cellspacing="0" cellpading-"5"> <tr> <td align="left"><b></b></td> <td align="left"><b></b></td> <td align="left"><b>Leaf margin</b></td> <td align="left"><b>Leaf venation</b></td> </tr> '; //end something chs added in // This creates a loop which will repeat itself until there are no more rows to select from the database. We getting the field names and storing them in the $row variable. This makes it easier to echo each field. while($row = mysql_fetch_array($data)){ echo '<tr> <td align="left"> <a href="link.php">View plant</a> </td> <td align="left"> <a href="link.php">unknown link</a> </td> <td align="left">' . $row['scientific_name'] . '</td> <td align="left">' . $row['common_name'] . '</td> <td align="left">' . $row['leaf_shape'] . '</td> </tr>'; } echo '</table>'; // row 95 } if ($num_pages > 1) { echo '<br /><p>'; $current_page = ($start/$display) + 1; // row 100 if ($current_page != 1) { echo '<a href="leafsearch2a.php?s=' . ($start - $display) . '&np=;' . $num_pages . '">Previous</a> '; } for ($i = 1; $i <= $num_pages; $i++) { if($i != $current_page) { echo '<a href="leafsearch2a.php?s=' . (($display * ($i - 1))) . '$np=' . $num_pages . '">' . $i . '</a>'; } else { echo $i . ' '; } } if ($current_page != $num_pages) { echo '<a href="leafsearch2a.php?s=' . ($start + $display) . '$np=' . $num_pages . '"> Next</a>'; } } //added curly ?>

I'm trying to create a simple session on a form page that determines if you've signed in. If you haven't, it kicks you to the login page. But for some reason, what I have isn't doing that. When I open the page, it loads, but only prints the url on a blank page, instead of actually going to the url. <html> <title>form</title> <link rel="stylesheet" type="text/css" href="style.css"> <body> <?php session_start(); if(isset($_SESSION['id']) && is_numeric($_SESSION['id'])) { if (isset($_POST['submitted'])) { $errors = array(); if (empty($_POST['scientific_name'])) { $errors[] = 'you forgot to enter the scientific name'; } else { $sn = trim($_POST['scientific_name']); } if (empty($_POST['common_name_english'])) { $errors[] = 'you forgot to enter the common name'; } else { $cne = trim($_POST['common_name_english']); } $description4 = trim($_POST['common_names_spanish']); $description5 = trim($_POST['common_names_french']); $description6 = etc. etc. if (empty($errors)) { require_once ('3_z_mysq1_c0nn3ct.php'); $query = "INSERT INTO plantae (scientific_name, common_name_english, etc.) VALUES ('$sn', '$cne', '$description4', '$description5', '$description6', '$description7', etc.)"; $result = @mysql_query ($query); if ($result) { if(isset($_POST['scientific_name'])) { $plant_id=mysql_insert_id(); } exit(); } else { echo 'system error. No plant added'; echo '<p>' . mysql_error() . '<br><br>query:' . $query . '</p>'; exit(); } mysql_close(); } else { echo 'error. the following error occured <br>'; foreach ($errors as $msg) { echo " - $msg<br>\n"; } } // end of if } // end of main submit conditional echo '<form action="insertaplant1.php" method="post"><fieldset><legend><b>Enter your new plant here</b></legend> form fields here. </form>'; } else { $url = 'http://'.$_SERVER['HTTP_HOST'].dirname($_SERVER['PHP_SELF']); if((substr($url, -1) == '/') OR (substr($url, -1) == '\\') ) { $url = substr($url, 0, -1); } $url .= '/login.php'; echo $url; exit(); } ?>

probably another overly-newbie-ish question, but I built a series of pages for inputting data. Page 1 inputs data to table 1, pulls the item id and passes it to page 2 to input to table 2. This all works fine. But now I want to add a header and footer to include the site design. And when I add my <? include("header.php"); ?>, it stops working. I tried naming the header something else, in case it was just a duplicate name somewhere, but the problem is still there. When i submit, it goes to the next page and generates this error: Warning: Cannot modify header information - headers already sent by (output started at header.php:62) in file.php on line 65 Is there a way to include a header without it creating this issue? Or do I put it lower down in the code? Here's the main idea of the code: if (isset($_POST['submitted'])) { $errors = array(); $descriptor1 = trim($_POST['plant_id']); $descriptor2 = trim($_POST['existence_status']); $descriptor3 = etc. etc. if (empty($errors)) { require ('connection.php'); $query = "INSERT INTO habits (plant_id, existence_status, reproduction_methods, etc.) VALUES ('$descriptor1', '$descriptor2', etc.)"; $result = @mysql_query ($query); $plant_id=mysql_insert_id(); header ("Location: thisfile.php?var1=$plant_id"); and, if it helps any, here's the header file: <div id="ugg" style="background-color:#CDE472; height:80px; padding:10px;"> <h1>Twigzy</h1> </div> <style type="text/css" media="screen"> /**************** menu coding *****************/ #menu { width: 100%; background: #eee; float: left; } #menu ul { list-style: none; margin: 0; padding: 0; width: 12em; float: left; } #menu a, #menu h2 { font: bold 11px/16px arial, helvetica, sans-serif; display: block; border-width: 1px; border-style: solid; border-color: #ccc #888 #555 #bbb; margin: 0; padding: 2px 3px; } #menu h2 { color: #fff; background: #324F17; text-transform: uppercase; } #menu a { color: #000; background: #efefef; text-decoration: none; } #menu a:hover { color: #a00; background: #fff; } #menu li {position: relative;} #menu ul ul { position: absolute; z-index: 500; } #menu ul ul ul { position: absolute; top: 0; left: 100%; } div#menu ul ul, div#menu ul li:hover ul ul, div#menu ul ul li:hover ul ul {display: none;} div#menu ul li:hover ul, div#menu ul ul li:hover ul, div#menu ul ul ul li:hover ul {display: block;} </style> <!--[if IE]> <style type="text/css" media="screen"> #menu ul li {float: left; width: 100%;} </style> <![endif]--> <!--[if lt IE 7]> <style type="text/css" media="screen"> body { behavior: url(csshover.htc); font-size: 100%; } #menu ul li a {height: 1%;} #menu a, #menu h2 { font: bold 0.7em/1.4em arial, helvetica, sans-serif; } </style> <![endif]--> <!-- start menu HTML --> <div id="menu"> <ul> <li><a href="link"">Home</a> </li> </ul> <ul> <li><h2>About</h2> <ul> <li><a href="link0.com">About site</a> </li> </ul> </li> </ul> <ul> <li><h2>Search for a plant</h2> <ul> <li><a href="link1.php">Basic Search</a></li> <li><a href="link2.php">Search by Leaf</a></li> <li><a href="link3.php">Search by Flower</a></ul> </li> </ul> <ul> <li><h2>Login</h2> <ul> <li><a href="link4.php">Login</a></li> <li><a href="asdf.html">asdfasdf</a><!-- fully working sample --> <ul> <li><a href="test.html">asdf</a> </li> </ul> </li> </ul> </li> </ul> </div>

I stepped away from teaching myself php for a few months, and I want to work more on the site I'd started. But I found a glitch and have forgotten enough to not know what to do. I have a form, that is filled out. I want it to enter the info into a mysql database and then forward to a new page, using the ID to submit to a second table. If I set the form action to the new page, it goes to the new page, but never submits any info to the database. If I set the form action to itself, it does put the information into the database. I'm not sure what problem this might indicate. Forgive me for dropping in the entire code, but I'm at a loss and learning how important it is to have notes. (and I seem to have forgotten how to put code into a box? is it div class="codeheader"? <html> <title>submit a new plant form </title> <link rel="stylesheet" type="text/css" href="gaiapedia_styles.css"> <body> <?php if (isset($_POST['submitted'])) { $errors = array(); if (empty($_POST['scientific_name'])) { $errors[] = 'you forgot to enter the scientific name'; } else { $sn = trim($_POST['scientific_name']); } if (empty($_POST['common_name_english'])) { $errors[] = 'you forgot to enter the common name'; } else { $cne = trim($_POST['common_name_english']); } $description4 = trim($_POST['common_names_spanish']); $description5 = trim($_POST['common_names_french']); $description6 = trim($_POST['common_name_chinese']); $description7 = trim($_POST['taxonomic_domain']); $description8 = trim($_POST['taxonomic_subkingdom']); $description9 = trim($_POST['taxonomic_superdivision']); $description10 = trim($_POST['taxonomic_phylum_divis']); $description11 = trim($_POST['taxonomic_class']); $description12 = trim($_POST['taxonomic_order']); $description13 = trim($_POST['taxonomic_suborder']); $description14 = trim($_POST['taxonomic_family']); $description15 = trim($_POST['taxonomic_tribe']); $description16 = trim($_POST['taxonomic_genus']); $description17 = trim($_POST['taxonomic_subgenus']); $description18 = trim($_POST['taxonomic_section']); $description19 = trim($_POST['taxonomic_series']); $description20 = trim($_POST['taxonomic_division']); $description21 = trim($_POST['taxonomic_species']); $description22 = trim($_POST['taxonomic_variety']); $description23 = trim($_POST['taxonomic_form']); $description24 = trim($_POST['itis_serial_number']); $description25 = trim($_POST['paraphyletic_grade']); $description26 = trim($_POST['clade1']); $description27 = trim($_POST['subclade1']); $description28 = trim($_POST['subclade2']); $description29 = trim($_POST['subclade3']); $description30 = trim($_POST['subclade4']); $description31 = trim($_POST['subclade_order']); $description32 = trim($_POST['subclade_family']); $description33 = trim($_POST['earliest_date_known']); if (empty($errors)) { require_once ('sqlconnectfile.php'); $query = "INSERT INTO plantae (scientific_name, common_name_english, common_names_spanish, common_names_french, common_name_chinese, taxonomic_domain, taxonomic_subkingdom, taxonomic_superdivision, taxonomic_phylum_divis, taxonomic_class, taxonomic_subclass, taxonomic_order, taxonomic_suborder, taxonomic_family, taxonomic_tribe, taxonomic_genus,taxonomic_subgenus, taxonomic_section, taxonomic_series, taxonomic_division, taxonomic_species, taxonomic_variety, taxonomic_form, itis_serial_number, paraphyletic_grade, clade1, subclade1, subclade2, subclade3, subclade4, subclade_order, subclade_family, latest_date_known, earliest_date_known) VALUES ('$sn', '$cne', '$description4', '$description5', '$description6', '$description7', '$description8', '$description9', '$description10', '$description11', '$description12', '$description13', '$description14', '$description15', '$description16', '$description17', '$description18', '$description19', '$description20', '$description21', '$description22', '$description23', '$description24', '$description25', '$description26', '$description27', '$description28', '$description29', '$description30', '$description31', '$description32', '$description33', '$description34', '$description35')"; $result = @mysql_query ($query); if ($result) { if(isset($_POST['scientific_name'])) { $plant_id=mysql_insert_id(); } exit(); } else { echo 'system error. No plant added'; echo '<p>' . mysql_error() . '<br><br>query:' . $query . '</p>'; exit(); } mysql_close(); } else { echo 'error. the following error occured <br>'; foreach ($errors as $msg) { echo " - $msg<br>\n"; } } // end of if } // end of main submit conditional ?> <form action="insertaplant1.php" method="post"><fieldset><legend><b>Enter your new plant here</b></legend> blahblah <br><br> Plant name<br> <table bgcolor=#FFEC8B width=590> <tr><td> Scientific Name:<br> <input type="text" name="scientific_name" value="<?php if(isset($_POST['scientific_name'])) echo $_POST['scientific_name']; ?>" /><br> <font color=red>*Required field</font><br> </td> <td>Common Names:<br> <input type="text" name="common_name_english" value="<?php if(isset($_POST['common_name_english'])) echo $_POST['common_name_english']; ?>" /><br><br> </td> <td>Common Name, Spanish:<br> <input type="text" name="common_names_spanish" value="<?php if(isset($_POST['common_names_spanish'])) echo $_POST['common_names_spanish']; ?>" /><br><br> </td><tr> <td>Common Names, French:<br> <input type="text" name="common_names_french" value="<?php if(isset($_POST['common_names_french'])) echo $_POST['common_names_french']; ?>" /><br><br> </td> <td>Common names, Chinese:<br> <input type="text" name="common_name_chinese" value="<?php if(isset($_POST['common_name_chinese'])) echo $_POST['common_name_chinese']; ?>" /><br><br> </td> <td>Taxonomic domain:<br> <input type="text" name="taxonomic_domain" value="<?php if(isset($_POST['taxonomic_domain'])) echo $_POST['taxonomic_domain']; ?>" /><br><br> </td></tr><table> <br> <b>Taxonomy, traditional</b><br> <table bgcolor=#EEDD82 width=590> <tr><td>Kingdom:<br><b>Plantae</b><br> </td> <td>Subkingdom:<br> <SELECT NAME="taxonomic_subkingdom" value="<?php if(isset($_POST['taxonomic_subkingdom'])) echo $_POST['taxonomic_subkingdom']; ?>" > <OPTION VALUE="unknown">unknown <OPTION VALUE="Tracheobionta - vascular plants">Tracheobionta - vascular plants <OPTION VALUE="Embryobionta - embryophytes">Embryobionta - embryophytes </SELECT><br><br> </td> <td>Superdivision:<br> <input type="text" name="taxonomic_superdivision" value="<?php if(isset($_POST['taxonomic_superdivision'])) echo $_POST['taxonomic_superdivision']; ?>" /><br><br> </td></tr> <tr><td>Division/phylum:<br> <input type="text" name="taxonomic_phylum_divis" value="<?php if(isset($_POST['taxonomic_phylum_divis'])) echo $_POST['taxonomic_phylum_divis']; ?>" /><br><br> </td> <td>Class:<br> <input type="text" name="taxonomic_class" value="<?php if(isset($_POST['taxonomic_class'])) echo $_POST['taxonomic_class']; ?>" /><br><br> </td> <td>Subclass:<br> <input type="text" name="taxonomic_subclass" value="<?php if(isset($_POST['taxonomic_subclass'])) echo $_POST['taxonomic_subclass']; ?>" /><br><br> </td></tr> <tr><td>Order:<br> <input type="text" name="taxonomic_order" value="<?php if(isset($_POST['taxonomic_order'])) echo $_POST['taxonomic_order']; ?>" /><br><br> </td> <td>Suborder:<br> <input type="text" name="taxonomic_suborder" value="<?php if(isset($_POST['taxonomic_suborder'])) echo $_POST['taxonomic_suborder']; ?>" /><br><br> </td> <td>Subfamily:<br> <input type="text" name="taxonomic_family" value="<?php if(isset($_POST['taxonomic_family'])) echo $_POST['taxonomic_family']; ?>" /><br><br> </td></tr> <tr><td>Tribe:<br> <input type="text" name="taxonomic_tribe" value="<?php if(isset($_POST['taxonomic_tribe'])) echo $_POST['taxonomic_tribe']; ?>" /><br><br> </td> <td>Genus:<br> <input type="text" name="taxonomic_genus" value="<?php if(isset($_POST['taxonomic_genus'])) echo $_POST['taxonomic_genus']; ?>" /><br><br> </td> <td>Subgenus:<br> <input type="text" name="taxonomic_subgenus" value="<?php if(isset($_POST['taxonomic_subgenus'])) echo $_POST['taxonomic_subgenus']; ?>" /><br><br> </td></tr> <tr><td>Section:<br> <input type="text" name="taxonomic_section" value="<?php if(isset($_POST['taxonomic_section'])) echo $_POST['taxonomic_section']; ?>" /><br><br> </td> <td>Series:<br> <input type="text" name="taxonomic_series" value="<?php if(isset($_POST['taxonomic_series'])) echo $_POST['taxonomic_series']; ?>" /><br><br> </td> <td>Variety:<br> <input type="text" name="taxonomic_variety" value="<?php if(isset($_POST['taxonomic_variety'])) echo $_POST['taxonomic_variety']; ?>" /><br><br> </td></tr> <tr><td>Form:<br> <input type="text" name="taxonomic_form" value="<?php if(isset($_POST['taxonomic_form'])) echo $_POST['taxonomic_form']; ?>" /><br><br> </td> <td>Itis Serial Number:<br> <input type="text" name="itis_serial_number" value="<?php if(isset($_POST['itis_serial_number'])) echo $_POST['itis_serial_number']; ?>" /><br><br> </td> <td>Paraphyletic grade:<br> <input type="text" name="paraphyletic_grade" value="<?php if(isset($_POST['paraphyletic_grade'])) echo $_POST['paraphyletic_grade']; ?>" /><br><br> </td></tr> </table> <br> <b>APG Plant Taxonomy (based on evolutionary tree)</b><br> <table bgcolor=#E3CF57 width=590> <tr><td>Clade1:<br> <input type="text" name="clade1" value="<?php if(isset($_POST['clade1'])) echo $_POST['clade1']; ?>" /><br><br> </td> <td>subclade1:<br> <input type="text" name="subclade1" value="<?php if(isset($_POST['subclade1'])) echo $_POST['subclade1']; ?>" /><br><br> </td> <td>subclade2:<br> <input type="text" name="subclade2" value="<?php if(isset($_POST['subclade2'])) echo $_POST['subclade2']; ?>" /><br><br> </td></tr> <tr><td>subclade3:<br> <input type="text" name="subclade3" value="<?php if(isset($_POST['subclade3'])) echo $_POST['subclade3']; ?>" /><br><br> </td> <td>subclade4:<br> <input type="text" name="subclade4" value="<?php if(isset($_POST['subclade4'])) echo $_POST['subclade4']; ?>" /><br><br> </td> <td>subclade_order:<br> <input type="text" name="subclade_order" value="<?php if(isset($_POST['subclade_order'])) echo $_POST['subclade_order']; ?>" /><br><br> </td> </tr> <tr><td colspan=3>subclade_family:<br> <input type="text" name="subclade_family" value="<?php if(isset($_POST['subclade_family'])) echo $_POST['subclade_family']; ?>" /><br> </td><tr> </table> <br> <b>Plant Timeline</b><br> <table bgcolor=#CDAD00 width=590> <tr><td>earliest_date_known:<br> <input type="text" name="earliest_date_known" value="<?php if(isset($_POST['earliest_date_known'])) echo $_POST['earliest_date_known']; ?>" /><br><br> </td> <td colspan=2>latest_date_known:<br> <input type="text" name="latest_date_known" value="<?php if(isset($_POST['latest_date_known'])) echo $_POST['latest_date_known']; ?>" /><br><br> </td> </tr> </table> </fieldset><br><br> <input type="hidden" name="submitted" value="TRUE"> <input type="hidden" name="submitted_forward" value='$sn'> <input type="submit" /> </form>