Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $result = mysqli_query("SELECT jmeno, prijmeni FROM uzivatele");
- $row = mysql_fetch_row($result);
- // Připojovací údaje
- define('SQL_HOST', 'localhost');
- define('SQL_DBNAME', 'database');
- define('SQL_USERNAME', 'root');
- define('SQL_PASSWORD', '');
- $dsn = 'mysql:dbname=' . SQL_DNAME . ';host=' . SQL_HOST .'';
- $user = SQL_USERNAME;
- $password = SQL_PASSWORD;
- try{
- $pdo = new PDO($dsn, $user, $password);
- $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- }
- catch (PDOException $e){
- die('Connection failed: ' . $e->getMessage());
- }
- $dotaz = $pdo->query("SELECT jmeno, prijmeni FROM uzivatele");
- // Připravení dotazu
- $dotaz = $pdo->prepare("SELECT jmeno, prijmeni FROM uzivatele WHERE id = ?");
- // Vykonání dotazu
- $vysledek = $dotaz->execute(array($idUzivatele));
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement