Jump to content

kite111

Members
  • Posts

    5
  • Joined

  • Last visited

kite111's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. tried this code. now i'm getting undefined index for every var in $_______ starting in if statement submit..what's wrong? if(isset($_FILES['filename'])){ $errors = array(); $file_name = $_FILES['filename']['name']; $file_size =$_FILES['filename']['size']; $file_tmp =$_FILES['filename']['tmp_name']; $file_type=$_FILES['filename']['type']; $file_ext=strtolower(end(explode('.',$_FILES['filename']['name'])));}if($_POST['submit']=="Submit"); { $nameSender = ($_POST['name_sender']); $Address = ($_POST['address']); $contact_no = ($_POST['contactno']); $total_sent = ($_POST['totalsent']); $date_sent = ($_POST['datesent']); $file_name = ($_POST['filename']); addData ($nameSender,$Address,$contact_no,$total_sent,$date_sent,$file_name); }function addData($nameSender, $Address, $contact_no, $total_sent, $date_sent, $file_name) { include ("dbinfo.php"); $sql = "INSERT INTO payment_form VALUES (null, '$nameSender', '$Address', '$contact_no', '$total_sent', '$date_sent', '$file_name')"; $result = mysql_query($sql) or die(mysql_error()); }
  2. yeah. i have no idea why it doesn't insert in the db.
  3. just some text like address, contact no, date. i wanna insert them to the columns in a db table.
  4. No i didn't echo the variables.got no errors.the file uploaded in the folder but the text fields didn't insert. oh and that was VALUES.the S just got erased from the editing.still doesn't insert in the db table. what else should I try?
  5. Hello. I have a form with 5 textfields and 1 file field. It can already upload the file to a specified folder but I can't make it work when there are multiple textfields.It doesn't insert into the db table. How do you guys do it? <?phpif(isset($_FILES['filename'])){ $errors = array(); $file_name = $_FILES['filename']['name']; $file_size =$_FILES['filename']['size']; $file_tmp =$_FILES['filename']['tmp_name']; $file_type=$_FILES['filename']['type']; $file_ext=strtolower(end(explode('.',$_FILES['filename']['name'])));if(isset($_POST['name_sender'])){ $nameSender = $_POST['name_sender'];}if(isset($_POST['address'])){ $Address = $_POST['address'];}if(isset($_POST['contactno'])){ $contact_no = $_POST['contactno'];}if(isset($_POST['totalsent'])){ $total_sent = $_POST['totalsent'];}if(isset($_POST['datesent'])){ $date_sent = $_POST['datesent'];} $expensions= array("jpeg","jpg","png"); if(in_array($file_ext,$expensions)=== false){ $errors[]="extension not allowed, please choose a JPEG or PNG file."; } if($file_size > 2097152){ $errors[]='File size must be excately 2 MB'; } // if there are no errors... if (empty($errors)==true) { // upload the file... move_uploaded_file($file_tmp,"uploads/".$file_name); $servername = "localhost"; $username = "root"; $password = ""; $dbname = "admin"; // and create a new record in the database mysql_connect($servername, $username, $password) or die ('MySQL Not found // Could Not Connect.'); mysql_select_db("admin") or die(mysql_error()) ; mysql_query("INSERT INTO payment_form (name, address, contactno, totalsent, paymentdate, filename) VALUE ('$nameSender', '$Address', '$contact_no', '$total_sent', '$date_sent', $file_name')") ; echo "Success"; }else{ print_r($errors); }}?> i'm certain the my db table has the corresponding columns. sorry if it's a messy or a wrong way to code.i'm still in the stage of putting together codes that work...
×
×
  • Create New...