Differences

This shows you the differences between two versions of the page.

Link to this comparison view

ex_mysqli [2012-10-23 14:26]
Joakim Forsgren 		ex_mysqli [2017-09-01 14:54]
Line 1: Line 1:
-====== exempel på mysqli ====== 
-<code php> 
-<?php 
-error_reporting (E_ALL ^ E_NOTICE); 
-/** 
- * Exempel på mur man koplar upp sig till en databas 
- */ 
-// $mysqli = new mysqli("localhost", "user", "password", "database"); // ordningen på parametrarna 
-$mysqli = new mysqli("localhost", "lektion", "lektion", "lektion"); 
-// 
-if ($mysqli->connect_errno) { 
-  echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; 
-} 
-$query = "SET NAMES utf8"; 
-$result = $mysqli->query($query); 
  
- 
-/** 
- * Lägger in data i databasen om man har tryckt på submit, 
- * tar bort html-taggar 
- * laddar om sidan för att tömma POST cachen. 
- */ 
-if ($_POST['submit']) { 
-  $query="INSERT INTO `Items` (`ItemID` ,`Item` ,`Date`) 
-          VALUES (NULL , '" . strip_tags($_POST['Item']). "', NOW( ))"; 
-  if (false === $mysqli->query($query)) { 
-    echo $mysqli->error; 
-    exit; 
-  } else { 
-    header('location: ' . basename($_SERVER['SCRIPT_NAME'])); 
-    exit; 
-  } 
-} 
- 
-// Börjar visa HTML 
-include('head.php'); 
-?> 
-<form method="post"> 
- <input type="text" name="Item" /> 
- <input type="submit" name="submit" value="Spara" /> 
-</form> 
- 
-<?php 
-$query = "SELECT * FROM Items"; 
-$result = $mysqli->query($query); 
- 
-/* fetch associative array from result*/ 
-echo 'Antal rader frågan ' . $query . ' ger är: ' . $result->num_rows . '<br><br>'; 
-while ($row = $result->fetch_assoc()) { 
-  echo $row["Item"] . ' <i>(Inlagd: ' . $row['Date'] . ')</i><br>'; 
-} 
- 
-include('foot.php'); 
- 
-</code>