Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ini_set('display_errors','on');
- error_reporting(32767);
- // Set your database information here
- $db_host = 'localhost';
- $db_user = 'user';
- $db_pass = 'pass';
- $db_name = 'name';
- ?>
- <html>
- <head>
- <title>Bulk Add</title>
- <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
- <script language="javascript">
- self.moveTo(0,0);
- self.resizeTo(screen.availWidth,screen.availHeight);
- </script>
- <style type="text/css">
- td {
- font-family: Verdana;
- font-size: 12px;
- }
- a {
- color: #000000;
- text-decoration: underline;
- }
- a:hover {
- color:#FF0000;
- text-decoration: underline;
- }
- .style1 {
- color: #FF0000;
- }
- </style>
- </head>
- <body>
- <div align="center">
- <?php include ("/top.php"); ?>
- </div>
- <div align="center">
- <?php
- @mysql_connect($db_host,$db_user,$db_pass) or die(mysql_error());
- @mysql_select_db($db_name) or die(mysql_error());
- if(isset($_POST['submit1'])) {
- if(isset($_POST['links'])) {
- $links = explode("\n",$_POST['links']);
- ?>
- <form action="" method="post">
- <?php
- date_default_timezone_set('Europe/Amsterdam');
- $datum = date('d/m/y');
- foreach($links as $linki => $link) {
- ?>
- <div align="center" style="width: 800px;">
- <strong>Datum</strong><br />
- <input type="text" name="links[<?php print $linki; ?>][datum]" size="150" value="<?php print $datum ?>" /><br /><br />
- <strong>Soort</strong><br />
- <select name="links[<?php print $linki; ?>][soort]">
- <option value="films">films</option>
- <option value="fotoserie">fotoserie</option>
- <option value="aanrader">aanrader</option>
- </select><br /><br />
- <strong>Niche</strong><br />
- <input type="text" name="links[<?php print $linki; ?>][niche]" size="150" /><br /><br />
- <strong>Link</strong><br />
- <input type="text" name="links[<?php print $linki; ?>][link]" size="150" value="<?php print $link; ?>" /><br /><br />
- <strong>tekst</strong><br />
- <input type="text" name="links[<?php print $linki; ?>][tekst]" size="150" maxlength="150" />
- </div>
- <hr />
- <?php
- }
- print '<input type="submit" name="submit2" value="Finish >>"';
- ?>
- </form>
- <?php
- }
- else {
- print 'Wtf?';
- }
- }
- elseif(isset($_POST['submit2'])) {
- if(isset($_POST['links'])) {
- foreach($_POST['links'] as $link_arrayi => $link_array) {
- foreach($link_array as $key => $value) {
- $link_array[$key] = mysql_real_escape_string($value);
- }
- $link = mysql_real_escape_string($link_array['link']);
- $datum = mysql_real_escape_string($link_array['datum']);
- $datum = strtotime($datum,date('d/m/y'));
- $soort = mysql_real_escape_string($link_array['soort']);
- $niche = mysql_real_escape_string($link_array['niche']);
- $tekst = mysql_real_escape_string($link_array['tekst']);
- $query = 'INSERT INTO bertus (datum,soort,niche,link,tekst) VALUES("' . $datum . '","' . $soort . '","' . $niche . '","' . $link . '","' . $tekst . '")';
- if(@mysql_query($query)) {
- ?>
- <form action="" method="post">
- <div align="center" style="width: 800px;">
- <strong>Links</strong><br />
- <span style="font-size: 7;">Separate links with a new line</span><br />
- <textarea width="600px" height="200px" name="links"></textarea>
- </div>
- <div align="right">
- <input type="submit" name="submit1" value="Next >>" />
- </div>
- </form>
- <hr />
- <?php
- print '<hr /><h4>' . time('d/m/y',$datum) . '<br />';
- print $soort . '<br />';
- print $niche . '<br />';
- print $link . '<br />';
- print $tekst . '<br /></h4>';
- }
- else {
- print mysql_error();
- }
- }
- }
- else {
- print 'Wtf?';
- }
- }
- else {
- ?>
- <form action="" method="post">
- <div align="center" style="width: 800px;">
- <strong>Links</strong><br />
- <span style="font-size: 7;">Separate links with a new line</span><br />
- <textarea width="600px" height="200px" name="links"></textarea>
- </div>
- <div align="right">
- <input type="submit" name="submit1" value="Next >>" />
- </div>
- </form>
- <?php
- }
- ?>
- </div>
- <div align="center">
- <?php include("/under.php"); ?>
- </div>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement