Dreamweaver Tut That Teaches U, to search a database with phpmysql

Language: English

Format: read online!

Category: Tutorial


Posted on 2007-05-18, updated at 2007-05-27. By anonymous.

Description

Ok, this should work...First of all, there is one great extension for DW & PHP ADODB object model that is free and great! Download it and install from www.interakt.ro its called PHAKT (NOT impakt, because its not free)
Install it and you will have another type of PHP ADODB document type
Start project with PHP ADODB (not old PHP MySQL)
Page 1
Create form that has one Editbox and one button.
Name Edit box smething like e.g. "search" without quotes.
That form should have form action="results.php" and type set to POST
Not, create Page 2 and name it results.php. Create new recordset in dw
like this
SELECT *
FROM table
WHERE table.colum.you.r.searching LIKE '%colname%' OR table.other.column LIKE '%colname%' ORDER BY table.tableid
this means that we want to select ALL (*) records in table WHERE content of column is similar (Dav, will return Dave, David, Davidof...) to search keyword.
Next, in variables click + and add variable name colname default value set to % if you want to show all records if form is submited blank, or -1 if You want to show none if form is submited blank. Finaly for Run-time value type $HTTP_POST_VARS['search'] Runtime value is equal name of Edit box name you set up in first page...
Now, from bindings tab, select values and insert it on page, that You would like to show on page. Ill skip this part assuming You know how to format output and how to limit it but if you dont know ask in reply...
So now You have page with results. Test it and see if its working.
If it is, create page 3 and name it details.php. Now, select value from page that you want to link with details page and click on link. Select details.php page and click on parameters. For param name enter something like id since this should be PK in table and unique value, and for value click on lightning icon, and select primary key in your table. In live page link should be like details.php?id=.
As for details page recordset it should look like
SELECT *
FROM table
WHERE table.id = 'colname'
create vars as for page 2, but change Runtime to $HTTP_GET_VARS['id']
and format output on page. That should be it, but since im typing it in "realtime" maby i forgot something...
Home I did helped You

Sponsored High Speed Downloads
6715 dl's @ 2306 KB/s
Download Now [Full Version]
9079 dl's @ 2425 KB/s
Download Link 1 - Fast Download
7795 dl's @ 2458 KB/s
Download Mirror - Direct Download



Search More...
Dreamweaver Tut That Teaches U, to search a database with phpmysql

Search free ebooks in ebookee.com!


Links
Download this book

No active download links here?
Please check the description for download links if any or do a search to find alternative books.


Related Books

  1. Ebooks list page : 130
  2. 2022-03-23The Dip A Little Book That Teaches You When to Quit (and When to Stick) (Audiobook)
  3. 2021-12-24Day Trading for Beginners The ultimate Guide that teaches the Strategies to make a living trading Stocks [Audiobook]
  4. 2021-12-17The Dip: A Little Book That Teaches You When to Quit (and When to Stick) (Audiobook)
  5. 2021-08-15EXCEL 2021 ALL-IN-ONE The Complete Beginner to professional Guide That Teaches the Basics You Need to Know
  6. 2021-04-02EXCEL 2020 FOR BEGINNERS: THE COMPLETE DUMMY TO EXPERT ILLUSTRATIVE GUIDE WITH EXAMPLES THAT TEACHES EVERYTHING
  7. 2020-11-23Excel 365 For Beginners 2020: The Complete Beginner to Expert Guide That Teaches Everything You Need to Know
  8. 2018-11-15The i5 Approach Lesson Planning That Teaches Thinking and Fosters Innovation
  9. 2018-10-12The i5 Approach Lesson Planning That Teaches Thinking and Fosters Innovation
  10. 2018-01-31[PDF] HOW TO CREATE COMPELLING CONTENT THAT RANKS WELL IN SEARCH ENGINES
  11. 2018-01-09[PDF] Frogs: Complete Cross-Curricular Theme Unit That Teaches About these Fascinating Amphibians
  12. 2017-12-17[PDF] The Cook's Illustrated Meat Book: The Game-Changing Guide that Teaches You How to Cook Meat and Poultry with 425 Bulletproof Recipes
  13. 2017-11-23[PDF] SQL - The Shortest Route For Beginners (B/W Edition): A hands-on guide that teaches the Structured Query Language for top ranking databases in record time
  14. 2017-02-17[PDF] Frogs: Complete Cross-Curricular Theme Unit That Teaches About these Fascinating Amphibians
  15. 2014-04-29Microsoft Excel For Business - A Practical Training Course That Teaches Real World Skills
  16. 2013-09-07Learning Revit MEP 2013 Training Video - A Practical Revit Training Course That Teaches Real World Skills
  17. 2013-05-12YouTube Market Crusher V3: The Only Course That Teaches How to Create Youtube External Links and How to Effectively Use Them
  18. 2013-04-24Learning Revit MEP 2013 Training Video - A Practical Revit Training Course That Teaches Real World Skills
  19. 2013-04-11Learning Revit MEP 2013 Training Video - A Practical Revit Training Course That Teaches Real World Skills
  20. 2013-04-11Learning Revit MEP 2013 Training Video - A Practical Revit Training Course That Teaches Real World Skills

Comments

No comments for "Dreamweaver Tut That Teaches U, to search a database with phpmysql".


    Add Your Comments
    1. Download links and password may be in the description section, read description carefully!
    2. Do a search to find mirrors if no download links or dead links.
    Back to Top