Advertisement
Solamance

Untitled

Apr 4th, 2018
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.13 KB | None | 0 0
  1. <html>
  2. <body>
  3. <?php
  4. session_start();
  5. //$url="http://www.ucbcanada.com/onebyone.html";
  6. //echo '<META HTTP-EQUIV=Refresh Content="0; URL='.$url.'">';
  7. $username="dbo732683919";
  8. $password="Wala1910!!";
  9. $database="db732683919";
  10. $host="db732683919.db.1and1.com";
  11. $operatorname=$_SESSION['username'];
  12. #connect to db
  13. $con = mysql_connect($host,$username,$password);
  14. if (!$con)
  15. {die('Could not connect: ' . mysql_error());
  16. }
  17. mysql_select_db('db732683919', $con);
  18.  
  19. $fields=array('fname', 'lname', 'email', 'address', 'city', 'province', 'postcode', 'voice', 'donortype', 'reasonforsupp', 'donorapproach', 'callback', 'callbackno', 'notes', 'existingmonthly', 'newtwfyt', 'oldtwfyt', 'donationtype', 'donationamount', 'onair', 'onairname', 'onaircity','operatorname');
  20. $sql=array();
  21. foreach ($fields as $field) {
  22.     $sql[]="`".$field."`='".mysql_escape_string($_POST[$field])."'";
  23. }
  24. $sql="INSERT INTO obo2018 SET ".implode(", ", $sql).";";
  25.     $q=mysql_query($sql, $con);
  26. if (mysql_errno($con)>0) { echo '<p>'.htmlentities(mysql_error($con)).'</p>'; } else { echo '<p>Success!</p>', $operatorname; }
  27. mysql_close($con);
  28.  
  29. ?>
  30. </body>
  31. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement