
<?php // Set global $pdo; if (isset($pdo)) {return;} mysqli_report(MYSQLI_REPORT_STRICT); $pdo = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME); // Set the PDO::ATTR_EMULATE_PREPARES Attribute to false $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, true); if (mysqli_connect_errno()) { die(sprintf("Connect failed: %s\n", mysqli_connect_error())); } // Prepared Statements $firstname = "bruce"; $sql = "SELECT * FROM users WHERE firstname =:fname ;"; $stmt = $pdo->prepare($sql); $stmt->bindValue(":fname", $firstname); $stmt->execute(); if(!$result = $stmt->fetch(PDO::FETCH_OBJ)){ echo "Credentials do no match"; } else { echo"Id: ".$result->id. " Name: ".$result->firstname." ".$result->lastname; } // Prepared Statements With Parameterized Query $firstname = "jeff"; $sql = "SELECT * FROM users WHERE firstname = ?"; $stmt = $pdo->prepare($sql); $stmt->bind_param("s", $firstname); $stmt->execute(); $result = $stmt->get_result(); if($result->num_rows === 0) exit('No rows'); while($row = $result->fetch_assoc()) { echo"Id: ".$row['id']. " Name: ".$row['firstname']." ".$row['lastname']; }
<?php // GET HTTP HEADERS VALUES // SINGLE VALUE - Replace XXXXXX_XXXX with the name of the header you need in UPPERCASE (and with '-' replaced by '_') $headerStringValue = $_SERVER['HTTP_XXXXXX_XXXX']; echo $headerStringValue; // GET ALL HEADERS $headers = apache_request_headers(); foreach ($headers as $header => $value) { echo "$header: $value <br />\n"; } ?>
<?php echo "<ul>"; foreach ($_POST as $key => $value) { echo "<li>".$key." : ".$value; echo "</li>"; } ?>
Loading...
No more items to load