Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include("nagl.php");
- $servername="mysql.agh.edu.pl";
- $username="konned";
- $database="konned";
- $password="LmhxKj1d22bLEE4h";
- $conn=new mysqli($servername,$username,$password,$database);
- if($conn->connect_error)
- {
- die("Brak polaczenia: " . $conn->connect_error . "<br>");
- }
- echo "Połączenie z bazą <br>";
- $zapytanie="SELECT * FROM test_users";
- echo"<br>" . $zapytanie . "<br>";
- $result=$conn->query("SET NAMES 'utf8'");
- $result=$conn->query($zapytanie);
- echo "liczba znalezionych rekordów: " . $result->num_rows . "<br>";
- if($result->num_rows > 0){
- while($row = $result->fetch_assoc()){
- echo '<a href="http://student.agh.edu.pl/~konned/siwm/edit.php?id=' . $row["id"] . '">' . $row["id"] . '</a>'. " | ".
- $row["nazwa"] . " | ". $row["email"] . " | ".
- $row["haslo"] . " | ". $row["status"]."<br>";
- }
- } else {
- echo "Zwrócono 0 rekordów <br>";
- }
- ?>
- <H3>Dodawanie rekordu</H3>
- <form action="" method="post">
- Nazwa: <input type="text" name="imie">
- Haslo: <input type="text" name="pass">
- Email: <input type="text" name="mail">
- Status: <input type="text" name="stats">
- <input type="submit" name="potwierdzenie" value="Dodaj">
- </form>
- <?php
- if(isset($_POST['potwierdzenie']))
- {
- $zapytanie="INSERT INTO test_users(nazwa,haslo,email,status) VALUES('".$_POST['imie']."','".$_POST['pass']."','".$_POST['mail']."','".$_POST['stats']. "')";
- echo "<br>" . $zapytanie . "<br>";
- $result1=$conn->query($zapytanie);
- header( "refresh:5;url=debuger_bazy.php" );
- }
- ?>
- <?php
- $conn->close();
- include("stopka.php");
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement