Seapoeschl

Thank you it was the problem with the "WHERE id" part the whole time. I just added a variable that holds the id value and it works now. Thanks everyone for the help

I created the SQL table with phpadmin and it works fine. I have another form that allows the user to add to the table and that works fine. It is when I try to have the ability to update the information that is giving me the issues.

I tried to debug with the php code error_reporting(E-ALL) but it is still not showing any errors and says it was successful without changing the information in the table. I looking in my sql to see if there was any errors or problems, but everything seemed fine.

Hello All, I have come across a problem when trying to update my table on MySql. I have set up an update form that allows the user to click on a link, then change the field(ex. Part#, Mold#, etc.), and then click submit to finalize the update. I have it set up so it will take you to a page telling you if there was any errors or if it was successful. Right now it says it is successful, but does not actually change the field on MySql. I can't seem to figure out why it won't work. Here is the code that I currently have. I think that my problem is somewhere in update_ac.php page. quality.php mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sql="SELECT * FROM $tbl_name"; $result=mysql_query($sql); ?> <tr> <table width='1020px' border='0' align='center' cellpadding='0' cellspacing='0' bgcolor='#ebebeb' > <tr bgcolor='#004c8a'> <td width='5%' align='center' height='10' ><p><font color='white'><strong><B>Part#</th> <td width='5%' align='center' height='10' ><p><font color='white'><strong><B>Mold#</th> <td width='5%' align='center' height='10' ><p><font color='white'><strong><B>Press#</th> <td width='5%' align='center' height='10' ><p><font color='white'><strong><B>Update</th> </tr> <?php while($rows=mysql_fetch_array($result)){ ?> <tr> <td width='5%' align='center' height='40' ><? echo $rows['Part']; ?></td> <td width='5%' align='center' height='40' ><? echo $rows['Mold']; ?></td> <td width='5%' align='center' height='40' ><? echo $rows['Press']; ?></td> <!--// link to update.php and send value of id--> <td align="center"><a href="update.php?id=<? echo $rows['ID']; ?>">update</a></td> </tr> <?php } ?> update.php mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // get value of id that sent from address bar $id=$_GET['id']; // Retrieve data from database $sql="SELECT * FROM $tbl_name WHERE id='$id'"; $result=mysql_query($sql); $rows=mysql_fetch_array($result); ?> <table width="400" border="0" cellspacing="1" cellpadding="0"> <tr> <form name="form1" method="post" action="update_ac.php"> <td> <table width="100%" border="0" cellspacing="1" cellpadding="0"> <tr> <td> </td> <td colspan="3"><strong>Update data in mysql</strong> </td> </tr> <tr> <td align="center"> </td> <td align="center"> </td> <td align="center"> </td> <td align="center"> </td> </tr> <tr> <td align="center"> </td> <td align="center"><strong>Part#</strong></td> <td align="center"><strong>Mold#</strong></td> <td align="center"><strong>Press#</strong></td> </tr> <tr> <td> </td> <td align="center"> <input name="part" type="text" id="name" value="<? echo $rows['Part']; ?>"> </td> <td align="center"> <input name="mold" type="text" id="lastname" value="<? echo $rows['Mold']; ?>" size="15"> </td> <td> <input name="press" type="text" id="email" value="<? echo $rows['Press']; ?>" size="15"> </td> </tr> <tr> <td> </td> <td> <input name="id" type="hidden" id="id" value="<? echo $rows['ID']; ?>"> </td> <td align="center"> <input type="submit" name="Submit" value="Submit"> </td> <td> </td> </tr> </table> </td> </form> </tr> </table> <?php // close connection mysql_close(); ?> update_ac.php $Part = $_POST['part']; $Mold = $_POST['mold']; $Press = $_POST['press']; // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // update data in mysql database $sql="UPDATE parts SET part='$Part', mold='$Mold', press='$Press' WHERE id='ID'"; $result=mysql_query($sql); // if successfully updated. if($result){ echo "Successful"; echo "<BR>"; echo "<a href='quality.php'>View result</a>"; } else { echo "ERROR"; } ?>

I was able to get it to work when the folder is in the root folder of the PHP file. I have the folder that stores the .PDF files located outside the root folder. I will display the names of the files, but when I link them with the same path it wont open those files. Here is my code and paths(I tried with both / and \). <?php //Open images directory $dir = dir("D:\TESTUP"); //List files in images directory while (($file = $dir->read()) !== false) { echo "filename: <a href='D:\TESTUP\$file'>$file</a><br />"; } $dir->close(); ?> PHP files are located in: D:\xampp\htdocs\sitea .PDF files are located in: D:\TESTUP

I tried this method, but I is not looking in the directory that it is pulling the file name from. The link is sending you to the same folder that the PHP file is stored, and looking for that file in there. I have these .PDF stored in a secure folder else where.

I think I am a little bit confused about what you mean by wrapping with an html link. I have done it before where I would just hard code each file to the page by doing something like this: <a href="pdf/Newsletter_Spring_2012.pdf" target="_blank">Pioneer Xpress Newsletter - Spring 2012</a> How would I type the code so each file will have a link without having to hand code a new link every time a file is added?

This is the current code that I have for the display page. <?php //Open images directory $dir = dir("TestUpload"); //List files in images directory while (($file = $dir->read()) !== true) { echo "filename: " . $file . "<br />"; } $dir->close(); ?> I attached a photo of what shows up in the browser. I want to be able to be able to click on the file name and have it open. Also have a search bar that will look through that Folder and find the file that matches the search.

Hello, I am currently working on an intranet website for the company I work at. I know more about Graphic Design then coding, so you can say I'm new to php code. The site is going to be used to let users log on and submit/view pdf files that are stored on the site. I have everything else created for the site(data form to build pdf, upload form, etc.), but I can't seem to figure out how to let the users view the files. I want to create a page where they can use a search bar to find the certain file that is stored in the files folder. I have tried using the dir() and scandir() commands but they just list the files and are not able to open them. I don't want to hard code the .PDF files on a page since they will be constantly changing and being added. Is there a way to have these files be displayed (like a link) and have a search bar to be able to search through them to find the correct one needed? Thanks, Seattle