· 7 years ago · Sep 18, 2018, 06:06 PM
1How can I insert this data correctly into my MySql table?
2CREATE TABLE IF NOT EXISTS `products` (
3 `serial` int(11) NOT NULL AUTO_INCREMENT,
4 `name` varchar(20) COLLATE latin1_general_ci NOT NULL,
5 `description` varchar(255) COLLATE latin1_general_ci NOT NULL,
6 `price` float NOT NULL,
7 `picture` varchar(80) COLLATE latin1_general_ci NOT NULL,
8 PRIMARY KEY (`serial`)
9) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;
10
11<?php
12include('config.php');
13
14 echo '<h1 style="font-size:20px;">Sieraad toevoegen</h1>';
15if ($_SERVER['REQUEST_METHOD'] == 'POST') {
16 if (empty($_POST['naam']) || empty($_POST['prijs'])) {
17 echo '<span style="color:red"><b>Niet alle velden zijn ingevuld!</b></span>';
18 } else {
19 mysql_query("INSERT INTO products (name, description, picture, price) VALUES ('$_POST[naam]','$_POST[beschrijving]','$_POST[foto]', '$_POST[prijs]', NOW())") or die (mysql_error());
20 echo '<span style="color:green"><b>Het sieraad is succesvol toegevoegd!</b></span>';
21 }
22}
23echo '<form method="post" target="_self">';
24echo '<input type="hidden" name="serial">';
25echo 'Naam van sieraad:<br><input type="text" name="naam"><br>';
26echo 'Beschrijving:<br><textarea type="text" maxlength="250" name="beschrijving" rows="6" cols="37"></textarea><br>';
27/**echo '<input name="MAX_FILE_SIZE" value="102400" type="hidden">';**/
28echo 'Foto:<br><input type="text" name="foto"><br>';
29echo 'Prijs:<br><input type="text" name="prijs" maxlength:"7"><br>';
30echo '<input type="submit" value="Toevoegen" onclick="this.value='Sieraad wordt verwerkt...';"> <input type="reset" value="Wis velden">';
31echo '</form>';
32?>
33
34mysql_query("INSERT INTO products (naam, beschrijving, prijs) VALUES
35('$_POST[naam]','$_POST[beschrijving]','$_POST[prijs]', NOW())") or die (mysql_error());