Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $mysqli = new mysqli("localhost", "root", "", "test");
- /*
- koneksi jgn lupa diperbaiki ya..
- copas setelah dibawah ini.. tp atasnya jgn lupa ada mysqli
- */
- /* check connection */
- if (mysqli_connect_errno()) {
- printf("Connect failed: %s\n", mysqli_connect_error());
- exit();
- }
- $sql="CALL st_dsml('01')";
- $q2=$mysqli->query($sql);
- /*
- tidak di satukan agar rapi
- dan mudah dibaca pemula
- */
- if(!$q2)
- {
- die( $mysqli->error."<br>$sql");
- }
- //while ($rows = mysqli_fetch_array($result1, MYSQLI_ASSOC))
- while($row = $q2->fetch_assoc())
- {
- $jnopel=$rows['nopel'];
- $jnama=$rows['nama'];
- $jalamat=$rows['alamat'];
- $jwilayah=$rows['Wilayah'];
- $jawal=$rows['awal'];
- $jakhir=$rows['akhir'];
- $jtarif=$rows['tarif_cd'];
- $sql = "INSERT INTO tr_temp_dsml SET nopel='$jnopel', nama='$jnama', alamat='$jalamat', wilayah='$jwilayah', awal='$awal', akhir='$akhir', bad='0'";
- $q2=$mysqli->query($sql);
- if(!$q2)
- {
- die( $mysqli->error."<br>$sql");
- }
- }
- //mysqli_close($connect);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement