Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- include("config.php");
- if(!isset($_SESSION['username']) && (!isset($_SESSION['wachtwoord'])))
- {
- echo "U bent niet goed ingelogd.";
- }
- else
- {
- ?>
- Op deze pagina kunt u favorieten toevoegen door middel van het onderstaande invulformulier.
- <br />
- <form method="post" action="?">
- Url:
- <input type="text" name="url" />
- <br />
- Categorie:<select name="categorie">
- <?php
- $query = "SELECT * FROM `categorie`";
- $result = mysql_query($query)or die('Er is een technische storing opgetreden');
- while($cat = mysql_fetch_assoc($result))
- {
- echo "<option value=\"{$cat['categorie_id']}\">{$cat['categorie_naam']}</option>";
- }
- ?>
- </select>
- <br />
- <input type="submit" name="submit" value="Voeg Toe!" />
- </form>
- <?php
- if(isset($_POST['submit']) && (isset($_POST['categorie'])) && (isset($_POST['url'])))
- {
- $urlreal = $_POST['url'];
- $username = $_SESSION['username'];
- $gebr = mysql_query("SELECT `gebruiker_id` FROM `gebruiker` WHERE `login` = '".$username."'");
- $gebruiker = mysql_fetch_assoc($gebr);
- $categorie = $_POST['categorie'];
- var_dump($gebruiker);
- $urlquery2 = mysql_query("SELECT * FROM `url` WHERE `url_naam` = '".$urlreal."'");
- $urlresult = mysql_fetch_assoc($urlquery2);
- $rowsurl = mysql_num_rows($urlquery2);
- //checken of url bestaat in database
- if ($rowsurl == 0)
- {
- $query3=mysql_query("INSERT INTO `url` (`url_adres`) VALUES( '".$urlreal."' )");
- $urlquery = mysql_query("SELECT `url_id` FROM `url` WHERE `url_naam` = ".$_POST['url']);
- $url= mysql_fetch_assoc($urlquery);
- }
- else
- {
- //als wel bestaat
- $urlreal = $urlresult;
- mysql_query("INSERT INTO `url` (`url_adres`) VALUES( '".$urlreal."' )");
- $url = $urlreal;
- }
- $query2 = mysql_query("INSERT INTO `marks` (`gebruiker_id`, `url_id`, `categorie_id`) VALUES( '".$gebruiker."', '".$url."', '".$categorie."')") or die(mysql_error());
- echo "Favoriet toegevoegd";
- }
- else
- {
- echo "U heeft niks ingevuld.";
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement