Re: College of COMPUTER STUDIES (INFORMATION TECHNOLOGY students,ACE,CS,etc) welcome
Guys , pa help naman sa php codes ko.. ano ba mali dito,
database name = school
table name = activity
primary key = Lname
tables row = Fname , MI , Lname
<html>
<head> </head>
<body>
<?php
//open connection to MySQL
//EDIT
$connection = mysql_connect('localhost','root','');
if($connection)
{
echo 'Connect!';
}
else
{
echo 'Could not connect!';
}
mysql_select_db('school') or die('Unable to select database!');
?>
<br/><form method=get>
<input type=submit name=action value='Edit Record'> </form>
<?php
if($_GET['action']== "Edit Record"){
print "Edit Record";
$result=mysql_query("select*from activity");
$rows=mysql_num_rows($result);
if($rows!=0){
print"<form method =get>";
print"Select employee record to edit:";
print"<select name= Lname>";
for($i=0; $i<$rows; $i++)
{
$row = mysql_fetch_row ($result);
print"<option value='$row[2]'>$row[0] $row[1] $row[2]";
}
print"</select>";
print"<input type=submit name= action value= Edit>";
print"</form>";
}
else
{
print "No records found!";
}
mysql_free_result($result);
}
if($_GET['action'] == "Edit")
{
$result = mysql_query(" select*from activity WHERE Lname='$_GET[Lname]'");
$row = mysql_fetch_row($result);
print 'Edit Record';
print "<form method=get>
<table>
<tr> <td> First Name: </td>
<td><input type=text name=Fname value=$row[0]>
</td></tr>
<tr> <td> Middle Initial:</td>
<td><input type=text name=MI value=$row[1]>
</td></tr>
<tr> <td> Last Name:</td>
<td><input type=text name=Lname value=$row[2]>
</td></tr>
<tr><td><input type = submit name = action value = Update > </td></tr>
</table>
</form>";
}
if($_GET['action']== Update)
{
$result=mysql_query("UPDATE 'activity' SET
Fname = '$_GET[Fname]', MI = '$_GET [MI]', Lname = '$_GET [Lname]',
WHERE Lname ='$_GET [Lname]'");
print"Record of Employee $_GET[Lname] successfully updated!";
//print"<form method= get>
//<input type=submit name=action value='Update'> </form> ";
}
{
mysql_close($connection);
}
//{
//header('locationsecond.php');
//}
?>
</body>
</html>
thanks
thanks in advance
