i want to upload and save multiple images into database table.
-
-
my coding
AdDetails.php
Code:<?php session_start(); ob_start(); // echo $_SESSION["VALID_USER_ID"]; $valid_user_id = trim($_SESSION["VALID_USER_ID"]); if(isset($_SESSION["VALID_USER_ID"]) && !empty($valid_user_id)) { } else { //Send every user who tries to access this page directly without valid session to the login page. //The login page is the door that every user needs to pass to this page header("location: login.php"); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head id="Head1"> <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE8" /> <link rel="shortcut icon" href="../favicon.ico"> <link rel="stylesheet" type="text/css" href="css/demo.css" /> <link rel="stylesheet" type="text/css" href="css/style3.css" /> <link rel="stylesheet" type="text/css" href="css/animate-custom.css" /> <link href="css/style1.css" rel="stylesheet" type="text/css"> <script type="text/javascript" src="js/vpb_save_details.js"></script> <script type="text/javascript" src="js/jquery_1.5.2.js"></script> <link href="css/Header-footer-standalone.css" type="text/css" rel="stylesheet" /> <script src="js/jquery.tools.ui.min-1.2.7.js" type="text/javascript"></script> <script src="js/sul_gbl_cmn_hdr_1.9-min.js" type="text/javascript"></script> <meta http-equiv="Pragma" content="no-cache" /> <script type="text/javascript"> function errHdl(a, b, c) { return true; } window.onerror = errHdl; </script> <meta name="robots" content="noodp" /> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" /> <meta property='og:image' content='images/fb_thumbnail.jpg' /> <script src="js/GAEventTrack.js" type="text/javascript"></script> <script type= "text/javascript"> (function (G, o, O, g, l) { G.GoogleAnalyticsObject = O; G[O] || (G[O] = function () { (G[O].q = G[O].q || []).push(arguments) }); G[O].l = +new Date; g = o.createElement('script'), l = o.scripts[0]; g.src = '//www.google-analytics.com/analytics.js'; l.parentNode.insertBefore(g, l) } (this, document, '_SulekhaRentalsGATracker')); _SulekhaRentalsGATracker('create', 'UA-26381659-1', 'sulekha.com'); _SulekhaRentalsGATracker('set', { 'dimension1': 'bfa47208-6c40-4c85-855e-a8412e9ca2fa:0', 'dimension3': 'rental', 'dimension4': ' ', 'dimension5': 'residential apartments-flats', 'dimension6': 'Postanad', 'dimension7': 'rental' }); new gaPageView().track(); _gaq = []; </script> <script src="js/sulhdr-0.0.3.js" type="text/javascript"></script> <script src="js/mp2-min.js" type="text/javascript"></script> <link href="css/post-an-ad_new.css?v=0.06" rel="stylesheet" type="text/css" /> <script type="text/javascript"> function ad_Post() { var city = $("#city").val(); var locality = $("#locality").val(); var areaname = $("#areaname").val(); var apartmentname = $("#apartmentname").val(); var address = $("#address").val(); var builtuparea = $("#builtuparea").val(); var renttype = $("#renttype").val(); var depositamount = $("#depositamount").val(); var monthlyrent = $("#monthlyrent").val(); var bedrooms = $("#bedrooms").val(); var landmarks = $("#landmarks").val(); var furnished = $("#furnished").val(); var floornumber = $("#floornumber").val(); var adtitle = $("#adtitle").val(); var addesc = $("#addesc").val(); var files[] = $("#files[]").val(); if(city == "") { $("#ad").html('<div class="info">Please enter your city.</div>'); $("#city").focus(); } else if(locality == "") { $("#ad").html('<div class="info">Please enter your locality.</div>'); $("#locality").focus(); } else if(areaname == "") { $("#ad").html('<div class="info">Please enter your area name.</div>'); $("#areaname").focus(); } else if(apartmentname == "") { $("#ad").html('<div class="info">Please enter your Apartment name.</div>'); $("#apartmentname").focus(); } else if(address == "") { $("#ad").html('<div class="info">Please enter your Address.</div>'); $("#address").focus(); } else if(builtuparea == "") { $("#ad").html('<div class="info">Please enter your Builtup area.</div>'); $("#builtuparea").focus(); } else if(renttype == "") { $("#ad").html('<div class="info">Please enter your rent type</div>'); $("#renttype").focus(); } else if(depositamount == "") { $("#ad").html('<div class="info">Please enter your deposit amount.</div>'); $("#depositamount").focus(); } else if(monthlyrent == "") { $("#ad").html('<div class="info">Please enter your monthly rent amonut.</div>'); $("#monthlyrent").focus(); } else if(bedrooms == "") { $("#ad").html('<div class="info">Please enter your bed room.</div>'); $("#bedrooms").focus(); } else if(landmarks == "") { $("#ad").html('<div class="info">Please enter your Land marks.</div>'); $("#landmarks").focus(); } else if(furnished == "") { $("#ad").html('<div class="info">Please enter your furnished type.</div>'); $("#furnished").focus(); } else if(floornumber == "") { $("#ad").html('<div class="info">Please enter your no of Floor.</div>'); $("#floornumber").focus(); } else if(adtitle == "") { $("#ad").html('<div class="info">Please enter your Ad Title.</div>'); $("#adtitle").focus(); } else if(addesc == "") { $("#ad").html('<div class="info">Please enter your Ad desc.</div>'); $("#addesc").focus(); } else if(files[] == "") { $("#ad").html('<div class="info">Please enter your Ad Photos.</div>'); $("#files").focus(); } else { // '&apartmentname='+apartmentname+'&address='+address+'&builtuparea='+builtuparea+'&renttype='+renttype+'&depositamount='+depositamount+'&monthlyrent='+monthlyrent+'&bedrooms='+bedrooms+'&landmarks='+landmarks+'&furnished='+furnished+'&floornumber='+floornumber+'&adtitle='+adtitle+'&addesc='+addesc+'&adphotos='+adphotos+ var dataString = 'city='+ city + '&locality=' + locality + '&areaname=' +areaname+ '&apartmentname=' +apartmentname+ '&address='+address+ '&builtuparea='+builtuparea+'&renttype='+renttype+'&depositamount='+depositamount+'&monthlyrent='+monthlyrent+'&bedrooms='+bedrooms+'&landmarks='+landmarks+'&furnished='+furnished+'&floornumber='+floornumber+'&adtitle='+adtitle+'&addesc='+addesc+'&adphotos='+adphotos+'&page=adpost'; $.ajax({ type: "POST", url: "save_ad.php", data: dataString, cache: false, beforeSend: function() { $("#ad").html('<br clear="all"><br clear="all"><div align="left"><font style="font-family:Verdana, Geneva, sans-serif; font-size:15px; color:black;">Please wait</font> <img src="http://bytes.com/images/loadings.gif" alt="Loading...." align="absmiddle" title="Loading...."/></div><br clear="all">'); }, success: function(response) { var response_brought = response.indexOf('registered_successfully=yes'); if (response_brought != -1) { $("#ad").html(''); window.location.replace(response); } else { $("#ad").fadeIn(1000).html(response); } } }); } } </script> <link href="css/PADPriceTag.css" rel="stylesheet" type="text/css" /> <script type="text/javascript"> </script> <div id="pageheader"> <title> Post your Apartment / Flat for Rent in Chennai, Free Ads Posting, Advertising your Rental Property oneasyroomrents Classifieds </title><meta name="keyword" content="
 Post your Apartment in Chennai, Post an Apartment in Chennai"><meta name="description" content="India s No.1 Classified Ads - Post Free Apartments / Flats Classified Ads for Apartments / Flats for Sale in Chennai, India. Post Your Apartments / Flats Ad on Sulekha.com and reach millions of Indians worldwide to get an exact audience."> </div> <style type="text/css"> #fsUploadProgress0 div { float: left; margin-right: 0px; padding: 0 5px; margin-bottom: 4px; width: 48px; } #fsUploadProgress0 .thumb-img { border: 1px solid #DDDDDD; height: 45px; overflow: hidden; text-align: center; padding: 0; } #upprogress div { float: left; margin-right: 10px; padding: 0 5px; margin-bottom: 4px; width: 48px; } #upprogress .thumb-img { border: 1px solid #DDDDDD; height: 48px; overflow: hidden; text-align: center; padding: 0; } .newimgwidth { float:left; width:90px; } </style> </head> <script src="js/jquery.tools.ui.min-1.2.7.js" type="text/javascript"></script> <link href="js/swfupload/Uploadprocess.css" rel="stylesheet" type="text/css"/> <script type="text/javascript" src="js/swfupload/combinedswfupload_admin1.js"></script> <script type="text/javascript" src="js/fileprogress_admin.js?v=1.6"></script> <script type="text/javascript" src="js/Jquery_fileupload_1.js"></script> <body> <div id="div_stimg_con" style="display: none;" class="stockimage"> <img src="" id="img_st" /></div> <div class="SUL_wrapper"> <div class="SUL_clear"> </div> <div class="SUL_header"> <div style="width: 9px; height: 20px; float: left;"> </div> <div class="SUL_tpbg"> <div class="SUL_dummy"> <div class="SUL_topL"> </div> <div class="SUL_topR"> </div> </div> </div> <div class="SUL_stripR"> </div> </div> <div class="clear"> </div> <div class="clear"> </div> <div class="main_head"> <input name="imgsource" type="hidden" id="imgsource" /> <input id="hdneditphotocount" type="hidden" name="hdneditphotocount" value="0" /> <div class="postAdSec"> <div class="createAd"> <h1 class="ftlt">Apartments / Flats Details </h1><span class="spanValidationTitle ftrt">( * Denotes mandatory fields )</span><div style="clear: both;"></div><span class="ruler"></span></div> <div class="postAdSec"> <div class="floatLeft" style="width:450px"> <p> City<span class="spanValidationStar">*</span>: </p> <div class="mobile-search"> <input type="text" name="city" id="city" value="chennai"> </div> <div class="clear"></div> <p> Locality<span class="spanValidationStar">*</span>: </p><input type="text" name="locality" id="locality"><div class="clear"></div><span class="nri marlft italic" id="spanLocality"></span><div class="clear"></div> <p> Area Name<span class="spanValidationStar">*</span>: </p><input type="text" name="areaname" value="" id="areaname"required><div class="clear"></div> <div id="div_StreetName" style="display:none;"><input id="txt_streetname" class="textBox wid200" type="text" maxlength="50" value="" name="txt_streetname"></div> <div class="clear"></div><span class="nri marlft italic">Street Address or Area.</span><div class="clear" required></div> <p> Apartment Name: </p><input type="text" name="apartmentname" id="apartmentname" value=""><div class="clear"></div><span class="nri marlft italic">Eg. DLF Garden City</span><div class="clear"></div> <p>Address:</p><input id="address" class="textBox wid200" type="text" maxlength="100" value="" name="address"><div class="clear"></div><span class="nri marlft italic">Eg.Old No: 34, New No: 56, Raja Apartment</span><div class="clear"></div> <p> Built up area<span class="spanValidationStar">*</span>: </p><input class="textBox wid110" name="builtuparea" id="builtuparea" value="" type="text" maxlength="9"> (in square feet)<div class="clear"></div> <p> Rent Type<span class="spanValidationStar">*</span>: </p><select class="listMenu buySell" name="renttype" id="renttype" style="width:213px;""><option value="rent">Rent</option> <option value="lease">Lease</option></select><div class="clear"></div> <div id="div_deposit"> <p><span id="DepositAmount" class="floatLeft">Deposit (in </span><span class="inrSymbol"></span><span class="floatLeft"> ) : </span></p><input class="textBox wid110" name="depositamount" id="depositamount" value="" type="text" maxlength="9" ><div class="clear"></div><span class="nri marlft italic depositntow" id="depositntow"></span><div class="clear"></div> </div> <p><span id="RentTitle" class="floatLeft">Monthly Rent (in </span><span class="inrSymbol"></span><span class="floatLeft"> )<span class="spanValidationStar">*</span>: </span></p><input class="textBox wid110" name="monthlyrent" id="monthlyrent" value="" type="text" maxlength="9"><div class="clear"></div><span class="nri marlft italic ntow" id="ntow"></span><div class="clear"></div> <p> Bedrooms<span class="spanValidationStar">*</span>: </p><select class="listMenu buySell" name="bedrooms" id="bedrooms" style="width:213px;" onchange="javascript:chkIsUserChanged();"><option value="">Select no. of bedrooms</option> <option value="1 HALL">1 HALL</option> <option value="1 RK">1 RK</option> <option value="2 RK">2 RK</option> <option value="1 BHK">1 BHK</option> <option value="2 BHK">2 BHK</option> <option value="3 BHK">3 BHK</option> <option value="4 BHK">4 BHK</option></select><div class="clear"></div> <p>Landmark :</p><input id="landmarks" class="textBox wid200" type="text" maxlength="50" value="" name="landmarks" "><div class="clear"></div> <p> Furnished<span class="spanValidationStar">*</span>: </p><select class="listMenu buySell" name="furnished" id="furnished" style="width:213px;" ><option value="">Select furnished</option> <option value="Fully furnished">Fully furnished</option> <option value="Semi furnished">Semi furnished</option> <option value="Unfurnished">Unfurnished</option></select><div class="clear"></div> <p> Floor No: </p><select class="listMenu buySell" name="floornumber" id="floornumber" style="width:213px;" ><option value="" selected>Select no.of floor</option> <option value="0">Ground floor</option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7">7</option> <option value="8">8</option> <option value="9">9</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> <option value="13">13</option> </select> </div> <div class="clear"></div> </div> <div id="signin"></div> <div class="clear"></div> <div class="createAd"> <h1>Ad Details</h1><span class="ruler"></span></div> <p> Ad Title<span class="spanValidationStar">*</span>: </p><input class="textBox wid383" name="adtitle" id="adtitle" value="" type="text"><span class="opt" style="margin-left:5px;"> Max 40 characters. <a class="stronG" style="display:none;"> See Examples<span class="linkArrow"></span></a></span><div class="clear"></div> <p> Ad Description<span class="spanValidationStar">*</span>: </p><textarea class="textBox wid383 hei122" name="addesc" id="addesc" rows="5" cols="75"></textarea><span class="opt wid170" style="margin-left:5px;"> Max 1000 characters. Do not include tags. Use regular text </span><div class="clear"></div> </div> <div class="createAd"> <h1 >Upload Photos</h1><span class="ruler"></span></div> <span ><span align="center">Upload Photo</span><input type="file" id="files" name="files[]" multiple></span><div class="imgFormat" style="margin:10px 0;font-size:12px;"> <span class="strong" align="center">Format</span> - JPG, GIF, BMP, JPEG,PNG </div> <div style="padding-left:350px;"><center> <a href="javascript:void(0);" onclick="ad_Post();" class="vpb_general_button">Continue</a></center></div> <div class="vpb_lebels_fields" align="left" id="ad"></div><br clear="all"> </div> </body> </html>
