|
how to upload an image and store its path in my sql using php?
|
|
|
|
|
Hereafter use this forum[^] to post php & mysql related questions.
And did you search Google to get answer?
thatrajaCode converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
|
|
|
|
|
yes i am trying .i followed w3schools.but I observed most people save image name in database not the image can you guide me if we will save a image name in database than how will we retrieve those images?
|
|
|
|
|
Two ways.
0) File system - Store image location in database, image in server. Later, load image from server using the path stored in database.
1) Database - Store image as blob in database. Later, load blob as image in page.
Check the advantages & disadvantages of these two ways here. Clickety[^]
Here tons of resources for you
https://www.google.com/search?q=php+save+retrieve+image+database[^]
thatrajaCode converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
|
|
|
|
|
I didn't understood it.
Are you expecting someone to come forward and teach you over this forum (or over the proper forum) about PHP, MySQL and what in-between?
It's unlikely to happen - you are in a site for those who code, not for those who not...Until know you are not!
If you have a task, first learn, than make an attempt, than come to us here - with! your attempt...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
How to control the menus using jscript or jquery ?
Am new to this web development domain.
this is my index.html file which contains menu contents
<html>
<head>
<link rel="stylesheet" type="text/css" href="menus.css" />
</head>
<body>
<div class="example">
<div class="menuholder">
<ul class="menu slide">
<li><a href="" class="pattern">Kitchen</a>
<div class="subs">
<dl class="even">
<dt>STORAGE</dt>
<dd><a href="">Airtight Storage</a></dd>
<dd><a href="">Lock Storage</a></dd>
<dd><a href="">Microwavable Storage</a></dd>
<dd><a href="">Canisters & Jars</a></dd>
<dt>COOKWARE</dt>
<dd><a href="">Cookware Sets</a></dd>
<dd><a href="">Pressure Cookers</a></dd>
<dd><a href="">Frying Pans & Woks</a></dd>
<dd><a href="">Pots & Sauce Pans</a></dd>
</dl>
<dl class="odd">
<dt>SERVEWARE</dt>
<dd><a href="">Dishes & Bowls</a></dd>
<dd><a href="">Casseroles</a></dd>
<dd><a href="">Cutlery</a></dd>
<dd><a href="">Plates, Trays & Platters</a></dd>
</dl>
<dl class="even">
<dt>GLASS SETS</dt>
<dd><a href="">Everyday Glasses</a></dd>
<dd><a href="">Bar Glasses</a></dd>
<dd><a href="">Tumblers</a></dd>
<dd><a href="">Bone China</a></dd>
<dd><a href="">Melamine</a></dd>
<dd><a href="">Stainless Steel</a></dd>
</dl>
<dl class="odd">
</dl>
<dl class="even">
</dl>
<dl class="odd">
</dl>
<dl class="even-last">
<dt>GLASS SETS</dt>
</dl>
</div>
</li>
<li><a href="" class="pattern">Office Furniture</a>
<div class="subs">
<dl class="even">
<dt>CHAIRS</dt>
<dd><a href="">Ergonomic Chairs</a></dd>
<dd><a href="">Executive Chairs</a></dd>
<dd><a href="">Folding Chairs</a></dd>
</dl>
<dl class="odd">
<dt>DESKS</dt>
<dd><a href="">Workstations</a></dd>
<dd><a href="">Executive Tables</a></dd>
<dd><a href="">Computer Tables</a></dd>
<dd><a href="">Study & Laptop Tables</a></dd>
<dd><a href="">Conference Tables</a></dd>
</dl>
<dl class="even">
<dt> RECEPTION SEATING</dt>
<dd><a href="">Sofas</a></dd>
<dd><a href="">Ottomans</a></dd>
<dd><a href="">Visitor Chairs</a></dd>
</dl>
<dl class="odd">
</dl>
<dl class="even">
</dl>
<dl class="odd">
</dl>
<dl class="even-last">
<dt></dt>
</dl>
</div>
</li>
<li><a href="" class="pattern">Furnishings</a>
<div class="subs">
<dl class="even">
<dt>BED SHEETS</dt>
<dd><a href="">Double Bed</a></dd>
<dd><a href="">Single Bed</a></dd>
<dd><a href="">Combo Offers</a></dd>
<dd><a href="">Kids Bed Sheets</a></dd>
</dl>
<dl class="odd">
<dt>CURTAINS</dt>
<dd><a href="">Door Curtains</a></dd>
<dd><a href="">Window Curtains</a></dd>
<dd><a href="">Shower Curtains</a></dd>
<dd><a href="">Kids Curtains</a></dd>
</dl>
<dl class="even">
<dt>RUGS & CARPETS</dt>
<dd><a href="">Area Rugs</a></dd>
<dd><a href="">Carpets</a></dd>
<dd><a href="">Dhurries & Runners</a></dd>
</dl>
<dl class="odd">
<dt><a href=""><img src="images/decor_hover_image.jpg" height="100" width="130" /></a> </dt>
</dl>
<dl class="even">
</dl>
<dl class="odd">
</dl>
<dl class="even-last">
<dt></dt>
</dl>
</div>
</li>
<li><a href="" class="pattern">Home Furniture</a>
<div class="subs">
<dl class="even">
<dt>BED SHEETS</dt>
<dd><a href="">Double Bed</a></dd>
<dd><a href="">Single Bed</a></dd>
<dd><a href="">Combo Offers</a></dd>
<dd><a href="">Kids Bed Sheets</a></dd>
</dl>
<dl class="odd">
<dt>CURTAINS</dt>
<dd><a href="">Door Curtains</a></dd>
<dd><a href="">Window Curtains</a></dd>
<dd><a href="">Shower Curtains</a></dd>
<dd><a href="">Kids Curtains</a></dd>
</dl>
<dl class="even">
<dt>RUGS & CARPETS</dt>
<dd><a href="">Area Rugs</a></dd>
<dd><a href="">Carpets</a></dd>
<dd><a href="">Dhurries & Runners</a></dd>
</dl>
<dl class="odd">
<dt><a href=""><img src="images/decor_hover_image.jpg" height="100" width="130" /></a> </dt>
</dl>
<dl class="even">
</dl>
<dl class="odd menuadvertise-twocol">
<dt><a href=""><img src="images/menu-advertise/1.jpg" height="200" width="253" /></a> </dt>
</dl>
</div>
</li>
<li><a href="" class="pattern">Decor</a>
<div class="subs">
<dl class="even">
</dl>
<dl class="odd menuadvertise-twocol">
<dt><a href=""><img src="images/menu-advertise/1.jpg" height="200" width="253" /></a> </dt>
</dl>
<dl class="even">
<dt>RUGS & CARPETS</dt>
<dd><a href="">Area Rugs</a></dd>
<dd><a href="">Carpets</a></dd>
<dd><a href="">Dhurries & Runners</a></dd>
</dl>
<dl class="odd">
<dt><a href=""><img src="images/decor_hover_image.jpg" height="100" width="130" /></a> </dt>
</dl>
<dl class="even">
<dt>BED SHEETS</dt>
<dd><a href="">Double Bed</a></dd>
<dd><a href="">Single Bed</a></dd>
<dd><a href="">Combo Offers</a></dd>
<dd><a href="">Kids Bed Sheets</a></dd>
</dl>
<dl class="odd">
<dt>CURTAINS</dt>
<dd><a href="">Door Curtains</a></dd>
<dd><a href="">Window Curtains</a></dd>
<dd><a href="">Shower Curtains</a></dd>
<dd><a href="">Kids Curtains</a></dd>
</dl>
</div>
</li>
<li><a href="" class="pattern">Appliances</a></li>
<li><a href="" class="pattern">Pets</a></li>
<li><a href="" class="pattern">Housekeeping</a></li>
<li><a href="" class="pattern">Gourmet</a></li>
<li><a href="" class="pattern">Bath</a></li>
<li><a href="" class="pattern">Personal Care</a></li>
</ul>
<div class="hr-line" style="margin-top:30px;"></div>
<div class="back"></div>
<div class="shadow"></div>
</div>
<div style="clear:both"></div>
</div>
</body>
</html>
this is my menus.css file
@charset "utf-8";
.example {
position:absolute;
width:960px;;
margin:0 auto;
border-radius:3px;
-moz-border-radius:3px;
-webkit-border-radius:3px;
}
.menuholder {
float:left;
overflow:hidden;
position:relative;
width:100%;
font-family: Arial;
font-size:12px;
}
.menuholder .shadow {
-moz-box-shadow:0 0 20px rgba(0, 0, 0, 1);
-o-box-shadow:0 0 20px rgba(0, 0, 0, 1);
-webkit-box-shadow:0 0 20px rgba(0, 0, 0, 1);
background:#888;
box-shadow:0 0 20px rgba(0, 0, 0, 1);
height:7px;
position:absolute;
top:-9px;
width:960px;
z-index:100;
}
.menuholder .back {
-moz-transition-duration:.4s;
-o-transition-duration:.4s;
-webkit-transition-duration:.4s;
background-color:#ffffff;
}
.menuholder:hover div.back
{
height:220px;
margin-top: -8px;
border: 1px solid #E3E3E3;
border-top: none;
-moz-box-shadow: 0 2px 4px #252525;
-webkit-box-shadow: 0 2px 4px #252525;
box-shadow: 0 3px 2px 0 #252525;
padding-left:5px;
}
ul.menu {
display: block;
float: left;
list-style: none;
margin: 0% 0% 0% -3%;
width: 100%;
}
ul.menu li {
float:left;
margin:7px 27.2px 0 0;
}
ul.menu li > a {
-webkit-border-bottom-left-radius: 10px;
-webkit-border-bottom-right-radius: 10px;
-webkit-transition: all 0.2s ease-in-out;
border-radius: 0 0 10px 10px;
;
display: table-row;
padding: 0 10px;
text-decoration: none;
transition: all 0.2s ease-in-out;
color: #1D4D7D;
font-family: Arial;
font-size: 12px;
font-weight: bold;
}
ul.menu li a.pattern {
}
ul.menu li a.red {
background:#a00;
}
ul.menu li a.orange {
background:#da0;
}
ul.menu li a.yellow {
background:#aa0;
}
ul.menu li a.green {
background:#060;
}
ul.menu li a.blue {
background:#00a;
}
ul.menu li a.violet {
background:#682bc2;
}
.menu li div.subs {
left: 0;
overflow: hidden;
position: absolute;
width: 0;
margin-top: -1px;
}
.menu li div.subs dl {
-moz-transition-duration:.2s;
-o-transition-duration:.2s;
-webkit-transition-duration:.2s;
float:left;
margin:0 130px 0 0;
overflow:hidden;
padding:10px 0 0% 0%;
width:0;
}
.menu dt {
color: #000;
font-family: arial, sans-serif;
line-height: 15px;
margin: 0;
padding: 7px 0 0px 5px;
white-space: nowrap;
}
.menu dd {
margin:0;
padding:0;
text-align:left;
font-family:Verdana, Geneva, sans-serif;
line-height:5px;
width: 135px;
margin-left: 6px;
}
.menu dd a {
background:transparent;
color:#9DA1AB;
font-size:12px;
line-height:18px;
padding: 0 0 0 4px;
text-align:left;
white-space:nowrap;
width:80px;
text-decoration: none;
font-family: Arial;
font-weight: normal;
}
.menu dd a:hover {
color:#090A0A;
}
.menu li:hover div.subs dl {
-moz-transition-delay:0.2s;
-o-transition-delay:0.2s;
-webkit-transition-delay:0.2s;
margin:11px 0px 1px 3px;
padding:0px 0px 0px 0px;
width:133.7px;
height:215px;
}
.menu li:hover div.subs dl.menuadvertise-twocol
{
-moz-transition-delay:0.2s;
-o-transition-delay:0.2s;
-webkit-transition-delay:0.2s;
margin:17px 0px 1px 3px;
padding:0px 0px 0px 0px;
height:215px;
width:265px;
}
.even
{
background-color:#FAFBFC;
}
.even-last
{
background-color:#FAFBFC;
width:148px;
}
.odd
{
background-color:white;
}
ul.menu li:hover > a,ul.menu li > a:hover {
}
ul.menu li a.red:hover,ul.menu li:hover a.red {
background:#c00;
}
ul.menu li a.orange:hover,ul.menu li:hover a.orange {
background:#fc0;
}
ul.menu li a.yellow:hover,ul.menu li:hover a.yellow {
background:#cc0;
}
ul.menu li a.green:hover,ul.menu li:hover a.green {
background:#080;
}
ul.menu li a.blue:hover,ul.menu li:hover a.blue {
background:#00c;
}
ul.menu li a.violet:hover,ul.menu li:hover a.violet {
background:#8a2be2;
}
ul.menu li a.pattern:hover,ul.menu li:hover a.pattern {
text-decoration:underline;
}
.menu li:hover div.subs,.menu li a:hover div.subs {
width: 957px;
}
In above menus style, i have to control number of sub-categories adding in category.The height of the sub menus is fixed, so that if sub categories is more it sholud move to next column.
For above problem i need jscript. please any one can hepl me 
Harish
|
|
|
|
|
I have a normal HTML/CSS w/some JScript thrown-in webpage, with > 50 individual blog pages that are indexed from the main index.html file.
On my wishlist are two things:
-would like to add a Search Box. Not one that depends on an external search engine. I want to roll my own, so to speak. I want to have all my pages accessible - so that I can search through the pages and then display the results to a user after a search. I'm thinking that the pages need to be put into a database for this(?)
-Would like to add a 'prev' and a 'next' function to the bottom of each sub-webpage. The user should not always have to navigate back to the index to see another page. Would like one function that takes an argument - prev or next. Or two separate functions are ok. What I want to avoid is having to hardcode "num of next page", and "num of prev page" on every subpage. Can be very error-prone.
What language(s), DBs would be best for this? I worked as a professional programmer in the past, so complexity of code is not a problem.
A language that works good with a DB (if needed), and one where the functions work in Windows and in Linux is important. Also, a great debugger is paramount, as I anticipate using it a lot when first starting out.
Take Care
God Bless... Feedscrn
+--------------------------------+
| The screen is hungry, Feed It! |
+--------------------------------+
|
|
|
|
|
Consider using a pre-developed blog engine.
This is a classic situation of build vs buy.
However, there are some nice open-source solutions out there.
A quick search pulled up the following:
http://www.dotnetblogengine.net/[^]
|
|
|
|
|
Yes, it looks nice. 
Interested in honing my web programming skills at this point. And I have the time.
The thing is, most of the blog is already built and working. I just want to add a couple of features to it.
Take Care
God Bless... Feedscrn
+--------------------------------+
| The screen is hungry, Feed It! |
+--------------------------------+
|
|
|
|
|
SELECT ord.orderid,cus.custid,cus.custname,cat.catid,cat.catname,pro.proid,pro.proname from `order` as ord inner join`customer` as cus on cus.custid=ord.custid inner join `category` as cat on cat.catid=ord.catid inner join `product` as pro on pro.proid=ord.proid
there is no error in this query bt still it select no record i dnt know y
|
|
|
|
|
If no error & no data again your query, there's no matching records for your query(criterias).
You have to check the query on all ways.
First with out any criteria/JOINs ( SELECT * FROM Table )
And add a criteria/JOIN ( SELECT * FROM Table WHERE Column1 = 'Value1' )
And add ...... ( SELECT * FROM Table WHERE Column1 = 'Value1' AND Column2 = 'Value2' )
Try it yourself.
thatrajaCode converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
|
|
|
|
|
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order set custid='4',catid='1', proid='2',quantity='14',totalbill='1400', ' at line 1]
insert into order set custid='$custid',catid='$catid',
proid='$proid',quantity='$quantity',totalbill='$totalbill',
deldate='$var_date',orderstatus='$orderstatus
kindly explain me this error
|
|
|
|
|
Your query is wrong. For your requirement, you should use UPDATE statement but you're using INSERT. And there's a single quote (') missing at end of the query.
insert into UPDATE order set custid='$custid',catid='$catid',
proid='$proid',quantity='$quantity',totalbill='$totalbill',
deldate='$var_date',orderstatus='$orderstatus'
Probably you should learn MySQL very well before doing project works. Here more than couple of ways to learn anything in Internet. Education Needed[^]
thatrajaCode converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
|
|
|
|
|
i am a biggner in PHP.can someone recommend me best sites for php learning???Kindly do reply
|
|
|
|
|
|
|
Started by learning the Language like ASP, PHP,Node.js etc
I suggest you PHP or Node.js[^]
Freelance makes perfect | http://codetrash.com
|
|
|
|
|
You replied to wrong message
thatrajaCode converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
|
|
|
|
|
SELECT ord.orderid,cus.custid,cus.custname,cat.catid,cat.catname,pro.proid,pro.proname from 'order' as ord inner join 'customer' as cus on cus.custid=ord.custid inner join 'category' as cat on cat.catid=ord.catid inner join 'product' as pro on pro.proid=ord.proid
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''order' as ord inner join 'customer' as cus on cus.custid=ord.custid inner join' at line 1
|
|
|
|
|
you cannot use 'order' as table name as it is a reserved word in mysql. But you can try using backticks ` to enclose it like these `order`, the backtick can be found on the top left hand side of your 101 keyboard. Do the same for the other tables.
|
|
|
|
|
thank u so mch
|
|
|
|
|
SELECT ord.orderid,cus.custid,cus.custname,cat.catid,cat.catname,pro.proid,pro.proname from 'order' as ord inner join 'customer' as cus on cus.custid=ord.custid inner join 'category' as cat on cat.catid=ord.catid inner join 'product' as pro on pro.proid=ord.proid
kindly reply where i am wrong
|
|
|
|
|
Don't repost questions.
Don't bump questions frequently, that's annoying. Wait for the answers.
thatrajaCode converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
|
|
|
|
|
ok actually its my first time to use sch type of site.Its really a good site.Nd actually I was in trouble thats why i asked question.But Sorry if you fell annoyed .Next time I will avoid it.
|
|
|
|
|
zunisheikh wrote: ok actually its my first time to use sch type of site.
But your profile page says 1 year old member. Anyway hereafter avoid reposts. I think we have answered all of your questions.
thatrajaCode converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
