Untitled

From Violet Tortoise, 5 Years ago, written in Plain Text.

Embed

Download Paste or View Raw
Hits: 233

<html>

<head>

</head>

<body>

<?php

$mysqli = new mysqli('localhost', 'adam', '1234', 'komis');

if ($mysqli->connect_error) {

// w przypadku błędu (od wersji PHP 5.3), wyświetli się odpowiedni komunikat

die('Connect Error ('.$mysqli->connect_errno.') '. $mysqli->connect_error);

// w przypadku błędu (do wersji PHP 5.3), wyświetli się odpowiedni komunikat

if (mysqli_connect_error()) {

die('Connect Error (' . mysqli_connect_errno() . ') '

. mysqli_connect_error());

}

}

$zapytanie = "set names utf8";

$wynik = $mysqli->query($zapytanie);

$zapytanie = "SELECT * FROM osoby order by Adres";

$wynik = $mysqli->query($zapytanie);

if ($wynik->num_rows > 0) {

// output data of each row

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

echo "id: " . $row["ID"]. " - Imie: " . $row["Imie"]. " " . $row["Nazwisko"]. " " . $row["Adres"]. "<br>";

}

} else {

echo "0 results";

}

?>

<form action='insert.php' method='post'>

Imie <input type='text' name='Imie'>

Nazwisko <input type='text' name= 'Nazwisko'>

Adres <input type='text' name='Adres'>

<input type="submit" value="Insert">

</form>

</body>

</html>

Author

Title

Language

Your paste - Paste your paste here

&lt;html&gt;
&lt;head&gt;
&lt;/head&gt;
&lt;body&gt;
&lt;?php
 
 
$mysqli = new mysqli('localhost', 'adam', '1234', 'komis');
if ($mysqli-&gt;connect_error) {
    // w przypadku błędu (od wersji PHP 5.3), wyświetli się odpowiedni komunikat
    die('Connect Error ('.$mysqli-&gt;connect_errno.') '. $mysqli-&gt;connect_error);
    // w przypadku błędu (do wersji PHP 5.3), wyświetli się odpowiedni komunikat
    if (mysqli_connect_error()) {
       die('Connect Error (' . mysqli_connect_errno() . ') '
       . mysqli_connect_error());
    }
}
 
 $zapytanie = &quot;set names utf8&quot;;
$wynik = $mysqli-&gt;query($zapytanie);
 
$zapytanie = &quot;SELECT * FROM osoby order by Adres&quot;;
$wynik = $mysqli-&gt;query($zapytanie);
 
if ($wynik-&gt;num_rows &gt; 0) {
    // output data of each row
    while($row = $wynik-&gt;fetch_assoc()) {
        echo &quot;id: &quot; . $row[&quot;ID&quot;]. &quot; - Imie: &quot; . $row[&quot;Imie&quot;]. &quot; &quot; . $row[&quot;Nazwisko&quot;]. &quot; &quot;   . $row[&quot;Adres&quot;]. &quot;&lt;br&gt;&quot;;
    }
} else {
    echo &quot;0 results&quot;;
} 
?&gt;
&lt;form action='insert.php' method='post'&gt;
Imie &lt;input type='text' name='Imie'&gt;
Nazwisko &lt;input type='text' name= 'Nazwisko'&gt;
Adres &lt;input type='text' name='Adres'&gt;
&lt;input type=&quot;submit&quot; value=&quot;Insert&quot;&gt;
&lt;/form&gt;
&lt;/body&gt;
&lt;/html&gt;

Private - Private paste aren't shown in recent listings.

Delete After - When should we delete your paste?

Spam protection -

{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}

Reply to "Untitled"