Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- include 'connect.php';
- $userid = $_SESSION["userid"];
- $q = mysql_query("SELECT * FROM users WHERE user_id='$userid'")or die(mysql_error());
- $n = mysql_num_rows($q);
- $res = mysql_fetch_assoc($q);
- if($res["admin"] == 1)
- {
- $message = "";
- $message .= "Nadias bestilling til porthusgade 1 \r\n\r\n";
- $q2 = mysql_query("SELECT * FROM Bestillinger ORDER BY userid2 ASC")or die(mysql_error());
- while($r = mysql_fetch_assoc($q2))
- {
- echo '<b>'.$r["userid2"].' - '.$r["Navn"].'</b>: '.$r["Brod"].' med '.$r["Fyld"].' og '.$r["Dressing"].'. Ekstra: '.$r["Ekstra"].'.<br />';
- $userid2 = $r['userid2'];
- $Navn = $r['Navn'];
- $Brod = $r['Brod'];
- $Fyld = $r['Fyld'];
- $Dressing = $r['Dressing'];
- $Ekstra = $r['Ekstra'];
- $message .= "$userid2 - $Navn: $Brod med $Fyld og $Dressing. Ekstra: $Ekstra \r\n";
- }
- $message .= "\r\nAntal bestillinger lavet:\r\n";
- $qlist = mysql_query("SELECT Brod, COUNT(Navn) AS antal FROM Bestillinger GROUP BY brod")or die(mysql_error());
- while($row = mysql_fetch_array($qlist))
- {
- $Brod = $row['Brod'];
- $antal = $row['antal'];
- $message .= " - $antal $Brod i ordre \r\n";
- $from = "Søren Andersson, Porthusgade 1";
- $headers = "Fra: $from";
- }
- if(isset($_POST["print"])) //if "email" is filled out, send email
- {
- $to = "deus83@gmail.com";
- $subject = "Bestilling til Porthusgade 1";
- mail($to,$subject,$message,$headers);
- echo "</ p>Mailen er sendt";
- }
- else
- //hvis der ikke er sendt "print" til $_post skal den vise knappen...
- {
- echo "<form method='post' action=''>";
- echo "<input type='submit' value='Send mail til Nadias' name='print'>";
- echo "</form>";
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement