Update Profile ~please help~

[tsuoshiro]

~sorry for reposting~ ~clear view of codes~

 

I have a problem in update profile. Whenever i update my first name and last name it is updatable, and when i add the middle name in the code the middle name doesnt search and updates the file. is it in the database or my code..can my codes can update only 2 ~the last name and first name~ please tell..thx in advance ^^

 

my first code for first name and last name ~working code~

 

 

<?php

class Database
{
var $config=Array();
var $link="";

function getConfig()
{
	$config['dbhost']="localhost";
	$config['dbuser']="root";
	$config['dbpass']="change";
	$config['dbname']="studentsprofile";

	return $config;
}

function openDB()
{

	$mydb=Database::getConfig();
	// Connect to the database
	$link = mysql_connect($mydb['dbhost'], $mydb['dbuser'], $mydb['dbpass'])
		or die("Unable to connect to database");
	mysql_select_db($mydb['dbname'],$link);

	return ($link);	
}

function setQuery($sql)
{
	return mysql_query($sql);
}

}

function showSearch()
{

echo ("<form name='frm_search' action='updateupdatelive.php' method='post'>");
echo ("<input type='hidden' name='action' value='detail'>");
echo ("Student Number : <input type='text' name='Student_Number'><br>");
echo ("<input type='submit' name='f_submit' value='Search'>");
echo ("<input type='reset' name='f_submit' value='Reset'>");
echo ("</form>");
}

function showRecord()
{

if (!$link=Database::openDB()){
	exit("Unable to connect to the database");
}

$sql="select * from tblstudentsinformation where Student_Number='".$_POST['Student_Number']."'";
$result=Database::setQuery($sql);

$row=mysql_fetch_array($result);

if (mysql_affected_rows()>0){

	echo ("<form name='frm_details' action='updateupdatelive.php' method='post'>");
	echo ("<input type='hidden' name='action' value='update'>");
	echo ("Student Number  <input type='text'   name='Student_Number' readonly value='".$row["Student_Number"]."'><br>");
	echo ("Last Name :   <input type='text'   name='Last_Name' value='".$row["Last_Name"]."'><br>");
	echo ("First Name :  <input type='text'   name='First_Name' value='".$row["First_Name"]."'><br>");
	echo ("<input type='submit' name='f_submit' value='Update'>");
	echo ("</form>");

}else{

	echo ("No record found");

}

mysql_close($link);

}

function updateRecord()
{
$Last_Name=$_POST['Last_Name'];
$First_Name=$_POST['First_Name'];
$Student_Number=$_POST['Student_Number'];

if (!$link=Database::openDB()){
	exit("Unable to connect to the database");
}

$sql="update tblstudentsinformation set " .
		" Last_Name = '$Last_Name'," .
		" First_Name = '$First_Name' " .
		" where Student_Number='$Student_Number'";
$result=Database::setQuery($sql);

if (mysql_affected_rows()>0){	
	echo "Record is updated";
}else {
	echo ("Unable to update record");
}

mysql_close($link);

unset($_POST);

?>
<script language="javascript"  type="text/javascript">
<!--
alert('Press a key to continue');	
window.location = "./updateupdatelive.php"
-->
</script>

    <?php



}

if (!$_POST){
showSearch();
} elseif ($_POST['action']=='detail'){
showRecord();
} elseif ($_POST['action']=='update'){
updateRecord();
}	

?>

  

 

 

my code w/middle name  ~no search found <---have problems whenever im adding middle name~

 

 

<?php

class Database
{
var $config=Array();
var $link="";

function getConfig()
{
	$config['dbhost']="localhost";
	$config['dbuser']="root";
	$config['dbpass']="change";
	$config['dbname']="studentsprofile";

	return $config;
}

function openDB()
{

	$mydb=Database::getConfig();
	// Connect to the database
	$link = mysql_connect($mydb['dbhost'], $mydb['dbuser'], $mydb['dbpass'])
		or die("Unable to connect to database");
	mysql_select_db($mydb['dbname'],$link);

	return ($link);	
}

function setQuery($sql)
{
	return mysql_query($sql);
}

}

function showSearch()
{

echo ("<form name='frm_search' action='updatedddddddddddd.php' method='post'>");
echo ("<input type='hidden' name='action' value='detail'>");
echo ("Student Number : <input type='text' name='Student_Number'><br>");
echo ("<input type='submit' name='f_submit' value='Search'>");
echo ("<input type='reset' name='f_submit' value='Reset'>");
echo ("</form>");
}

function showRecord()
{

if (!$link=Database::openDB()){
	exit("Unable to connect to the database");
}

$sql="select * from tblstudentsinformation where Student_Number='".$_POST['Student_Number']."'";
$result=Database::setQuery($sql);

$row=mysql_fetch_array($result);

if (mysql_affected_rows()>2){

	echo ("<form name='frm_details' action='updatedddddddddddd.php' method='post'>");
	echo ("<input type='hidden' name='action' value='update'>");
	echo ("Student Number  <input type='text'   name='Student_Number' readonly value='".$row["Student_Number"]."'><br>");
	echo ("Last Name :   <input type='text'   name='Last_Name' value='".$row["Last_Name"]."'><br>");
	echo ("Middle Name :  <input type='text'   name='Middle_Name' value='".$row["Middle_Name"]."'><br>");
	echo ("First Name :  <input type='text'   name='First_Name' value='".$row["First_Name"]."'><br>");
	echo ("<input type='submit' name='f_submit' value='Update'>");
	echo ("</form>");

}else{

	echo ("No record found");

}

mysql_close($link);

}

function updateRecord()
{
$Last_Name=$_POST['Last_Name'];
$Middle_Name=$_POST['Middle_Name'];
$First_Name=$_POST['First_Name'];
$Student_Number=$_POST['Student_Number'];

if (!$link=Database::openDB()){
	exit("Unable to connect to the database");
}

$sql="update tblstudentsinformation set " .
		" Last_Name = '$Last_Name'," .
		" Middle_Name = '$Middle_Name' " .
		" First_Name = '$First_Name' " .
		" where Student_Number='$Student_Number'";
$result=Database::setQuery($sql);

if (mysql_affected_rows()>2){	
	echo "Record is updated";
}else {
	echo ("Unable to update record");
}

mysql_close($link);

unset($_POST);

?>
<script language="javascript"  type="text/javascript">
<!--
alert('Press a key to continue');	
window.location = "./updatedddddddddddd.php"
-->
</script>

    <?php



}

if (!$_POST){
showSearch();
} elseif ($_POST['action']=='detail'){
showRecord();
} elseif ($_POST['action']=='update'){
updateRecord();
}	

?>

 

 

hope u can help me.... thx again ^^