New on PHP and MYsql need tip.

[Anon]

Hi ,

I'm very new under PHP and Mysql communications , then i need a help here people =).

Can someone just show-me how make a simple php script to insert into a mysql table informations, i try find some manual but it's has something that make sense. =(

I'm trying this :

my $SQL= "INSERT INTO $table (id, dater, code, ip, msg) VALUES (0, 12/02/76, abc123, INET_ATON, 192.168, hello);";

Can someone tell if it's correct ?

Axley what i need it's read a log file using a shell bash then i take just the informations that need and then using the php insert under the mysql.

I think that perl will be more easy, but i like php =)

Axley how can i run a php script over console ???

Thanks.

[scoppc]

for string use ' to insert the value to MySQL database. So, it should be:

$SQL= "INSERT INTO $table (id, dater, code, ip, msg) VALUES (0, '12/02/76', 'abc123', 'INET_ATON', 192.168, 'hello')";

Do NOT use this ";" symbol right after the closing bracket.
Execute the SQL statement by using:
mysql_query($SQL);