Hi,
I am new i made my first porg. in php so i wnat u help .
my database name is work
data is table include id , name ,email ,work
i made add.php page to add data to database .
i made insert.php to give me Successful messege when data insert to database.
i made view.php to see the recrods.
my propblem is :
in view.php page i show only three fileds id , name , email
i made link to viewall fileds for record in viewall.php
becaus in viewall.php page i wnat see all fields for that record and link to edit (update) and link to delete .
finaly i do not know how to make link between view.php page and viewall.php
with id .
i attch my file please help me .
1--------------------add.php
<html dir="rtl">
<head>
<title>MY FIRST STEP</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
</head>
<table width="400" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td><div align="center"><strong><span lang="ar-sa">MY FIRST STEP</span></strong></div></td>
</tr>
</table>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<form id="form1" name="form1" method="POST" action="insert.php">
<td>
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td width="117">
<p align="center"><span lang="ar-sa">name </span></td>
<td width="14">:</td>
<td width="357"><input name="name" type="text" id="name" size="40" /></td>
</tr>
<tr>
<td>
<p align="center"><span lang="ar-sa">email</span></td>
<td>:</td>
<td><input name="email" type="text" id="email" size="40" /></td>
</tr>
<tr>
<td>
<p align="center"><span lang="ar-sa">work</span></td>
<td>:</td>
<td><input name="work" type="text" id="work" size="40" /></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="add" />
<input type="reset" name="Submit2" value="delete" /></td>
</tr>
</table>
</td>
</form>
</tr>
</table>
</html>
2--------------------insert.php
<?php
$host="localhost";
$username="ali";
$password="123";
$db_name="work";
$tbl_name="data";
mysql_connect("$host", "$username", "$password")or die("cannot connect server ");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="INSERT INTO $tbl_name(name, email ,work)VALUES('$name', '$email','$work')";
$result=mysql_query($sql);
//check if query successful
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='view.php'> view </a>";
}
else {
echo "ERROR";
}
mysql_close();
?>
3--------------------view.php
<html dir="rtl">
<tr>
<td><div align="center"><strong> <a href="add.php">add new data</a>
</strong></div></td>
</tr>
</table>
<br>
<?php
$host="localhost";
$username="ali";
$password="123";
$db_name="work";
$tbl_name="data";
mysql_connect("$host", "$username", "$password")or die("cannot connect server ");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name ";
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){
?>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td><table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td> </td>
<td>:</td>
<td><? echo $rows['id']; ?></td>
</tr>
<tr>
<td width="117" align="center">name</td>
<td width="14">:</td>
<td width="357"><? echo $rows['name']; ?></td>
</tr>
<tr>
<td align="center">email</td>
<td>:</td>
<td><? echo $rows['email']; ?></td>
</tr>
<tr>
<td align="center" colspan="3"><a <a href="viewall.php?id=<?php echo $rows['id']; ?>">viewall</a></td>
</tr>
</table></td>
</tr>
</table>
<BR>
<?
}
mysql_close();
?>
4--------------------viewall.php
<html dir="rtl">
<tr>
<td><div align="center"><strong> <a href="add.php">add new data</a>
</strong></div></td>
</tr>
</table>
<br>
<?php
$host="localhost";
$username="ali";
$password="123";
$db_name="work";
$tbl_name="data";
mysql_connect("$host", "$username", "$password")or die("cannot connect server ");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name ";
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){
?>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td><table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td> </td>
<td>:</td>
<td><? echo $rows['id']; ?></td>
</tr>
<tr>
<td width="117" align="center">name</td>
<td width="14">:</td>
<td width="357"><? echo $rows['name']; ?></td>
</tr>
<tr>
<td align="center">email</td>
<td>:</td>
<td><? echo $rows['email']; ?></td>
</tr>
<tr>
<td align="center">work</td>
<td>:</td>
<td><? echo $rows['work']; ?></td>
</tr>
</table></td>
</tr>
</table>
<BR>
<?
}
mysql_close();
?>
