| | [Tanya | Looping dan Insert ]
Saya punya script PHP seperti ini :
<?php
//include('../../config/connect.php');
$connect = mysqli_connect('localhost', 'a', 'a', 'a');
$query="CALL st_dsml('01')";
$result1 = mysqli_query($connect, $query) or die("SQL Error 121: " . mysql_error());
while ($rows = mysqli_fetch_array($result1, MYSQLI_ASSOC))
{
$jnopel=$rows['nopel'];
$jnama=$rows['nama'];
$jalamat=$rows['alamat'];
$jwilayah=$rows['Wilayah'];
$jawal=$rows['awal'];
$jakhir=$rows['akhir'];
$jtarif=$rows['tarif_cd'];
$mysqli = new mysqli('localhost', 'a', 'a', 'a');
$query = "INSERT INTO tr_temp_dsml SET nopel='$jnopel', nama='$jnama', alamat='$jalamat', wilayah='$jwilayah', awal='$awal', akhir='$akhir', bad='0'";
$results = $connect->query($query);
}
mysqli_close($connect);
?>
Pertanyaan :
Data sudah bisa masuk tapi kenapa terjadi error ? |
Tidak ada komentar:
Posting Komentar