Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $server = "149.156.115.209";
- $user = "s306055";
- $password = "filipmusial";
- $db = "s306055";
- $dbconnect = mysqli_connect($server,$user,$password,$db);
- mysqli_set_charset($dbconnect, 'utf8');
- //edycja rekordów
- if(isset($_POST['addUser'])){
- $usrName = $_POST['name'];
- $usrSurName = $_POST['surname'];
- $usrCar = $_POST['favCar'];
- $queryAdd = "insert into questbook values('','$usrName','$usrSurName','$usrCar')";
- mysqli_query($dbconnect,$queryAdd);
- }
- if(isset($_POST['delUser'])){
- $usrId = $_POST['userId'];
- $queryDel = "delete from questbook where $usrId = id";
- mysqli_query($dbconnect,$queryDel);
- }
- ////
- $all = "select * from questbook";
- $queryAll = mysqli_query($dbconnect,$all);
- //rysowanie tabeli
- while($tab = mysqli_fetch_row($queryAll))
- {
- echo '<tr>';
- foreach($tab as $row)
- {
- echo '<td style="border: 1px solid black;">'.$row.'</td>';
- }
- echo '</tr>';
- }
- mysqli_close($dbconnect);
- ?>
- </table>
- <p>
- Sign in
- </p>
- <form name="add" method="post">
- Name: <input type="text" name="name"><br>
- Surname: <input type="text" name="surname"><br>
- Favorite Car: <input type="text" name="favCar"><br>
- <input type="submit" value="Add" name="addUser">
- </form>
- <p>
- Delete
- </p>
- <form name="del" method="post">
- Choose ID to delete: <input type="text" name="userId">
- <input type="submit" value="Delete" name="delUser">
- </form>
- </div>
- </div>
- </div>
- </div>
- </section>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement