php/addrecipe.inc.php at main · dpllc-data/php · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
<?php


$title = $_POST['title'];


$poster = $_POST['poster'];


$shortdesc = $_POST['shortdesc'];


$ingredients = htmlspecialchars($_POST['ingredients']);


$directions = htmlspecialchars($_POST['directions']);


if (trim($poster) == "")


{


    echo "<h2>Sorry, each recipe must have a poster</h2>\n";


}else


{


$con = mysqli_connect("localhost:3306", "root", "~Leodis27", "datapandemonium") or die('Sorry, could not connect to the database or server');


    $query = "INSERT INTO recipes (title, shortdesc, poster, ingredients, directions) " .


          " VALUES ('$title', '$shortdesc', '$poster', '$ingredients', '$directions')";


$result = mysqli_query($con, $query);


    if ($result)


       echo "<h2>Recipe posted</h2>\n";


    else


       echo "<h2>Sorry, there was a problem posting your recipe</h2>\n";


}


?>