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
Calculating a rating by adding number of points and dividing by number of items
I have a site that users can post links to files to download. They can rate these files on a 1-5 sca
Send inserts to mysql thru port 80
Hi!
I have an application that must do some inserts in a mysql db. This db is behind a firewa
login from external site
Hi my new experience begins, Now what i am trying to do is i make three pages, login.php logout.php
PHP error (line 38) my website
Hello everyone, I'm new on this
and I got a web site thats got a error not showing the photos on<
Optimize Code
Just started getting into the use of cookies. The following code will redirect users to a set URL s
scandir clients directory
hi,
how can i scandir the clients directory? i need a script that when i click a button it will u
session variable problem
Session variable is not working in Fire fox i am getting null value but it is working fine in IE.Error in SQL Syntax HELP!!!
I have this page:
Code: <?php
session_start();
//connect to server and s
form help
this doesn't work. i want the form action to go the location.href of the submit button chosen.. how
Product categories for registration
Dear all,
We are going live with the Supplier registered next week. At standard, the 'sel