save_ad.php
Code:<?php session_start(); include "db.php"; if(isset($_POST["page"]) && !empty($_POST["page"])) { //Sign-up Page Starts here if($_POST["page"] == "adpost") { $city = trim(strip_tags($_POST['city'])); $locality = trim(strip_tags($_POST['locality'])); $areaname = trim(strip_tags($_POST['areaname'])); $apartmentname = trim(strip_tags($_POST['apartmentname'])); $address = trim(strip_tags($_POST['address'])); $builtuparea = trim(strip_tags($_POST['builtuparea'])); //$builtupareatype = trim(strip_tags($_POST['builtupareatype'])); $renttype = trim(strip_tags($_POST['renttype'])); $depositamount = trim(strip_tags($_POST['depositamount'])); $monthlyrent = trim(strip_tags($_POST['monthlyrent'])); $bedrooms = trim(strip_tags($_POST['bedrooms'])); $landmarks = trim(strip_tags($_POST['landmarks'])); $furnished = trim(strip_tags($_POST['furnished'])); $floornumber = trim(strip_tags($_POST['floornumber'])); $adtitle = trim(strip_tags($_POST['adtitle'])); $addesc = trim(strip_tags($_POST['addesc'])); $adphotos = trim(strip_tags($_POST['adphotos'])); //||$address == "" || $builtuparea == "" || $renttype == ""||$depositamount == "" || $monthlyrent == "" || $bedrooms == "" || $landmarks == ""||$furnished == "" || $floornumber == "" || $adtitle == "" || $addesc == ""||$adphotos="" // //,address,builtuparea,renttype,depositamount,monthlyrent,bedrooms,landmarks,furnished,floornumber,adtitle,addesc,adphotos,builtupareatype // if($city == "" || $locality == ""|| $areaname == ""||$apartmentname=""||$address="") // { // echo '<br><div class="info">Sorry, all fields are required to save. Thanks.</div><br>'; // } // else // { if(mysql_query("insert into `post_info` (city,locality,areaname,apartmentname,address,builtuparea,renttype,depositamount,monthlyrent,bedrooms,landmarks,furnished,floornumber,adtitle,addesc)values( '".mysql_real_escape_string($city)."', '".mysql_real_escape_string($locality)."','".mysql_real_escape_string($areaname)."','".mysql_real_escape_string($apartmentname)."','".mysql_real_escape_string($address)."','".mysql_real_escape_string($builtuparea)."','".mysql_real_escape_string($renttype)."','".mysql_real_escape_string($depositamount)."','".mysql_real_escape_string($monthlyrent)."','".mysql_real_escape_string($bedrooms)."','".mysql_real_escape_string($landmarks)."','".mysql_real_escape_string($furnished)."','".mysql_real_escape_string($floornumber)."','".mysql_real_escape_string($adtitle)."','".mysql_real_escape_string($addesc)."')")) { // echo $locality; echo 'Package.php?'; echo 'registered_successfully=yes'; } // else // { // echo '<br><div class="info">Sorry, your account could not be processed at the moment. Please try again or contact the site admin to report this error if the problem persist. Thanks.</div><br>'; } } //} ?> -
What is your question?
What part of the code is not doing what you expect?
What errors/warnings are you receiving?Comment
-
that requires some kind of loop on the PHP side.save multiple images into database table.Comment
Comment