اینم فایلی که داده رو میخونه اپدیت رو میزنی فیلدها رو میتونی تغییر بدی
<?php
$host="localhost"; // Host name
$username="****t"; // Mysql username
$password="****"; // Mysql password
$db_name="****"; // Database name
$tbl_name="pic"; // Table name
// 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");
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
?>
<style type="text/css">
<!--
.style1 {font-weight: bold}
-->
</style>
<div align="center" class="style1">
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<table width="400" border="1" cellspacing="0" cellpadding="3">
<tr>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta http-equiv="Content-Language" content="fa">
<td colspan="4"><strong>برای تغییر تصاویر داخل چت روم لطÙا لینک جدید تصاویر رو بعد از زدن دکمه اپدیت تغییر دهید </strong></td>
</tr>
<tr>
<td align="center"><strong>bgin</strong></td>
<td align="center"><strong>omomi</strong></td>
<td align="center"><strong>online</strong></td>
<td align="center"><strong>header</strong></td>
<td align="center"><strong>Update</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td><strong><? echo $rows['bgin']; ?></strong></td>
<td><strong><? echo $rows['omomi']; ?></strong></td>
<td><strong><? echo $rows['online']; ?></strong></td>
<td><strong><? echo $rows['header']; ?></strong></td>
// link to update.php and send value of id
<td align="center" bgcolor="#FF0000"><a href="update.php?id=<? echo $rows['id']; ?>"><strong>update</strong></a></td>
</tr>
<?php
}
?>
</table>
</td>
</tr>
</table>
<?php
mysql_close();
?>
فایل اپدیت دات پی اچ پی
<?php
$host="localhost"; // Host name
$username="****"; // Mysql username
$password="****"; // Mysql password
$db_name="****"; // Database name
$tbl_name="pic"; // Table name
// 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");
// 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);
?>
<div align="center">
<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>لینک مستقیم عکس ها رو وارد کنید و دکمه تایید ر و بزنید </strong></td>
</tr>
<tr>
<td align="center"> </td>
<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>bgin</strong></td>
<td align="center"><strong>omomi</strong></td>
<td align="center"><strong>online</strong></td>
<td align="center"><strong>header</strong></td>
</tr>
<tr>
<td> </td>
<td align="center"><input name="bgin" type="text" id="bgin" value="<? echo $rows['bgin']; ?>"></td>
<td align="center"><input name="omomi" type="text" id="omomi" value="<? echo $rows['omomi']; ?>" size="15"></td>
<td><input name="online" type="text" id="online" value="<? echo $rows['online']; ?>" size="15"></td>
<td><input name="header" type="text" id="header" value="<? echo $rows['header']; ?>" size="15"></td>
</tr>
<tr>
<td> </td>
<td><input name="id" type="hidden" id="id" value="<? echo $rows['id']; ?>"></td>
<td align="center"><input name="Submit" type="submit" id="Submit" value="تایید"></td>
<td> </td>
</tr>
</table>
</td>
</form>
</tr>
</table>
<?
// close connection
mysql_close();
?>
و
اینم فایل اپدیت ای سی دات پی اچ پی
<?php
$host="localhost"; // Host name
$username="****"; // Mysql username
$password="*****"; // Mysql password
$db_name="****"; // Database name
$tbl_name="pic"; // Table name
// 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");
// 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);
?>
<div align="center">
<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>لینک مستقیم عکس ها رو وارد کنید و دکمه تایید ر و بزنید </strong></td>
</tr>
<tr>
<td align="center"> </td>
<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>bgin</strong></td>
<td align="center"><strong>omomi</strong></td>
<td align="center"><strong>online</strong></td>
<td align="center"><strong>header</strong></td>
</tr>
<tr>
<td> </td>
<td align="center"><input name="bgin" type="text" id="bgin" value="<? echo $rows['bgin']; ?>"></td>
<td align="center"><input name="omomi" type="text" id="omomi" value="<? echo $rows['omomi']; ?>" size="15"></td>
<td><input name="online" type="text" id="online" value="<? echo $rows['online']; ?>" size="15"></td>
<td><input name="header" type="text" id="header" value="<? echo $rows['header']; ?>" size="15"></td>
</tr>
<tr>
<td> </td>
<td><input name="id" type="hidden" id="id" value="<? echo $rows['id']; ?>"></td>
<td align="center"><input name="Submit" type="submit" id="Submit" value="تایید"></td>
<td> </td>
</tr>
</table>
</td>
</form>
</tr>
</table>
<?
// close connection
mysql_close();
?>
ممنون میشیشم کمک کنید