Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db_host = "sql.your.server";
- $db_user = "login";
- $db_pass = "p@$$w0|^d";
- $db_name = "name";
- $mysqli = new mysqli($db_host, $db_user, $db_pass, $db_name);
- if (mysqli_connect_errno() != 0) {
- echo '<p>Wystąpił błąd połączenia: ' . mysqli_connect_error() . '</p>';
- exit();
- } else {
- $mysqli->set_charset("utf8");
- }
- $query = $mysqli->query("SELECT a ,b ,c
- FROM `sample_arts` art
- JOIN `sample_users` users ON (users.id = art.author)
- WHERE art.deleted = 0
- LIMIT 10");
- while ($arts = $query->fetch_assoc()) {
- echo "<li>" . $arts['a'] . "</li>";
- }
- // insert do bazy
- $query = $mysqli->prepare("INSERT INTO `sample_arts_test` (`title`, `date_add`, `text`, `author`)
- VALUES (?, now(), ?, ? )");
- $query->bind_param('sss', $new_art['title'], $new_art['text'], $author);
- $query->execute();
- $mysqli->close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement