i want to upload and save multiple images into database table.
3  1143 
my coding AdDetails.php
- <?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 - <?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>';
-
}
-
}
-
//}
-
-
-
-
?>
RonB 589
Expert Mod 512MB
What is your question?
What part of the code is not doing what you expect?
What errors/warnings are you receiving?
save multiple images into database table.
that requires some kind of loop on the PHP side.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Cedric |
last post by:
Hello all,
I have a question concerning ACCESS. Here is my situation.
I would like to have differents persons inputing information, via
imput forms probably, into one unique table.
My...
|
by: gyap88 |
last post by:
I need to save images in png format into sql server database table from my documents. I have already created a column with image being the data type. I tried to copy the image from the directory but...
|
by: chinni1 |
last post by:
Hi ,
I want to retrive the xml data into my database table.
The xml file is from outside of application.so i want to retrive that xml data into database with in some temporary table
...
|
by: SEhtesham |
last post by:
Hi,
I have my application in VS2008 and coded Vb.net.
My query is i want to save record from an excel sheet to my Database Table.
But i dont want to insert the Excel sheet as a whole...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| | |
