Welcome Guest, Not a member yet? Register   Sign In
bug for multi insert for single mysql query
#7

this is not working.

i had clean install a new codeigniter environment.
Now fix the header error.
but still had mysql problem.
it affect the statement can't running.

http://non.asuscomm.com/stock/abc

====================================
public function test1()        <==== failed
{
$q =   "INSERT INTO test ( a, b, c ) VALUES ( '1', '2', '3' );

           INSERT INTO test ( a, b, c ) VALUES ( '4', '5', '6' ); ";

$this->db->query($q);
echo $q;
}


====================================
public function test2()       <==== successed
{
$q =   "INSERT INTO test ( a, b, c ) VALUES ( '1', '2', '3' ); ";

$this->db->query($q);
echo "<pre>".$q;

$q1 =  "INSERT INTO test ( a, b, c ) VALUES ( '4', '5', '6' ); ";

$this->db->query($q1);
echo $q1."</pre>";
}
Reply


Messages In This Thread
RE: bug for multi insert for single mysql query - by dj-x - 02-13-2019, 09:41 AM



Theme © iAndrew 2016 - Forum software by © MyBB