Little problem with form insertion in MySQL, Please help!!!
Posted on
16th Feb 2014 07:03 pm by
admin
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 :
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>
<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>
";
} else{
echo "<center><br /><br />Il y a eu un problème avec l'instertion de votre photo</center>
";
}
?>
<?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
No comments posted yet
Your Answer:
Login to answer
65 
43 
Other forums
FlashVar function how to insert variables
Hi guys. Im new in this forum and also new in php programming. Can you help me about this code?
<
Interpret Order
Hello all,
I'm wondering if I have this:
Code: $switch = array(
'one' =>
Problem with Sending Mail by PHP
hello all,
I m new to php, can u plz provide me the code to send mail by php having CAPTC
problem with php server update from mid 2009
Hi,
I have this navigation menu on 2 websites which used to work just fine. After a recent up
Quick fix: Conditional statement with an array
Hi, I'm getting the temperature value off of the Environment Canada website along with the icon file
Performance impact of cookies
Hi, I was just wondering what impact there would be in terms of performance if you where to set then
Trigger tag in aspx is not coming
hi all ,iam new to ajax, iam using file upload inside the update pannel but right now i want to use
Passing vars to the DB
I have 3 small testing tables:
ID TYPE
1 pepperoni
2 C. bacon
3 taco
ID TY
$GPRMC and NMEA how to extract from report
Hi There,
Im a little bi lost and not sure where to start with this one, ive got a small gps
How to use Substr
I want to check for the word CATEGORY: inside a string which can be CATEGORY: ITEM
and remove the
