How to insert into table with PHP value.PHP Mysql

Question

In my php code, two ways,

('#201707',$cont_array[$i],'N') or ('#201707','$cont_array[$i]','N') failed during insert into table hpc_review

$transmit_next="<input  value='allDel' type='button'><br>John<br>snow<br>stack<br>";
$cont_array = explode("<br>", $transmit_next);
for($i=1;$i<count($cont_array);$i++)
{
    $query="insert into hpc_review (sysnum,handler,stat) values ('#201707',$cont_array[$i],'N');";
    $stat = $conn->query($query);
}

I made mistake. In hpc_review,handler is int ,but cont_array[$i] is var — john
– john, Commented Jul 24, 2017 at 9:03

Dave94 · Accepted Answer · 2017-07-24 08:24:51Z

2

The solution is:

  $query="insert into hpc_review (sysnum,handler,stat) values ('#201707','".$cont_array[$i]."','N');";

answered Jul 24, 2017 at 8:24

Dave94

711 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

john Over a year ago

I made mistake. In hpc_review,handler is int ,but cont_array[$i] is var .

Usagi Miyamoto · Accepted Answer · 2017-07-24 08:27:13Z

1

Try something like this:

$query="insert into hpc_review (sysnum,handler,stat) values ('#201707','" . $cont_array[$i] . "','N');";

But should use MySQLi driver and prepared statements, see: http://php.net/manual/en/mysqli.quickstart.prepared-statements.php

answered Jul 24, 2017 at 8:27

Usagi Miyamoto

6,3471 gold badge21 silver badges37 bronze badges

Comments

Zeljka · Accepted Answer · 2017-07-24 08:30:02Z

0

IF $cont_array[$i] is a string :

 $query="insert into hpc_review (sysnum,handler,stat) values ('#201707','{$cont_array[$i]}','N');";

if $cont_array[$i] is integer like ID:

 $query="insert into hpc_review (sysnum,handler,stat) values ('#201707',{$cont_array[$i]},'N');";

answered Jul 24, 2017 at 8:30

Zeljka

3761 silver badge10 bronze badges

Collectives™ on Stack Overflow

How to insert into table with PHP value.PHP Mysql

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related