patheticsam Posted February 18, 2010 Share Posted February 18, 2010 Hi!, I'm a little bit new with php and I have a little issue here. I created a webform to insert some infos into a MySQL database. The weird thing is that some of the infos is correctly inserted and some not? I doubled checked my code and can't find what it is since it's a pretty simple code. If anyone can help, it would be really appreciated! Here the form code : <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="fr"> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> <link href="../../css/style1.css" rel="stylesheet" type="text/css" /> <title>LVA ENTERTAINEMENT</title> </head> <center> <br /><br /> <b>Ajout d'un Artiste L.V.A</b><br><br> <form enctype="multipart/form-data" action="processes/insert_artist.php" method="POST" target="main2"> <table cellspacing="0" cellpadding="4" width="550"> <tr> <td width="275">Nom de l'artiste : </td> <td width="225"><input type="text" name="artist" class="login" style="width: 250px"></td> </tr> <tr> <td>Label : </td> <td><input type="text" name="label" class="login" value="L.V.A ENTERTAINMENT" style="width: 250px"></td> </tr> <tr> <td>Site Web : </td> <td><input type="text" name="website" class="login" style="width: 250px"></td> </tr> <tr> <td>Albums : </td> <td><input type="text" name="albums" class="login" style="width: 250px"></td> </tr> <tr> <td>Photo 1 :</td> <td><input type="file" name="uploadedfile" class="login" style="width: 250px"></td> </tr> <tr> <td colspan="2">Biographie :</td> </tr> <tr> <td colspan="2"><textarea style="width: 550px" rows="15" class="login" name="bio"></textarea></td> </tr> <tr> <td colspan="2" height="40" align="right" valign="bottom"><input type="submit" value="Enregsitrer" class="login"></td> </tr> </table> </form> And now here's the PHP code : <?php $target_path = "../artists photo/"; $target_path = $target_path . basename( $_FILES['uploadedfile']['name']); $picture = basename( $_FILES['uploadedfile']['name']); if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) { echo "<center><br /><br />votre photo $picture a été correctement enregistré</center><br>"; } else{ echo "<center><br /><br />Il y a eu un problème avec l'instertion de votre photo</center><br>"; } ?> <?php $con = mysql_connect("server","user","pass"); $artist = mysql_real_escape_string($_POST['artist']); $label = mysql_real_escape_string($_POST['label']); $website = mysql_real_escape_string($_POST['website']); $albums = mysql_real_escape_string($_POST['albums']); $photo = mysql_real_escape_string($_POST['uploadedfile']); $bio = mysql_real_escape_string($_POST['bio']); if (!$con) { die('Could not connect: ' . mysql_error()); }mysql_select_db("a1808796_data", $con);$sql="INSERT INTO artists ( artist, label, website, albums, photo, bio) VALUES ('$artist','$label','website','$albums','$photo','$bio')";if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "<br /><br /><center>Votre artiste a correctement été ajouté à la base de donnée.<br /><br /><a href=\"panel.php\" target=\"main2\">Retour au paneau de contrôle</a></center>"; ?> As you can see I have artist, label, website, albums, photo, bio the artist, label, albums and bio insterts correctly "website" always inster "website" instead of the value posted in the form the uploaded file (wich is a picture file) uploads correctly but the value ($photo) is not inserted into the DB.... If anyone sees the problem please help!!!!! thanks! Link to comment https://forums.phpfreaks.com/topic/192546-little-problem-with-form-insertion-in-mysql-please-help/ Share on other sites More sharing options...
LeadingWebDev Posted February 18, 2010 Share Posted February 18, 2010 $target_path="../artists photo/"; $target_path.=basename( $_FILES['uploadedfile']['name']); ... ..... ... $photo = $target_path; if so u want to save file under original name: $_POST['uploadedfile'] -> $_FILES['uploadedfile']['name'] Link to comment https://forums.phpfreaks.com/topic/192546-little-problem-with-form-insertion-in-mysql-please-help/#findComment-1014451 Share on other sites More sharing options...
patheticsam Posted February 18, 2010 Author Share Posted February 18, 2010 It worked for the "photo" part. Thanx!!! But still I can't understand why the "website" does not enter the value inserted in the form but always insert "website" as the value.... Link to comment https://forums.phpfreaks.com/topic/192546-little-problem-with-form-insertion-in-mysql-please-help/#findComment-1014459 Share on other sites More sharing options...
patheticsam Posted February 18, 2010 Author Share Posted February 18, 2010 Nevermind just got it! THANX!!! Link to comment https://forums.phpfreaks.com/topic/192546-little-problem-with-form-insertion-in-mysql-please-help/#findComment-1014461 Share on other sites More sharing options...
LeadingWebDev Posted February 18, 2010 Share Posted February 18, 2010 seen? in query 'website' -> '$website' SOLVED Link to comment https://forums.phpfreaks.com/topic/192546-little-problem-with-form-insertion-in-mysql-please-help/#findComment-1014462 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.