[ad_1]
This is a review of what you have been taught. I show you how to populate drop down boxes with database information based off of user interaction. Many PHP and SQL techniques are covered. The code is here :
Web Design and Programming Pt 19
by
Tags:
Comments
27 responses to “Web Design and Programming Pt 19”
-
Love your videos, I'm curious on how to insert an array into a database I think. Like if I have an order form setup that inputs into a database with ordered_by, job, date_required, quantity and description of order, but there would be any number of quantities and descriptions on the same order, thank you for all your work.
-
Hi Derek Banas
I tried to run the script, but I there is nothing show in each Select bar when you click it. I checked the database connection, everything is fine. I can not find the problem.
-
Is there someplace I can find the database creation files, so I don't have to manually track down everything?
-
when I select the item in the first dropdown, it reloads and shows the item. However it then reloads and rubs it off. It relods twice
-
I GOT IT WORKING AND THE CODE IS WELL FORMATTED AND COMMENTED!
The problem was as I said — finding and replacing the " " and ' ' line by line and recompiling because sometimes its not needed to replace. one little wrong " " or ' ' in the wrong place and even though it compiles, the sql is never made or page never refreshed. So I took the code from scratch and went line by line to make it look like my formatted code. And it works great now! Now I know how to make something similar for a much more complex DB; just got to learn how to write more complex SQLs. Thank you so much for this video. And as you said before it is the little thing that corrupts the system.
-
I found a way to copy your code the way it looks like. i went trough it line by line and ran it. found the " " and ' ' and changed it to mine. when there was and escape " I left it as is but somehow when it said value=" there was only one " so i changed it to ' ' . it worked the way as expected changing the next drop down to only relevant data. this code is badly formatted not like mine and i still can't see which "" ' ' to changed since it compiles! i guess i have to start formatting your code to look like mine.
-
copied code exactly from your site and it doesn't work. i alway get the same stuff showing up in all boxes no matter what i select in the other ones no matter which order. and when i click submit it says can't fine missing confirm.php file
-
i fixed all the " " and ' ' but it still failed. where is the confirm.php file and the hamtest.php file. those are needed for the program to run, no?
-
the code is using some confirm.php. where is this code. also when i copied the code it has diff " " and ' '. I think I mentioned this before, so I have to look and replace for them by hand. the automatic search and replace messed things up.
-
i managed to load the data from the dump file into mysql. took me a long time because of proper dir notation and it seemed my sql didn't like the single quote for the name of the db. also what are all those strange command that follow — ?
anyways, it worked but looking at the users table it seems you break pretty much all of the rules you told us not to break? are you going to re-do this table? did you like my ideas about how to normalize the cities without using a lookup table for state id? what about my idea for a lookup table for phone types?
anyways, i hope to understand your code here as it is already very complex
-
didn't get the part about the cgi-bin folder–do this or don't this.
if do this, what exactly needs to be done? -
i still don't understand why you needed the javascript, why couldn't php do that?
-
when i copy the code from your site it gets pasted in my text wrangler as one line.
-
You're very welcome 🙂 I hope to get a chance to improve on the php tutorials soon
-
fantastic tutorial. It took a while but once I figured it out I had learned a great deal.
I did not understand the following comment. ""This line is added to take care if your global variable is off"". Thanks and please keep the tutorials coming. -
On occasion in the past I would improve the code on the site. I don't do that anymore. The code on the site is the way to go
-
@powerhousephg No problem
-
@powerhousephg I just uploaded the SQL for the database. Go to Web Design and Programming Pt 19 on my site and you'll see the link to the database dumpfile. I hope that helps
-
@darksideaudio08 Thanks a bunch 🙂
-
@dcharlequin I sent it to you in a message. Hope it helps, but it hasn't been secured
-
@derekbanas I am a student and I understand database quite good.
I am somewhat new to php, yet not totally lost.
If possible would you please reply with the code for the "confirm.php" page?
Thanks
-
@dcharlequin Confirm is just a page that grabs the product page based off of the 3 options picked. It doesn't work without the database. Hope that makes sense? Everything else is on my newthinktank site
-
where is the code for "confirm.php" ?
-
@dhruvownege Yes I'm going to do that. Just haven't made it yet. Also working on a huge php security tutorial that is holding me up. Happy new year!
-
@derekbanas no on the video itself, where is says "derekbanas" you can put a banner there and such since your a partner.
-
@dhruvownege Who has the best on YouTube? So many channels are boring looking.
-
you should make a video banner, or something next to your SUBSCRIBE button
Leave a Reply