StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>There are quite a few things wrong.</p> <p>You are not using the <code>name</code> attribute on the <code>input</code>/<code>select</code> elements. They need to have a <code>name</code> in order for them to be sent with the POST request. The <code>id</code> attribute has nothing to do with forms (except when using labels; the <code>for</code> attribute points to them)</p> <pre><code><form action="/path/to/php/file.php" method="post" id="addform"> <div> <label for="carname">CName</label> <input type="text" name="carname" id="carname"> </div> <div> <label for="fuel">Fuel</label> <select id="fuel" name="fuel"> <option value="Petrol">Petrol</option> <option value="Diesel">Diesel</option> <option value="Hybrid">Hybrid</option> <option value="LPG">LPG</option> </select> </div> <div> <label for="transmission">Transmission</label> <select id="transmission" name="transmission"> <option value="Automatic">Automatic</option> <option value="Manual">Manual</option> <option value="Semi-Auto">Semi-Auto</option> </select> </div> <div> <label for="engine">Engine</label> <input type="text" id="engine" name="engine"> </div> <div> <label for="doors">Doors</label> <input type="text" id="doors" name="doors"> </div> <div> <label for="total">Total</label> <input type="text" id="total" name="total"> </div> <div> <label for="submit">Engine</label> <input type="submit" id="submit" value="Add Car" onclick="addRecord()"> </div> </form> </code></pre> <p>As for the javascript, it is much easier to use jQuery (or a similar library). It abstracts away all the nitty-gritty details and browser differences, and makes your life much easier.</p> <pre><code><script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script> <script> // When the page is done loading... $(function () { // When the form is submitted $("form#addform").on("submit", function () { // Get the form data and serialize it var data = $(this).serialize(); // Create a POST request var post = $.post("/path/to/php/file.php", data); // When the request is done show a message post.done(function () { alert("Form submitted!"); }); // If the request fails show another message post.fail(function () { alert("Error! Form not submitted."); }); // Returning false prevents the form's normal // behaviour, i.e. its submission return false; }); }); </script> </code></pre> <p>Looking at your PHP code it looks like you have just learnt PHP: You are using a deprecated extension (<code>mysql</code>); you just use POST variables without bothering with security; and your SQL code looks a little iffy (e.g. what is <code>AVAILABLE</code> and why is it set to <code>$total</code>?); and finally, string array indices should be quoted.</p> <pre><code>// Database handle $db = new MySQLi('194.81.104.27', 'www', 'www', 'xyz'); // SQL query with placeholders $sql = "INSERT INTO tbl (CARNAME,FUELTYPE,TRANSMISSION,ENGINESIZE,DOORS,TOTAL) VALUES (?,?,?,?,?,?)"; // Create a statement object $stmt = $db->prepare($sql); // Fill in the placeholders $stmt->bind_param('ssssii', $carname, $fuel, $transmission, $engine, $doors, $total); // Set the values $carname = filter_input(INPUT_POST, 'cname', FILTER_SANITIZE_STRING); $fuel = filter_input(INPUT_POST, 'fuel', FILTER_SANITIZE_STRING); $transmission = filter_input(INPUT_POST, 'transmission', FILTER_SANITIZE_STRING); $engine = filter_input(INPUT_POST, 'engine', FILTER_SANITIZE_STRING); $doors = filter_input(INPUT_POST, 'doors', FILTER_SANITIZE_NUMBER_INT); $total = filter_input(INPUT_POST, 'total', FILTER_SANITIZE_NUMBER_INT); // If the statement was not executed then there was an error if ($stmt->execute() === false) { header('HTTP/1.0 404 Not Found', true, 404); } // Done </code></pre> <p><strong>Note:</strong> I never tested any of the examples. I just wrote them down in my text editor, as needed, so you will probably need to adapt them.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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