voici le code:
<?PHP include('../inc/header.php'); ?>
<?PHP include('../inc/menuLeft.php'); ?>
<div id="texte"><div id="overflow">
<div class="cadre"><div class="titre">Videos:</div><div class="marge_interne">
<style type="text/css">
form
{
text-align:center;
}
</style>
<body>
<?php
if (isset($_POST['pseudo']) AND isset($_POST['lien']) AND isset($_POST['categorie']))
{
if ($_POST['pseudo'] != NULL AND $_POST['lien'] != NULL AND $_POST['categorie'] != NULL)
{
// Connexion à MySQL
mysql_connect("localhost", "root", "");
mysql_select_db("site");
// Sécurité injections HTML
$pseudo = mysql_real_escape_string(htmlspecialchars($_POST['pseudo']));
$lien = mysql_real_escape_string(htmlspecialchars($_POST['lien']));
$categorie= mysql_real_escape_string(htmlspecialchars($_POST['categorie']));
// Enregistrement du message
mysql_query("INSERT INTO videos VALUES('$pseudo', '$lien', '$categorie', '$id')") or die(mysql_error());
// Déconnection de MySQL
mysql_close();
}
}
?>
<form action="videos.php" method="post">
<p>
Pseudo : <input type="text" name="pseudo" /><br />
Lien : <input type="text" name="lien" /><br />
Categorie :
<label>
<select name="categorie">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
</label>
</p>
<br>
<input type="submit" value="Envoyer" />
</p>
</form>
<?PHP include('../inc/footer.php'); ?>
Il y a tout pour categorie, et les sql sont comme ceci:
/*
Navicat MySQL Data Transfer
Source Server : site
Source Server Version : 50524
Source Host : localhost:3306
Source Database : site
Target Server Type : MYSQL
Target Server Version : 50524
File Encoding : 65001
Date: 2012-07-16 22:09:39
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `videos`
-- ----------------------------
DROP TABLE IF EXISTS `videos`;
CREATE TABLE `videos` (
`pseudo` text NOT NULL,
`lien` text,
`categorie` varchar(20) DEFAULT NULL,
`id` int(5) NOT NULL AUTO_INCREMENT,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of videos
-- ----------------------------
Met une fois tout les champs remplie rien n'est ajouté a la BDD.
Cordialement Dextouxe
