Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <body>
- <?php
- session_start();
- //$url="http://www.ucbcanada.com/onebyone.html";
- //echo '<META HTTP-EQUIV=Refresh Content="0; URL='.$url.'">';
- $username="dbo732683919";
- $password="Wala1910!!";
- $database="db732683919";
- $host="db732683919.db.1and1.com";
- $operatorname=$_SESSION['username'];
- #connect to db
- $con = mysql_connect($host,$username,$password);
- if (!$con)
- {die('Could not connect: ' . mysql_error());
- }
- mysql_select_db('db732683919', $con);
- $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');
- $sql=array();
- foreach ($fields as $field) {
- $sql[]="`".$field."`='".mysql_escape_string($_POST[$field])."'";
- }
- $sql="INSERT INTO obo2018 SET ".implode(", ", $sql).";";
- $q=mysql_query($sql, $con);
- if (mysql_errno($con)>0) { echo '<p>'.htmlentities(mysql_error($con)).'</p>'; } else { echo '<p>Success!</p>', $operatorname; }
- mysql_close($con);
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement