Viewing file:  user_name_update.php (764 B) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
$con = mysqli_connect("localhost","scampususr","Neontetr@2021#","srishticampus");
if(!$con)
{
die("sql connection error");
}
$sql="select * from tb_sc_db";
$result=$con->query($sql);
$count=$result->num_rows;
while($row=$result->fetch_assoc())
{
print_r($row);echo "<br>";
//echo $row['user_id'];
$que="update user_details set name='".$row['name']."' where phone='".$row['contact_number1']."'";
echo $que;
echo "<br>";
$r=$con->query($que);
print_r($r);
echo "<br><br><br>";
}
/*$result=$con->query($sql);
$last_id = $con->insert_id;
$que="update user_details set name='$studName' ,email='$email',phone='$mobile',`public_profile_val`='$public_profile_val' where user_id='$u_id'";
$r=$con->query($que);*/
?>
|