update or insert commands

[Anon]

Hi,

I am using mysql_1.3.19 and PHP4. When I tried to update database using following codes

// Connect to the Database

$link = mysql_pconnect("$hostName", $userName, $password) or die
("Couldnt connect database");

// Select the Database
mysql_select_db("$databaseName", $link) or die ("Couldn't find database");

// Execute the Statement

$sql = "UPDATE Feature SET Name1='$Name1', Name2='$Name2 ', Name3 ='$Name3 ' where ID='$ID';

$result = safe_query ($sql, $link);

but those columns couldn't be updated when I went back database to check. However, I don't have any problems to select any data from that database.

Do you have any suggestions?

[Anon]

Just a newbie, but I'd say check the permissions of that user on the dbase you're trying to write to... Like i know in mysql you could apply it in db mysql and table dbase or something.. and select * in that table to see what rights the use has with that db

HP wrote:

Hi,

I am using mysql_1.3.19 and PHP4. When I tried to update database using following codes

// Connect to the Database

$link = mysql_pconnect("$hostName", $userName, $password) or die
("Couldnt connect database");

// Select the Database
mysql_select_db("$databaseName", $link) or die ("Couldn't find database");

// Execute the Statement

$sql = "UPDATE Feature SET Name1='$Name1', Name2='$Name2 ', Name3 ='$Name3 ' where ID='$ID';

$result = safe_query ($sql, $link);

but those columns couldn't be updated when I went back database to check. However, I don't have any problems to select any data from that database.

Do you have any suggestions?

[[deleted]]

I have a suggestion: start using error checking, and stop using the 'or die'

try this:

if ($result = mysql_query($sql,$link))
{
echo "it worked";
}
else
{
echo mysql_error();
};

[jhonrputra]

Hi.....

Please note this:
Anything that you want to do on your table, just give the right sql statement.

On php, updating, inserting etc on a table is very easy.

How if you try this:

$koneksi=mysql_connect("localhost","username","password");

$eksekusi=mysql_db_query("yourdatasource","UPDATE Feature SET Name1='$Name1', Name2='$Name2 ', Name3 ='$Name3 ' where ID='$ID'",$koneksi);

mysql_close($koneksi);

Note: do not give any statement to show the contents of the table directly after $eksekusi=mysql_db_query() unless you commit it first! OK!

Now see your table, something change?

[Anon]

Hi,

Thanks for your all suggestions. I did try like

include ("home.php");
include ("db.php");

// Connect to the Database

$link = mysql_pconnect("$hostName", $userName, $password) or die
("Couldnt connect database");

// Execute the Statement

$sql = mysql_db_query("$databaseName", "UPDATE Feature SET
Name1='$Name1', Name2='$Name2 ', Name3 ='$Name3 ' where ID='$ID' ", $link);

mysql_close($link);

if ($sql) {
echo " updated and edited";
}
else {
echo mysql_error ();
}

?>

I got " updated and edited" results, Not errors. but I couldn't find any updated data in feature table.

My db.php like

<?php
$hostName="localhost";
$userName="test1";
$password="test1";
$databaseName="searchdb";
?>

user "test1" is granted all privileges for all database. It is located in user table.

I just don't get where it is problem.

[Anon]

What's the "safe_query"?
Is it your own function?

Normally, "mysql_query" function is used for this kind case.

[Anon]

safe_query is PHP4's one of functions. It works good.