Posts Tagged php-coder

php mysql_change_user function

mysql_change_user

php mysql_change_user function

<?php
$old_user = ‘username’;
$new_user = ‘newusername’;
$link = mysql_connect (‘hostname’,$old_user,’password’);

if (mysql_change_user ($old_user, $new_user)) {
echo “User changed to <b>$new_user</b>.”;
} else {
echo “User could not be changed to <b>$new_user</b>.”;
}
?>

Advertisements

Comments (1)

php mysql_affected_rows function

mysql_affected_rows

php mysql_affected_rows function

mysql_affected_rows Get the number of affected rows by the last INSERT, UPDATE, REPLACE or DELETE query.

<?php
$link = mysql_connect(‘localhost’, ‘username’, ‘password’);
if (!$link) {
die(‘Could not connect: ‘ . mysql_error());
}
mysql_select_db(‘mydb’);

// This will return the number of records deleted
mysql_query(‘DELETE FROM table WHERE fldid < 100’);
print “Records Deleted By Above Query: “. mysql_affected_rows();
// Output will be like this : Records Deleted By Above Query: 10
?>

Comments (2)