• View
• Edit
• History
• Print

Arsip04

////baca//////////////////////////////
$user="semerure_1";
$password="xxxxxxxxxxx?D";
$database="semerure_1";

mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM xcabang ORDER BY id ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();

$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,"id");
$cabang=mysql_result($result,$i,"cabang");
$xid=mysql_result($result,$i,"xid");
////$cab3=strtoupper( $cabang );
$i++;
}



///////////// update//////////////////////
// Create connection
$conn = mysqli_connect(localhost, $user, $password, $database);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
$sql = "UPDATE atmKU SET cabang='$cabang' WHERE id='$xid'";
if (mysqli_query($conn, $sql)) {
    echo "<h2>Record updated successfully</h2>";
} else {
    echo "Error updating record: " . mysqli_error($conn);
}
mysqli_close($conn);



//////////insetr
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO atmKU VALUES ('','$bank','$cabang','$idatm','$ssb','$atmseri','$lokasi','$ordinat','-','-','-','-','-','-','-')";

mysql_query($query) or die ('<hr><h2>'.mysql_error().'</h2><hr>');
echo "<h2>Update Database...</h2>";
mysql_close();
///////////////////////


/////hapus dari stok/////////////////
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="DELETE FROM atmpart04 WHERE id = '$val'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
////////////////////


/////kosongkan tabel keluar
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="Truncate table atmpart03";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
//////////////////////