how to add data in mysql thru php

[tabatsoy]

Greetings earthlings!

  how can i add my data in sql thru php?

 

    example i have a table scores

        math = 3, english = 2, logic = 5, total = null

    how can i add them thru php

 

[xtrafile]

1. Connect to your DB

 

mysql_connect("localhost", "admin", "admin") or die(mysql_error());

mysql_select_db("test") or die(mysql_error());

 

2. Insert that information into the DB

 

mysql_query("INSERT INTO table

(math,english,logic,total) VALUES('3', '2','5',NULL ) ")

or die(mysql_error()); 

 

 

[ansarka]

write the sql code and run the code

 

<?php

// we connect to example.com and port 3307

$link = mysql_connect('host', 'mysql_user', 'mysql_password');

if (!$link) {

    die('Could not connect: ' . mysql_error());

}

mysql_select_db($dbname);

$insert_query="insert into tablename values('1','2','3')";

$result=mysql_query($insert_query);

 

?>

[tabatsoy]

thanks for the early reply but my problem is how to add the scores and total it in php

  math = 3, english = 2, logic = 3, totalscore null

  how can i add those 3 columns so i can get their sum in php

  example is totalscore is 8

[ansarka]

<? 
.........
$total=$row_result['math']+$row_result['english']+$row_result['logic'];

?>

[tabatsoy]

do i still need to run the connection?

please help i'm confused ???

[tabatsoy]

<?
	$result = mysql_query("select * from examinee
							where firstname = '".$_SESSION['bago']."'
							and lastname = '".$_SESSION['bago2']."'");
	$total = $row_result['math'] + $row_result['english'] + $row_result['logic'];
	echo $total;
?>

 

is this correct?

[ansarka]

complete code

 

<?php

$link = mysql_connect('host', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
mysql_select_db($dbname);
$result = mysql_query("select * from examinee
							where firstname = '".$_SESSION['bago']."'
							and lastname = '".$_SESSION['bago2']."'");
while ($row_result = mysql_fetch_array($result)) {
    $total = $row_result['math'] + $row_result['english'] + $row_result['logic'];
	echo $total;
}
?>

 

[tabatsoy]

thanks for the help

it worked.

 

i love this site.