₦airaland Forum

Note: Using mysql is deliberate but will convert it to pdo.

Am trying to use INSERT statement in a function and send data as parameters which should be inserted into the database.

I ran the codes below but it failed ....

is it a correct way of running such?

summary($no112m,$name112m,$remark112m);

function summary($no,$name,$remark)
{
$query2 = "insert INTO summary
(
sn,
no,
name,
grade
) ".
"VALUES
( '',
'$no',
'$name',
'$remark'

)";
begin();// transaction begins
$result = mysql_query($query2);
if($result){
commit();
// transaction rolls back
echo "COMMITTED 112";

}else
{
rollback();
echo "Transacton failed 112";
exit;

}

}

uvalued:
Note: Using mysql is deliberate but will convert it to pdo.

Am trying to use INSERT statement in a function and send data as parameters which should be inserted into the database.

I ran the codes below but it failed ....

is it a correct way of running such?

1) You should run a function after declaration...
2) It seems you have syntax errors in your Insert statement,
3) Mysql is deprecated, use mysqli instead.
4) exit is an inbuilt function, so you should use exit() instead.

The logic is OK, take a look at code igniter.. A PHP framework that eases development

Well, I didn't really take time out to study the correctness of your code, but I can tell you what you have done is logically correct.
Also, I'm assuming in your proper code, you will declare the function before invoking it.

DanielTheGeek:
1) You should run a function after declaration...
2) It seems you have syntax errors in your Insert statement,
3) Mysql is deprecated, use mysqli instead.
4) exit is an inbuilt function, so you should use exit() instead.

The logic is OK, take a look at code igniter.. A PHP framework that eases development

thanks a lot... i got it working...on cogeigniter, i have this laziness to learn becos of ? i just lay my finger on it solidly...in your opinion what is that simple thread that makes it thick..a little push may give me some good light

Codenister:
Well, I didn't really take time out to study the correctness of your code, but I can tell you what you have done is logically correct.
Also, I'm assuming in your proper code, you will declare the function before invoking it.

thanks got it working

Codenister:
Well, I didn't really take time out to study the correctness of your code, but I can tell you what you have done is logically correct.
Also, I'm assuming in your proper code, you will declare the function before invoking it.

talking about functions an invocation..pls can i call functions directly 4rm my my operating system?