<?php require("config.php"); if (!empty($_POST)) { $query = " SELECT 1 FROM controldevice1 WHERE device1 = :dev1"; $query_params = array( ':dev1' => $_POST['device1'] ); try { $stmt = $db->prepare($query); $result = $stmt->execute($query_params); } catch (PDOException $ex) { $response["success"] = 0; $response["message"] = "Database Error1. Please Try Again!"; die(json_encode($response)); } $query = "INSERT INTO controldevice1 ( device1 ) VALUES ( :dev1 ) "; $query_params = array( ':dev1' => $_POST['device1'], ); try { $stmt = $db->prepare($query); $result = $stmt->execute($query_params); } catch (PDOException $ex) { $response["success"] = 0; $response["message"] = "Database Error2. Please Try Again!"; die(json_encode($response)); } $response["success"] = 1; $response["message"] = "Successfully Added!"; echo json_encode($response); } else { ?> <h1>testbutton</h1> <form action="textbutton.php" method="post"> device:<br /> <input type="text" name="device1" value="" /> <br /><br /> <input type="submit" value="test" /> </form> <?php } ?>
<?php $username = "root"; $password = "ammaew"; $host = "localhost"; $dbname = "project"; $options = array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'); try { $db = new PDO("mysql:host={$host};dbname={$dbname};charset=utf8", $username, $password, $options); } catch(PDOException $ex) { die("Failed to connect to the database: " . $ex->getMessage()); } $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); if(function_exists('get_magic_quotes_gpc') && get_magic_quotes_gpc()) { function undo_magic_quotes_gpc(&$array) { foreach($array as &$value) { if(is_array($value)) { undo_magic_quotes_gpc($value); } else { $value = stripslashes($value); } } } undo_magic_quotes_gpc($_POST); undo_magic_quotes_gpc($_GET); undo_magic_quotes_gpc($_COOKIE); } header('Content-Type: text/html; charset=utf-8'); session_start(); ?>
<?php require("config.php"); if (!empty($_POST)) { $query = " SELECT 1 FROM controldevice1 WHERE device1 = :dev1"; $query_params = array( ':dev1' => $_POST['device1'] ); try { $stmt = $db->prepare($query); $result = $stmt->execute($query_params); } catch (PDOException $ex) { $response["success"] = 0; $response["message"] = "Database Error1. Please Try Again!"; die(json_encode($response)); } $query = "UPDATE controldevice1 SET device1 = ':dev1'"; $query_params = array( ':dev1' => $_POST['device1'], ); try { $stmt = $db->prepare($query); $result = $stmt->execute($query_params); } catch (PDOException $ex) { $response["success"] = 0; $response["message"] = "Database Error2. Please Try Again!"; die(json_encode($response)); } $response["success"] = 1; $response["message"] = "Successfully Added!"; echo json_encode($response); } else { ?> <h1>testbutton</h1> <form action="textbutton.php" method="post"> device:<br /> <input type="text" name="device1" value="" /> <br /><br /> <input type="submit" value="test" /> </form> <?php } ?>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง