Updating data feilds with php

[underground]

I have been working around this for sometime. I can update text feilds but have ran into a problem with this script from a previous post. I'm trying to update data store in mysql see below example..

See second post for upload script.. Post too long!

[underground]

[PHP]
<?
include("include/session.php");
?>
<?php
if(isset($_POST['upload']) && $_FILES['ud_userfile']['size'] && $_FILES['ud_audiofile1']['size'] && $_FILES['ud_audiofile2']['size'] && $_FILES['ud_audiofile3']['size'] && $_FILES['ud_audiofile4']['size'] && $_FILES['ud_audiofile5']['size'] && $_FILES['ud_audiofile6']['size'] && $_FILES['ud_audiofile7']['size'] && $_FILES['ud_audiofile8']['size'] && $_FILES['ud_audiofile9']['size'] && $_FILES['ud_audiofile10']['size'] && $_FILES['ud_audiofile11']['size'] && $_FILES['ud_audiofile12']['size'] && $_FILES['ud_audiofile13']['size'] && $_FILES['ud_audiofile14']['size'] && $_FILES['ud_audiofile15']['size'] && $_FILES['ud_audiofile16']['size'] > 0)
{
$ud_fileName = $_FILES['ud_userfile']['name'];
$ud_tmpName = $_FILES['ud_userfile']['tmp_name'];
$ud_fileSize = $_FILES['ud_userfile']['size'];
$ud_fileType = $_FILES['ud_userfile']['type'];

$ud_fileName1 = $_FILES['ud_audiofile1']['name'];
$ud_tmpName1 = $_FILES['ud_audiofile1']['tmp_name'];
$ud_fileSize1 = $_FILES['ud_audiofile1']['size'];
$ud_fileType1 = $_FILES['ud_audiofile1']['type'];

$ud_fileName2 = $_FILES['ud_audiofile2']['name'];
$ud_tmpName2 = $_FILES['ud_audiofile2']['tmp_name'];
$ud_fileSize2 = $_FILES['ud_audiofile2']['size'];
$ud_fileType2 = $_FILES['ud_audiofile2']['type'];

$ud_fileName3 = $_FILES['ud_audiofile3']['name'];
$ud_tmpName3 = $_FILES['ud_audiofile3']['tmp_name'];
$ud_fileSize3 = $_FILES['ud_audiofile3']['size'];
$ud_fileType3 = $_FILES['ud_audiofile3']['type'];

$ud_fileName4 = $_FILES['ud_audiofile4']['name'];
$ud_tmpName4 = $_FILES['ud_audiofile4']['tmp_name'];
$ud_fileSize4 = $_FILES['ud_audiofile4']['size'];
$ud_fileType4 = $_FILES['ud_audiofile4']['type'];

$ud_fileName5 = $_FILES['ud_audiofile5']['name'];
$ud_tmpName5 = $_FILES['ud_audiofile5']['tmp_name'];
$ud_fileSize5 = $_FILES['ud_audiofile5']['size'];
$ud_fileType5 = $_FILES['ud_audiofile5']['type'];

$ud_fileName6 = $_FILES['ud_audiofile6']['name'];
$ud_tmpName6 = $_FILES['ud_audiofile6']['tmp_name'];
$ud_fileSize6 = $_FILES['ud_audiofile6']['size'];
$ud_fileType6 = $_FILES['ud_audiofile6']['type'];

$ud_fileName7 = $_FILES['ud_audiofile7']['name'];
$ud_tmpName7 = $_FILES['ud_audiofile7']['tmp_name'];
$ud_fileSize7 = $_FILES['ud_audiofile7']['size'];
$ud_fileType7 = $_FILES['ud_audiofile7']['type'];

$ud_fileName8 = $_FILES['ud_audiofile8']['name'];
$ud_tmpName8 = $_FILES['ud_audiofile8']['tmp_name'];
$ud_fileSize8 = $_FILES['ud_audiofile8']['size'];
$ud_fileType8 = $_FILES['ud_audiofile8']['type'];

$ud_fileName9 = $_FILES['ud_audiofile9']['name'];
$ud_tmpName9 = $_FILES['ud_audiofile9']['tmp_name'];
$ud_fileSize9 = $_FILES['ud_audiofile9']['size'];
$ud_fileType9 = $_FILES['ud_audiofile9']['type'];

$ud_fileName10 = $_FILES['ud_audiofile10']['name'];
$ud_tmpName10 = $_FILES['ud_audiofile10']['tmp_name'];
$ud_fileSize10 = $_FILES['ud_audiofile10']['size'];
$ud_fileType10 = $_FILES['ud_audiofile10']['type'];

$ud_fileName11 = $_FILES['ud_audiofile11']['name'];
$ud_tmpName11 = $_FILES['ud_audiofile11']['tmp_name'];
$ud_fileSize11 = $_FILES['ud_audiofile11']['size'];
$ud_fileType11 = $_FILES['ud_audiofile11']['type'];

$ud_fileName12 = $_FILES['ud_audiofile12']['name'];
$ud_tmpName12 = $_FILES['ud_audiofile12']['tmp_name'];
$ud_fileSize12 = $_FILES['ud_audiofile12']['size'];
$ud_fileType12 = $_FILES['ud_audiofile12']['type'];

$ud_fileName13 = $_FILES['ud_audiofile13']['name'];
$ud_tmpName13 = $_FILES['ud_audiofile13']['tmp_name'];
$ud_fileSize13 = $_FILES['ud_audiofile13']['size'];
$ud_fileType13 = $_FILES['ud_audiofile13']['type'];

$ud_fileName14 = $_FILES['ud_audiofile14']['name'];
$ud_tmpName14 = $_FILES['ud_audiofile14']['tmp_name'];
$ud_fileSize14 = $_FILES['ud_audiofile14']['size'];
$ud_fileType14 = $_FILES['ud_audiofile14']['type'];

$ud_fileName15 = $_FILES['ud_audiofile15']['name'];
$ud_tmpName15 = $_FILES['ud_audiofile15']['tmp_name'];
$ud_fileSize15 = $_FILES['ud_audiofile15']['size'];
$ud_fileType15 = $_FILES['ud_audiofile15']['type'];

$ud_fileName16 = $_FILES['ud_audiofile16']['name'];
$ud_tmpName16 = $_FILES['ud_audiofile16']['tmp_name'];
$ud_fileSize16 = $_FILES['ud_audiofile16']['size'];
$ud_fileType16 = $_FILES['ud_audiofile16']['type'];

$fp = fopen($ud_tmpName, 'r');
$ud_content = fread($fp, filesize($ud_tmpName));
$ud_content = addslashes($ud_content);
$fp = fopen($ud_tmpName1, 'r');
$ud_audiofile1 = fread($fp, filesize($ud_tmpName1));
$ud_audiofile1 = addslashes($ud_audiofile1);
$fp = fopen($ud_tmpName2, 'r');
$ud_audiofile2 = fread($fp, filesize($ud_tmpName2));
$ud_audiofile2 = addslashes($ud_audiofile2);
$fp = fopen($ud_tmpName3, 'r');
$ud_audiofile3 = fread($fp, filesize($ud_tmpName3));
$ud_audiofile3 = addslashes($ud_audiofile3);
$fp = fopen($ud_tmpName4, 'r');
$ud_audiofile4 = fread($fp, filesize($ud_tmpName4));
$ud_audiofile4 = addslashes($ud_audiofile4);
$fp = fopen($ud_tmpName5, 'r');
$ud_audiofile5 = fread($fp, filesize($ud_tmpName5));
$ud_audiofile5 = addslashes($ud_audiofile5);
$fp = fopen($ud_tmpName6, 'r');
$ud_audiofile6 = fread($fp, filesize($ud_tmpName6));
$ud_audiofile6 = addslashes($ud_audiofile6);
$fp = fopen($ud_tmpName7, 'r');
$ud_audiofile7 = fread($fp, filesize($ud_tmpName7));
$ud_audiofile7 = addslashes($ud_audiofile7);
$fp = fopen($ud_tmpName8, 'r');
$ud_audiofile8 = fread($fp, filesize($ud_tmpName8));
$ud_audiofile8 = addslashes($ud_audiofile8);
$fp = fopen($ud_tmpName9, 'r');
$ud_audiofile9 = fread($fp, filesize($ud_tmpName9));
$ud_audiofile9 = addslashes($ud_audiofile9);
$fp = fopen($ud_tmpName10, 'r');
$ud_audiofile10 = fread($fp, filesize($ud_tmpName10));
$ud_audiofile10 = addslashes($ud_audiofile10);
$fp = fopen($ud_tmpName11, 'r');
$ud_audiofile11 = fread($fp, filesize($ud_tmpName11));
$ud_audiofile11 = addslashes($ud_audiofile11);
$fp = fopen($ud_tmpName12, 'r');
$ud_audiofile12 = fread($fp, filesize($ud_tmpName12));
$ud_audiofile12 = addslashes($ud_audiofile12);
$fp = fopen($ud_tmpName13, 'r');
$ud_audiofile13 = fread($fp, filesize($ud_tmpName13));
$ud_audiofile13 = addslashes($ud_audiofile13);
$fp = fopen($ud_tmpName14, 'r');
$ud_audiofile14 = fread($fp, filesize($ud_tmpName14));
$ud_audiofile14 = addslashes($ud_audiofile14);
$fp = fopen($ud_tmpName15, 'r');
$ud_audiofile15 = fread($fp, filesize($ud_tmpName15));
$ud_audiofile15 = addslashes($ud_audiofile15);
$fp = fopen($ud_tmpName16, 'r');
$ud_audiofile16 = fread($fp, filesize($ud_tmpName16));
$ud_audiofile16 = addslashes($ud_audiofile16);
fclose($fp);
if(!get_magic_quotes_gpc())
{
$ud_fileName = addslashes($ud_fileName);
$ud_fileName1 = addslashes($ud_fileName1);
$ud_fileName2 = addslashes($ud_fileName2);
$ud_fileName3 = addslashes($ud_fileName3);
$ud_fileName4 = addslashes($ud_fileName4);
$ud_fileName5 = addslashes($ud_fileName5);
$ud_fileName6 = addslashes($ud_fileName6);
$ud_fileName7 = addslashes($ud_fileName7);
$ud_fileName8 = addslashes($ud_fileName8);
$ud_fileName9 = addslashes($ud_fileName9);
$ud_fileName10 = addslashes($ud_fileName10);
$ud_fileName11 = addslashes($ud_fileName11);
$ud_fileName12 = addslashes($ud_fileName12);
$ud_fileName13 = addslashes($ud_fileName13);
$ud_fileName14 = addslashes($ud_fileName14);
$ud_fileName15 = addslashes($ud_fileName15);
$ud_fileName16 = addslashes($ud_fileName16);

}
include 'config.php';
include 'opendb.php';

"see next post for the rest of the code"!
?>
[/PHP]

[underground]

Here is the rest of the Code for the upload,' sorry for the mutiple post but site imitation...:-)
[PHP]
$query = "UPDATE pix SET name, size, type, content, name1, size1, type1, audiofile1, name2, size2, type2, audiofile2, name3, size3, type3, audiofile3, name4, size4, type4, audiofile4, name5, size5, type5, audiofile5, name6, size6, type6, audiofile6, name7, size7, type7, audiofile7, name8, size8, type8, audiofile8, name9, size9, type9, audiofile9, name10, size10, type10, audiofile10, name11, size11, type11, audiofile11, name12, size12, type12, audiofile12, name13, size13, type13, audiofile13, name14, size14, type14, audiofile14, name15, size15, type15, audiofile15, name16, size16, type16, audiofile16 WHERE username='$session->username' ".
"VALUES ( fileName='$ud_fileName', fileSize='$ud_fileSize', fileType='$ud_fileType', content='$ud_content', fileName1='$ud_fileName1', fileSize1='$ud_fileSize1', fileType1='$ud_fileType1', audiofile='$ud_audiofile1', fileName2='$ud_fileName2', fileSize2='$ud_fileSize2', fileType2='$ud_fileType2', audiofile2='$ud_audiofile2', fileName3='$ud_fileName3', fileSize3='$ud_fileSize3', fileType3='$ud_fileType3', audiofile3='$ud_audiofile3', fileName4='$ud_fileName4', fileSize4='$ud_fileSize4', fileType4='$ud_fileType4', audiofile4='$ud_audiofile4', fileName5='$ud_fileName5', fileSize5='$ud_fileSize5', fileType5='$ud_fileType5', audiofile5='$ud_audiofile5', fileName6='$ud_fileName6', fileSize6='$ud_fileSize6', fileType6='$ud_fileType6', audiofile6='$ud_audiofile6', fileName7='$ud_fileName7', fileSize7='$ud_fileSize7', fileType7='$ud_fileType7', audiofile7='$ud_audiofile7', fileName8='$ud_fileName8', fileSize8='$ud_fileSize8', fileType8='$ud_fileType8', audiofile8='$ud_audiofile8', fileName9='$ud_fileName9', fileSize9='$ud_fileSize9', fileType9='$ud_fileType9', audiofile9='$ud_audiofile9', fileName10='$ud_fileName10', fileSize10='$ud_fileSize10', fileType10='$ud_fileType10', audiofile10='$ud_audiofile10', fileName11='$ud_fileName11', fileSize11='$ud_fileSize11', fileType11='$ud_fileType11', audiofile11='$ud_audiofile11', fileName12='$ud_fileName12', fileSize12='$ud_fileSize12', fileType12='$ud_fileType12', audiofile12='$ud_audiofile12', fileName13='$ud_fileName13', fileSize13='$ud_fileSize13', fileType13='$ud_fileType13', audiofile13='$ud_audiofile13', fileName14='$ud_fileName14', fileSize14='$ud_fileSize14', fileType14='$ud_fileType14', audiofile14='$ud_audiofile14', fileName15='$ud_fileName15', fileSize15='$ud_fileSize15', fileType15='$ud_fileType15', audiofile15='$ud_audiofile15', fileName16='$ud_fileName16', fileSize16='$ud_fileSize16', fileType16='$ud_fileType16', audiofile16='$ud_audiofile16')";
mysql_query($query) or die('Error, query failed');
include 'closedb.php';
}
?>
[/PHP]

