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 Like 43 Dislike
Previous forums Next forums
Other forums

PHP Cannot redeclare class
I have 6 files, and two of them do not seem to want to play well. I keep getting a "Cannot rede

Error in write byte array into document in SM58
Hi Gurus,

Getting the following error status in Transactional RFC (SM58) ..... *Error i

CU&UC guide
Hi Gurus,

can anybody provide me the link for CU&UC upgrade guide

Thanks i

generating all possible random letters
hi'

how can i randomize the letters a,b,c,d,e all possible ways, and i want to print the res

Generate multilayered array from string.
ok so i have a string that looks like this:
Code: blog:edit_all,delete_all|users:edit_all,delete_

Displaying an image using echo command
I had done a query on my database, one of the fields being an image reference to a directory where a

How a counter of users ? such as ---> (231 Viewing)
I want to count how many users are actually viewing the page, How is that possible?
Thank you guy

PHP and Javascript
Hello Everyone,

I have a page that needs a javascript code to be written between PHP code but

Port scanner problem
Hai
recently i developed one app through which u can check the opened and closed ports under an

Beginners syntax and loop questions - help please!
Hi everyone,

I have some problems with php code. I'm currently in the middle of learning php,

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash