Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html lang="pl">
- <head>
- <meta charset="utf-8">
- <link rel="stylesheet" type="text/css" href="style.css">
- <title>TiTLe</title>
- </head>
- <body>
- <form action="index.php" method="GET">
- a:<input type="number" name="a"><br>
- b:<input type="number" name="b"><br>
- <input type="submit" value="wo">
- </form>
- <?php
- function suma($x, $y){
- $s=$x+$y;
- return $s;
- }
- //polaczenie z baza danych:
- $serverName="localhost";
- $userName="root";
- $pass="";
- $dbName="prostokat";
- if(isset($_GET["a"]) && $_GET["a"]!="" && $_GET["b"]!=""){
- $conn=mysqli_connect($serverName,$userName,$pass,$dbName);
- if(!$conn) {
- die("blad polaczenia".mysqli_connect_error());
- }
- $sql="insert into dane (a,b) values(".$_GET["a"].",".$_GET["b"].");";
- $wynik=mysqli_query($conn,$sql);
- if(!$wynik){ die ("wynik zapytania blad");}
- else{
- $wynik=suma($_GET["a"],$_GET["b"]);
- echo "<br> Wynik działania funkcji suma:".$wynik."<br>Zawartosc tabeli z bazy danych<br>";
- $str="<table border=1>";
- $str.="<tr><td>id</td><td>a</td><td>b</td><tr>";
- $sql="select *from dane;";
- $wynik=mysqli_query($conn,$sql);
- if($wynik){
- if(mysqli_num_rows($wynik)>0){
- while ($wiersz=mysqli_fetch_assoc($wynik)){
- $str.="<tr><td>".$wiersz["id"]."</td><td>".$wiersz["a"]."</td><td>".
- $wiersz["b"]."</td></tr>";
- }
- }
- }
- $str.="</table";
- echo $str;
- }
- mysqli_close($conn);
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement