Web Development Discussion Boards

Re: PHP

thatraja4-Mar-14 21:07

thatraja

4-Mar-14 21:07

Hereafter use this forum[^] to post php & mysql related questions.

And did you search Google to get answer?

thatraja

Code 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

Re: PHP

zunisheikh4-Mar-14 23:06

zunisheikh

4-Mar-14 23:06

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?

Re: PHP

thatraja4-Mar-14 23:19

thatraja

4-Mar-14 23:19

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[^]

thatraja

Re: PHP

Kornfeld Eliyahu Peter4-Mar-14 21:28

Kornfeld Eliyahu Peter

4-Mar-14 21:28

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)

Controling Menus using Java Script

harishm5913-Mar-14 21:12

harishm591

3-Mar-14 21:12

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

XML

<html>
<head>
<!-- Menus Style Sheet -->
        <link rel="stylesheet" type="text/css" href="menus.css" />
    <!-- End Menus Style Sheet -->
</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>
                   <!-- <dl class="even-last">
                    <dt></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>
                   <!-- <dl class="even-last">
                    <dt></dt>
                    </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>

<!-- End of Menu Section -->


</body>
</html>

this is my menus.css file

CSS

@charset "utf-8";
/* CSS Document */

.example {
     position:absolute;
   /* background:#fff url(../images/background.jpg); */
    width:960px;;
    margin:0 auto;
   /* border:1px #b20 solid;*/
    /*margin:20px auto;*/
        border-radius:3px;
    -moz-border-radius:3px;
    -webkit-border-radius:3px;
}

/* main menu styles */
.menuholder {
    float:left;
    /*font:normal bold 11px/35px verdana, sans-serif;*/
    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;

  /*  width:100%;*/
    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 {
    /*-moz-border-radius:0 0 10px 10px;
    -moz-box-shadow:2px 2px 4px rgba(0, 0, 0, 0.9);
    -moz-transition:all 0.2s ease-in-out;
    -o-border-radius:0 0 10px 10px;
    -o-box-shadow:2px 2px 4px rgba(0, 0, 0, 0.9);
    -o-transition:all 0.2s ease-in-out;*/
    -webkit-border-bottom-left-radius: 10px;
    -webkit-border-bottom-right-radius: 10px;
    /*-webkit-box-shadow: 2px 2px 4px rgba(0, 0, 0, 0.9);*/
    -webkit-transition: all 0.2s ease-in-out;
    border-radius: 0 0 10px 10px;
    /*box-shadow: 2px 2px 4px rgba(0, 0, 0, 0.9)*/;
    /*color: #0839A3;*/
    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 {
    /*background:#572C15;*/
}

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%;  /* Sub Menus height */
    width:0;
}



.menu dt {
     color: #000;
    font-family: arial, sans-serif;
    /*font-size: 12px;
    font-weight: 700;
    height: 12px;*/
    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;
    /*border: 1px solid;*/
}
.menu dd a {
    background:transparent;
    color:#9DA1AB;
    font-size:12px;
    /*height:20px;*/
    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;
    /*border:1px solid;*/
}

.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;
    /*border:1px solid;*/
    width:265px;
}

.even
{
     background-color:#FAFBFC;
    /*background-color:#FFFCFD;*/
}
.even-last
{
     background-color:#FAFBFC;
     width:148px;
    /*background-color:#FFFCFD;*/
}
.odd
{
     background-color:white;
    /*background-color:#FFFCFD;*/
}
ul.menu li:hover > a,ul.menu li > a:hover {
    /*background:#aaa;
    color:#fff;
    padding:10px 10px 0;*/
}
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 {
/*background:#5D2F16;*/
text-decoration:underline;
}

.menu li:hover div.subs,.menu li a:hover div.subs {
    width: 957px;
    /*border: 1px solid;*/

}

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 D'Oh! | :doh:

Harish

Web programming, again.

FeedScrn2-Mar-14 14:08

FeedScrn

2-Mar-14 14:08

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! |
+--------------------------------+

Re: Web programming, again.

David Mujica3-Mar-14 4:00

David Mujica

3-Mar-14 4:00

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/[^]

Re: Web programming, again.

FeedScrn3-Mar-14 4:42

FeedScrn

3-Mar-14 4:42

Yes, it looks nice. Smile | :)

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! |
+--------------------------------+

PHP

zunisheikh2-Mar-14 8:23

zunisheikh

2-Mar-14 8:23

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 Frown | :(

Re: PHP

thatraja2-Mar-14 20:18

thatraja

2-Mar-14 20:18

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.

thatraja

PHP

zunisheikh2-Mar-14 6:02

zunisheikh

2-Mar-14 6:02

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

Re: PHP

thatraja2-Mar-14 20:22

thatraja

2-Mar-14 20:22

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.

SQL

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[^]

thatraja

PHP

zunisheikh2-Mar-14 5:06

zunisheikh

2-Mar-14 5:06

i am a biggner in PHP.can someone recommend me best sites for php learning???Kindly do reply

Re: PHP

Peter Leow2-Mar-14 5:28

Peter Leow

2-Mar-14 5:28

www.w3schools.php5-tutorials[^]

Re: PHP

thatraja2-Mar-14 20:27

thatraja

2-Mar-14 20:27

Here more than couple of ways to learn anything in Internet. Education Needed[^]. Using Google, I got this site, http://www.learnphp-tutorial.com/[^]

thatraja

Re: PHP

stevic9-Apr-14 7:16

stevic

9-Apr-14 7:16

Started by learning the Language like ASP, PHP,Node.js etc

I suggest you PHP or Node.js[^]

Freelance makes perfect | http://codetrash.com

Re: PHP

thatraja9-Apr-14 7:22

thatraja

9-Apr-14 7:22

You replied to wrong message

thatraja

how to use join query to merge order,customer,category and product table?

zunisheikh2-Mar-14 5:04

zunisheikh

2-Mar-14 5:04

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

Re: how to use join query to merge order,customer,category and product table?

Peter Leow2-Mar-14 5:36

Peter Leow

2-Mar-14 5:36

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.

Re: how to use join query to merge order,customer,category and product table?

zunisheikh2-Mar-14 5:58

zunisheikh

2-Mar-14 5:58

thank u so mch Smile | :)

how to use join query to merge order,customer,category and product table?

zunisheikh2-Mar-14 4:57

zunisheikh

2-Mar-14 4:57

Re: how to use join query to merge order,customer,category and product table?

thatraja2-Mar-14 20:12

thatraja

2-Mar-14 20:12

Don't repost questions.

Don't bump questions frequently, that's annoying. Wait for the answers.

thatraja

Re: how to use join query to merge order,customer,category and product table?

zunisheikh2-Mar-14 22:18

zunisheikh

2-Mar-14 22:18

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.

Re: how to use join query to merge order,customer,category and product table?

thatraja2-Mar-14 22:27

thatraja

2-Mar-14 22:27

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.

thatraja

Routing at the iis level

Keith Barrow26-Feb-14 23:05

Keith Barrow

26-Feb-14 23:05

Hi,

I can't for the life of me find the correct incantation. Basically, for migration purposes we've created a subdomain i.e.:

www.whatever.com <-- outgoing classic asp site
www.whatever.com\new <-- new MVC site.

We're sitting on IIS7, I want to be able to serve up www.whatever.com\robots.txt with whatever is the result of www.whatever.com\new\robots.txt. I want this to be transparent (i.e not an HTTP re-direct, just serve up) and I don't want to use the file system as we'll be genning the files dynamically in MVC. I can only seem to get the redirect module to re-direct.

Thanks for you help.

PB 369,783 wrote:
I just find him very unlikeable, and I think the way he looks like a prettier version of his Mum is very disturbing.[^]

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.