1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65
| <?php
$mysqli = new mysqli("127.0.0.1", "root", "", "elevagedubanney");
if ($mysqli->connect_errno) {
echo "Echec lors de la connexion à MySQL : " . $mysqli->connect_error;
}
if(isset($_POST['nom'], $_POST['race'], $_POST['pere'], $_POST['mere'],$_POST['peredemere'],$_POST['texte'], $_POST['lienyoutube'], $_POST['MAX_FILE_SIZE'] ))
{
echo "";
}
else
{
echo "La valeur n'est pas transmise <br/>";
}
if ($_FILES['fichier']['size'] > $_POST ['MAX_FILE_SIZE'])
{
echo"fichier trop gros<br/>";
}
else
{
echo "taille correcte<br/>";
}
$extensions_valides = array( 'jpg' , 'jpeg' );
$extension_upload = strtolower( substr( strrchr($_FILES['fichier']['name'], '.') ,1) );
if ( in_array($extension_upload,$extensions_valides) )
echo "Extension correcte <br/>";
if ($_FILES['fichier']['error'] > 0)
{
echo"pas de photo<br/>";
}
$dir= '../Photos_galerie';
$nom = $_FILES['fichier']['name'];
$res = move_uploaded_file($_FILES['fichier']['tmp_name'], "$dir/$nom");
$sql="INSERT INTO chevaux_a_vendre (nom,race,pere,mere,pere_de_mere,texte,photo, lien_youtube)VALUES (?,?,?,?,?,?,?,?)";
$resultat = mysqli_prepare($mysqli,$sql);
if($resultat)
{
echo $resultat;
}
$ok = mysqli_stmt_bind_param($resultat,'ssssssss',$nom,$race,$pere,$mere,$pere_de_mere,$texte,$photo,$lien_youtube);
$nom= $_POST['nom'];
$pere=$_POST['pere'];
$mere=$_POST['mere'];
$pere_de_mere=$_POST['peredemere'];
$texte= $_POST['texte'];
$photo=$_FILES['fichier'];
$lien_youtube=$_POST['lienyoutube'];
$ok = mysqli_stmt_execute($resultat);
if($ok==FALSE)
{
echo"echec de l'insertion";
}
else
{
echo"insertion réussie";
}
?> |
Partager