Databases
StackOverflow2013
Postsdbo
POPHP form won't process in IE
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP form won't process in IE
    primarykey
    data
    text
    <p>The form in which you type a "last name" or number "xxxxx-xx-xxx" works in every browser accept IE. IE 9 and 10 anyway which is all I have access to.</p> <pre><code>&lt;form action="search_view.php" id="contactform" method="get" &gt; &lt;h2&gt;Search AES-MOM UHV Cleaning Database&lt;/h2&gt; &lt;p&gt; &lt;label&gt;Search by Last name or Cost Code:&lt;/label&gt; &lt;input type="text" name="query" value=""&gt;&lt;input name="submit" type="submit" value="Submit"&gt; &lt;/p&gt;&lt;/form&gt; </code></pre> <p>The PHP processing code is below. In IE it returns "Minimum character length is 2" like the form is empty</p> <pre><code>&lt;?php mysql_connect("", "", "") or die("Error connecting to database: ".mysql_error()); /* localhost - it's location of the mysql server, usually localhost root - your username third is your password if connection fails it will stop loading the page and display an error */ mysql_select_db("MOM_vac-cleaning") or die(mysql_error()); /* tutorial_search is the name of database we've created */ ?&gt; &lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt; &lt;html xmlns="http://www.w3.org/1999/xhtml"&gt; &lt;head&gt; &lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8" /&gt; &lt;title&gt;Search results&lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;table&gt; &lt;tr&gt; &lt;td&gt; &lt;?php $query = $_GET['query']; // gets value sent over search form $min_length = 2; // you can set minimum length of the query if you want if(strlen($query) &gt;= $min_length){ // if query length is more or equal minimum length then $query = htmlspecialchars($query); // changes characters used in html to their equivalents, for example: &lt; to &amp;gt; $query = mysql_real_escape_string($query); // makes sure nobody uses SQL injection $raw_results = mysql_query("SELECT * FROM cleaning WHERE lname LIKE '%".$query."%' OR cost_code LIKE '%".$query."%' ORDER BY id DESC") or die(mysql_error()); // '%$query%' is what we're looking for, % means anything, for example if $query is Hello // it will match "hello", "Hello man", "gogohello", if you want exact match use `title`='$query' // or if you want to match just full word so "gogohello" is out use '% $query %' ...OR ... '$query %' ... OR ... '% $query' echo "&lt;table class='table' border='1' cellpadding='3' align='center'&gt;"; echo "&lt;th class='blackbg'&gt;NAME&lt;/th&gt;&lt;th class='blackbg'&gt;GROUP&lt;/th&gt;&lt;th class='blackbg'&gt;COST CODE&lt;/th&gt;&lt;th class='blackbg'&gt;EMAIL&lt;/th&gt;&lt;th class='blackbg'&gt;PHONE&lt;/th&gt;&lt;th class='blackbg'&gt;DATE&lt;br /&gt;REQUIRED&lt;/th&gt;&lt;th class='blackbg'&gt;DESCRIPTION&lt;/th&gt;&lt;th class='blackbg'&gt;INSTRUCTIONS&lt;/th&gt;&lt;th class='blackbg'&gt;ALCOHOL&lt;br /&gt;ACETONE&lt;/th&gt;&lt;th class='blackbg'&gt;REG WASH&lt;br /&gt;CU&lt;/th&gt;&lt;th class='blackbg'&gt;REG WASH&lt;br /&gt;AL/SS&lt;/th&gt;&lt;th class='blackbg'&gt;DRYING&lt;br /&gt;OVEN&lt;/th&gt;&lt;th class='blackbg'&gt;OVEN&lt;br /&gt;TEMP&lt;/th&gt;&lt;th class='blackbg'&gt;UHV OVEN&lt;br /&gt;BAKEOUT&lt;/th&gt;&lt;th class='blackbg'&gt;TEMP/TIME&lt;/th&gt;&lt;th class='blackbg'&gt;BAKEOUT&lt;br /&gt;REQUESTS&lt;/th&gt;&lt;th class='blackbg'&gt;DATE OF&lt;br /&gt;WORK&lt;/th&gt;&lt;th class='blackbg'&gt;TIME&lt;br /&gt;SPENT&lt;/th&gt;&lt;th class='blackbg'&gt;TECHNICIAN&lt;/th&gt;&lt;th class='blackbg'&gt;UHV OVEN&lt;br /&gt;PROGRAM&lt;/th&gt;&lt;th class='blackbg'&gt;COMMENTS&lt;/th&gt;&lt;th class='blackbg'&gt;TECHNICIAN&lt;/th&gt;&lt;/tr&gt;"; if(mysql_num_rows($raw_results) &gt; 0){ // if one or more rows are returned do following while($results = mysql_fetch_array($raw_results)){ // $results = mysql_fetch_array($raw_results) puts data from database into array, while it's valid it does the loop echo "&lt;tr&gt;"; echo "&lt;td&gt;" . $results['fname'] . " " . $results['lname'] . "&lt;/td&gt;"; echo "&lt;td&gt;" . $results['group']."&lt;/td&gt;"; echo "&lt;td&gt;" . $results['cost_code']."&lt;/td&gt;"; echo "&lt;td&gt;" . $results['email']."&lt;/td&gt;"; echo "&lt;td&gt;" . $results['phone'] . "&lt;/td&gt;"; echo "&lt;td&gt;" . $results['date_req'] . "&lt;/td&gt;"; echo "&lt;td&gt;" . $results['description']."&lt;/td&gt;"; echo "&lt;td&gt;" . $results['instructions']."&lt;/td&gt;"; //echo "&lt;td&gt;" . $results['alc']."&lt;/td&gt;"; if($results['alc'] == "1"){ echo "&lt;td bgcolor='#C5EECD' align='center'&gt;Yes&lt;/td&gt;"; } else if ($results['alc'] == "0"){ echo "&lt;td bgcolor='#F7C1C8' align='center'&gt;No&lt;/td&gt;";} //echo "&lt;td&gt;" . $results['reg_copper']."&lt;/td&gt;"; if($results['reg_copper'] == "1"){ echo "&lt;td bgcolor='#C5EECD' align='center'&gt;Yes&lt;/td&gt;"; } else if ($results['reg_copper'] == "0"){ echo "&lt;td bgcolor='#F7C1C8' align='center'&gt;No&lt;/td&gt;";} //echo "&lt;td&gt;" . $results['reg_alum'] . "&lt;/td&gt;"; if($results['reg_alum'] == "1"){ echo "&lt;td bgcolor='#C5EECD' align='center'&gt;Yes&lt;/td&gt;"; } else if ($results['reg_alum'] == "0"){ echo "&lt;td bgcolor='#F7C1C8' align='center'&gt;No&lt;/td&gt;";} //echo "&lt;td&gt;" . $results['drying'] . "&lt;/td&gt;"; if($results['drying'] == "1"){ echo "&lt;td bgcolor='#C5EECD' align='center'&gt;Yes&lt;/td&gt;"; } else if ($results['drying'] == "0"){ echo "&lt;td bgcolor='#F7C1C8' align='center'&gt;No&lt;/td&gt;";} echo "&lt;td&gt;" . $results['temp'] . "&lt;/td&gt;"; //echo "&lt;td&gt;" . $results['uhv'] . "&lt;/td&gt;"; if($results['uhv'] == "1"){ echo "&lt;td bgcolor='#C5EECD' align='center'&gt;Yes&lt;/td&gt;"; } else if ($results['uhv'] == "0"){ echo "&lt;td bgcolor='#F7C1C8' align='center'&gt;No&lt;/td&gt;";} echo "&lt;td&gt;" . $results['temp_time'] . "&lt;/td&gt;"; echo "&lt;td&gt;" . $results['bake_req'] . "&lt;/td&gt;"; echo "&lt;td&gt;" . $results['hours'] . "&lt;/td&gt;"; echo "&lt;td&gt;" . $results['time_spent'] . "&lt;/td&gt;"; echo "&lt;td&gt;" . $results['tech'] . "&lt;/td&gt;"; echo "&lt;td&gt;" . $results['program'] . "&lt;/td&gt;"; echo "&lt;td&gt;" . $results['comments'] . "&lt;/td&gt;"; echo "&lt;td&gt;" . $results['techII'] . "&lt;/td&gt;"; echo "&lt;/tr&gt;"; // posts results gotten from database(title and text) you can also show id ($results['id']) } // close table&gt; echo "&lt;/table&gt;"; } else{ // if there is no matching rows do following echo "No results meeting your search criteria have been found"; } } else{ // if query length is less than minimum echo "Minimum character length is ".$min_length; } ?&gt; </code></pre> <p>Any help would be greatly appreciated!</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USbech64
    1. USbech64
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COI'm not sure if that extra = in your input is a typo. Try dumping your $_GET and see what's in there.
      singulars
      1. POPHP form won't process in IE
      1. USaynber
    2. COOff topic: Please be aware that PHP's `mysql_xxx()` functions are deprecated. If possible, please consider converting to using a more modern database API such as PDO.
      singulars
      1. POPHP form won't process in IE
      1. USSpudley
    3. CORun the resulting HTML through a [HTML validator](http://validator.w3.org/) first, then fix all issues. Report back if you still have a problem. It’s unlikely that the backend code will have anything to do with a single browser not working correctly; the backend usually does not care about browsers.
      singulars
      1. POPHP form won't process in IE
      1. USpoke
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload