Problem to update table in mysql using php

11 years ago By kahja.jab

Below is my code from this code i am able to update only that particular row now i want to update some bunch of rows with different content so please edit this code sir This is my table structure: +----+---------+ | id | content | +----+---------+ | 2 | abc | can any one help me please +----+---------+ | 14 | def | +----+---------+

<?php
$hostname = "localhost";
$username = "";
$password = "";
$database = "";
 
// Connect to the database
mysql_connect($hostname, $username, $password) OR DIE("Unable to connect");
mysql_select_db("$database") or die("Unable to select database");
 
if (isset($_POST['ud_date'])) {
$query = sprintf("UPDATE test_mysql SET content='%s' WHERE id=%d",
mysql_real_escape_string($_POST['ud_date']),
2);
if (mysql_query($query)) {
echo 'update query succeeded';
} else {
echo 'update query failed';
}
} else {
echo 'please submit the form';
}

Add new comment

2 views