The upload is coming from the a html form like so

[PHP]
<?

if($session->logged_in){
echo "<form action=\"audio update.php\" method=\"post\" enctype=\"multipart/form-data\">";
echo "<table width=\"750\" cellpadding=\"1\" cellspacing=\"1\" class=\"box\">";
echo "<tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"8888000000\">
UPDATE TRACK 1 - &nbsp;&nbsp;$name
&nbsp;&nbsp;<input name=\"ud_userfile\" type=\"file\" id=\"ud_userfile\">
</td>";
echo "</tr>";
echo "<tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"888000000\">
UPDATE TRACK 2 - &nbsp;&nbsp;$name1
<input name=\"ud_audiofile1\" type=\"file\" id=\"ud_audiofile1\">
</td>";
echo "</tr>";
echo "<tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"888000000\">
UPDATE TRACK 3 - &nbsp;&nbsp;$name2
<input name=\"ud_audiofile2\" type=\"file\" id=\"ud_audiofile2\">
</td>";
echo "</tr>";
echo "<tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"8888000000\">
UPDATE TRACK 4 - &nbsp;&nbsp;$name3
<input name=\"ud_audiofile3\" type=\"file\" id=\"ud_audiofile3\">
</td>";
echo "</tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"8888000000\">
UPDATE TRACK 5 - &nbsp;&nbsp;$name4
<input name=\"ud_audiofile4\" type=\"file\" id=\"ud_audiofile4\">
</td>";
echo "</tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"888000000\">
UPDATE TRACK 6 - &nbsp;&nbsp;$name5
<input name=\"ud_audiofile5\" type=\"file\" id=\"ud_audiofile5\">
</td>";
echo "</tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"8888000000\">
UPDATE TRACK 7 - &nbsp;&nbsp;$name6
<input name=\"ud_audiofile6\" type=\"file\" id=\"ud_audiofile6\">
</td>";
echo "</tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"8888000000\">
UPDATE TRACK 8 - &nbsp;&nbsp;$name7
<input name=\"ud_audiofile7\" type=\"file\" id=\"ud_audiofile7\">
</td>";
echo "</tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"8888000000\">
UPDATE TRACK 9 - &nbsp;&nbsp;$name8
<input name=\"ud_audiofile8\" type=\"file\" id=\"ud_audiofile8\">
</td>";
echo "</tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"8888000000\">
UPDATE TRACK 10 - &nbsp;&nbsp;$name9
<input name=\"ud_audiofile9\" type=\"file\" id=\"ud_audiofile9\">
</td>";
echo "</tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"8888000000\">
UPDATE TRACK 11 - $name10
<input name=\"ud_audiofile10\" type=\"file\" id=\"ud_audiofile10\">
</td>";
echo "</tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"8888000000\">
UPDATE TRACK 12 - $name11
<input name=\"ud_audiofile11\" type=\"file\" id=\"ud_audiofile11\">
</td>";
echo "</tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"8888000000\">
UPDATE TRACK 13 - $name12
<input name=\"ud_audiofile12\" type=\"file\" id=\"ud_audiofile12\">
</td>";
echo "</tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"8888000000\">
UPDATE TRACK 14 - $name13
<input name=\"ud_audiofile13\" type=\"file\" id=\"ud_audiofile13\">
</td>";
echo "</tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"8888000000\">
UPDATE TRACK 15 - $name14
<input name=\"ud_audiofile14\" type=\"file\" id=\"ud_audiofile14\">
</td>";
echo "</tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"8888000000\">
UPDATE TRACK 16 - $name15
<input name=\"ud_audiofile15\" type=\"file\" id=\"ud_audiofile15\">
</td>";
echo "</tr>";
echo "<td width=646>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"8888000000\">
UPDATE TRACK 17 - $name16
<input name=\"ud_audiofile16\" type=\"file\" id=\"ud_audiofile16\">
</td>";
echo "</tr>";
echo "<td width=246>
<INPUT TYPE=text NAME=username value=\"$session->username\" SIZE=20>
</td>";
echo "</tr>";
echo "<tr>";
echo "<td width=80><input name=\"upload\" type=\"submit\" class=\"box\" id=\"upload\" value=\"Upload\"></td>";
echo "</tr>";
echo "</table>";
echo "</form>";
?>
[/PHP]

Any Idea's

[ronverdonk]

This is a nice long post, but at bthis moment in time all this code is not quite necessary. As I understand it, the basic question is that you cannot do the db update. So first thing to when a MyQL statement does not work, is to get the MySQL error message displayed and work from that on.
So change your MySQL statement into:
[php]mysql_query($query) or die('Error, query failed: '. mysql_error()); [/php]
and see what error it throws.

Ronald :cool:

[underground]

I will try that and get back to you in few moments, thanks

[underground]

This is following error I received when attemping to update curent file store in a specific row....

Error, query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' size, type, content, name1, size1, type1, audiofile1, name2, size2, type2, audi' at line 1..

[ronverdonk]

This is following error I received when attemping to update curent file store in a specific row....

Error, query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' size, type, content, name1, size1, type1, audiofile1, name2, size2, type2, audi' at line 1..

You have a big error minn your UPDATE statement. The syntax of the UPDATE command is

$query = "UPDATE pix SET field1='$var1', field2='$var2', ..etc.... WHERE where_clause";

See the UPDATE syntax for further details.

Ronald :cool:

[underground]

I made the corrections and it works perfectly! Thanks for the mysql query to display the error. I will keep it for future use. Its make finding the problem easier..I made changes to query and the rest is history.

Thanks again Ronald, I hope you noticed Php wrapping around the html. I learned it after my first post per your advice..I seem to be getting the hang of it..


latter.

[sureshgv]

I have been working around this for sometime. I can update text feilds but have ran into a problem with this script from a previous post. I'm trying to update data store in mysql see below example..

See second post for upload script.. Post too long!

u see this is very simple thing that

[sureshgv]

this is to be done like

[sureshgv]

this is to be done like

dont worry about thiss

[sureshgv]

I have been working around this for sometime. I can update text feilds but have ran into a problem with this script from a previous post. I'm trying to update data store in mysql see below example..

See second post for upload script.. Post too long!

This sis very simpole

[sureshgv]

rhtrhty htyhty hthhy

[ronverdonk]

I made the corrections and it works perfectly! Thanks for the mysql query to display the error. I will keep it for future use. Its make finding the problem easier..I made changes to query and the rest is history.

Thanks again Ronald, I hope you noticed Php wrapping around the html. I learned it after my first post per your advice..I seem to be getting the hang of it..

latter.

It is always important to display all errors and halt your processing once an error occurred and is displayed. So I advise you to do this with ALL mysql_statements, like[php]
$con=mysql_connect(host, uid, psw)
or die ("Server connect error : ".mysql_error());
$db=mysql_select_db(db, con)
or die ("DB connect error : ".mysql_error);
Etcetera for all mysql_xxxx statements[/php]
Ronald :cool: