php help

[sudu hawa]

mata dena ganna one register wela login unama register wena kota dipu details edit karaganna php code eka one plz help me

 

[mcwolfe]

අනේ හාවෝ මමනම් දන්නැතෝ.......

 

[mcwolfe]

http://forums.digitalpoint.com/showthread.php?t=1255131
http://www.dreamincode.net/forums/topic/98590-edit-profile-details-in-php/

 

[Megatrone]

eaka machan query eken karanne. mulinma database eken eata adala record eka variable walata ganna (select * from table_name where primary_key_colum = key_). eata passe eka edit kalata passe update query eka run karanna.
UPDATE table_name
SET column1=value, column2=value2,...
primary_key_colum = key_

 

[sudu hawa]

eaka machan query eken karanne. mulinma database eken eata adala record eka variable walata ganna (select * from table_name where primary_key_colum = key_). eata passe eka edit kalata passe update query eka run karanna.
UPDATE table_name
SET column1=value, column2=value2,...
primary_key_colum = key_

plz machan mata sampurna code eka awanavada

 

[Metalingus]

bumpiyak dennam

 

[amila.ela]

suddaa help ekak dei kattiya

 

[Rangau2]

<?php

// Edit Account Form
if(isset($_POST['edit_submit'])) {

require("db_connect.inc.php");

$name = mysql_real_escape_string(trim($_POST['name']));
$company = mysql_real_escape_string(trim($_POST['company']));
$number = trim($_POST['number']);
$location = mysql_real_escape_string(trim($_POST['location']));

$edit_error = array();
$edit_error_msg = "";

if(empty($name)) {
$edit_error['name'] = "Plese enter your full name.";

} else if(!eregi('^[[:alpha:] \'\-]+$', $name)) {
$edit_error['name'] = "Please use valid characters in your full name.";
}

if(!empty($company)) {
if(!eregi('^[[:alpha:] \'\.\,\-]+$', $company)){
$edit_error['company'] = "Please use valid characters in the name of your company.";
}
}

if(empty($number)) {
$edit_error['number'] = "Please enter your phone number.";

} else if(!eregi('^[0-9]{3}-[0-9]{3}-[0-9]{4}$', $number)) {
$edit_error['number'] = "Please use valid characters for your phone number.";
}

if(!empty($location)) {
if(!eregi('^[[:alpha:] \,\-]+$', $location)) {
$edit_error['location'] = "Please use valid characters in the location name.";
}
}

if(empty($edit_error)) {
$change_query = 'UPDATE users SET name = "' . $name . '" WHERE id = "' . $_SESSION['id'] . '"';
$change_result = mysql_query($change_query) or die('error:' . mysql_error());

$change_query2 = 'UPDATE users SET company = "' . $company . '" WHERE id = "' . $_SESSION['id'] . '"';
$change_result2 = mysql_query($change_query2) or die('error:' . mysql_error());

$change_query3 = 'UPDATE users SET number = "' . $number . '" WHERE id = "' . $_SESSION['id'] . '"';
$change_result3 = mysql_query($change_query3) or die('error:' . mysql_error());

$change_query4 = 'UPDATE users SET location = "' . $location . '" WHERE id = "' . $_SESSION['id'] . '"';
$change_result4 = mysql_query($change_query4) or die('error:' . mysql_error());

if(mysql_affected_rows() == 1) {
$_SESSION['name'] = $name;
$_SESSION['company'] = $company;
$_SESSION['number'] = $number;
$_SESSION['location'] = $location;
}
} else {
$edit_error_msg = "<ul>\n";
foreach($edit_error as $msg) {
$edit_error_msg .= "<li>$msg</li>\n";
}
$edit_error_msg .= "</ul>\n";
}
}

?>
[/QUOT

 

[madhuka47]

http://www.developphp.com/view.php?tid=142

 

[Mal Baba]

BUMP

 

[sudu hawa]

mata udaww karanna

 

[sudu hawa]

anne help ekak denna

 

[sudu hawa]

anee mata help ekak diyaw