php ลบข้อมูลทั้งตาราง

 http://gems.sunpasit.go.th/

<?php 

$user = "user"; 

$password = "password"; 

$host = "host"; 

$database= "database";

$connection= mysql_connect ($host, $user, $password);

if (!$connection)

{

die ('Could not connect:' . mysql_error());

}

mysql_select_db($database, $connection);

$truncatetable= mysql_query("TRUNCATE TABLE table_name");

if($truncatetable !== FALSE)

{

   echo("All rows have been deleted.");

}

else

{

   echo("No rows have been deleted.");

}

?>

Gen Json Mysql Object

 โค้ดไฟล์ dbconnect.php

<?php 

$mysqli = new mysqli("localhost", "root","","test"); 

/* check connection */

if ($mysqli->connect_errno) { 

    printf("Connect failed: %s\n", $mysqli->connect_error); 

    exit(); 

} 

if(!$mysqli->set_charset("utf8")) { 

    printf("Error loading character set utf8: %s\n", $mysqli->error); 

    exit(); 

}

Gen Json.php

<?php

header("Content-type:application/json; charset=UTF-8");   

header("Cache-Control: no-store, no-cache, must-revalidate");        

header("Cache-Control: post-check=0, pre-check=0", false);

require_once("inc/dbconnect.php");

$sql = "

SELECT * FROM province_th WHERE 1 ORDER BY province_id

";

$result = $mysqli->query($sql);

if($result && $result->num_rows > 0){

    while($row = $result->fetch_assoc()){

        $json_data[] = array(

            "province_id" => $row['province_id'],

            "province_name" => $row['province_name']

        );

    }

}

// แปลง array เป็นรูปแบบ json string 

if(isset($json_data)){ 

    $json= json_encode($json_data);   

    if(isset($_GET['callback']) && $_GET['callback']!=""){   

    echo $_GET['callback']."(".$json.");";       

    }else{   

    echo $json;   

    }   

}

?>

https://www.ninenik.com/content.php?arti_id=373


แจ้งเสีย 3ฺฺBB CAT TOT

 สายตรงช่าง  แจ้งเสีย3ิbb ::021001199  หรือ 021021199 หรือ โทร 1530 XXXBINF0200319

CAT:::ODNO66390170 แจ้ง 1322 ก่อน tel. 02104111 ช่าง 0864501455

TOT:::

Gen Qr Code ทำกัน

 https://www.the-qrcode-generator.com/