Tip & How-To about Computers & Internet

Dreamweaver Thought that Teaches You, to search a database with phpmysql...

OK, this should work... First of all, there is one great extension for DW & PHP ADOB 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 ADOB document type.
Start project with PHP ADOB (not old PHP MYSQL).

Page 1

Create form that has come Editbox and one button. Name Edit box something 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.column.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.

Good luck!

Posted by on

Computers & Internet Logo

Related Topics:

Related Questions:

1 Answer

I download XP driver for N1240U from Canon. Everything seems to work including successful diagnostics check. But, when I try to scan using Toolbox, I get a TWAIN error message. My file system is NTFS. Could that be the cause of the problem? If not, any ideas would be greatly appreciated. BTW, there does not seem to be any file with the inf extension created.


scan with adob photoshop /import - from - your scaner device/ , it will be correctly, maybe toolbox not working normally, if with photoshop will not be resaults, in control panel \ in scaner and imaging devices see is there your scanner, if it will not be in there, reinstall driver.

Jun 01, 2011 | Canon CanoScan N1240U Flatbed Scanner

2 Answers

Why does internet & PC along with that goes on slowing day by day ?


While you browse, more and more information is being stored on your computer. Also, spyware from websites can be installed on your computer. Download the following program:
http://dw.com.com/redir?edId=3&siteId=4&oId=3000-8022_4-10804572&ontId=8022_4&spi=84df37e813cddab7588ca92db88f0b60&lop=link&tag=tdw_dltext<ype=dl_dlnow&pid=11665648&mfgId=6290020&merId=6290020&pguid=-VFFWgoOYIwAABO40JsAAAEC&destUrl=http%3A%2F%2Fdownload.cnet.com%2F3001-8022_4-10804572.html%3Fspi%3D84df37e813cddab7588ca92db88f0b60%26part%3Ddl-10804572

Install it by clicking the .exe. Allow it to update and launch.
Then run a full scan. If it finds any infected objects, select "remove".

Feb 28, 2011 | Computers & Internet

4 Answers

http://www.adobe.com/go/tn_19166 error I want to download and install adobe but my computer wont so it do you have any reason as to why


Solution!

This serves to SYSTEMS VISTA 32bit and 64bit (x64)

********
First for VISTA 32bit:

Run the tools Uninstall_flash_player and Full_flashplayer_win via the links below: (MUST BE THROUGH THOSE LINKS)

Uninstall_flash_player.exe - http://download.macromedia.com/pub/flashplayer/current/uninstall_flash_player.exe

We installed the Flash Player:

Full_flashplayer_win_msi - http://www.macromedia.com/go/full_flashplayer_win_msi or install_flash_player_10_active_x.msi

*********
Problem persists? YES!

start / Control Panel / Internet Options / delete / delete everything and mark the "Delete Files and Settings also

stored for supplements. "

Click the Settings button in the "history of navigation" / button "View objects" / remove all objects that are as

uninstalled or damaged. After removing the objects click "OK."

Click the tab "Advanced" option and click on "Restore advanced settings," then the button "reset" and again

the "Reset" button.

Still tab / tab "Advanced", uncheck the option "Enable third party browser extensions."

Tab "Privacy", click the "advanced" and check "Override automatic cookie handling" and also mark

"Always allow session cookies", click "OK"

Tab "Security", click "Custom Level" and then click the "reset" and "OK."

Navigate to the folder C: \ Windows \ System32 \ Macromed and Rename the folder to Macromed.old

Clicking Start / Run / type Regedit
Go to the key: HKEY_LOCAL_MACHINE \ Software \ Macromed - Rename the key to Macromed.old

Go to the key: HKEY_CURRENT_USER \ Software \ Macromed - Rename the key to Macromed.old

Restart the computer.

**** VERY IMPORTANT ****

After restarting the computer, install the Flash Player by downloading done in the beginning "Full_flashplayer_win_msi"

install_flash_player_10_active_x.msi

Soon after installed, go to youtube or any site of preference and see if the flash worked.

If you have 2 browsers such as Firefox, you need to install flash for firefox.
Sign http://get.adobe.com/br/flashplayer/ through Firefox and install the Flash again.


-------------------------------------------------- -------------------------------------------------- ----------------------------------------
-------------------------------------------------- -------------------------------------------------- ----------------------------------------
-------------------------------------------------- -------------------------------------------------- ----------------------------------------


For Windows Vista 64bit (x64):


Run the tools Uninstall_flash_player and Full_flashplayer_win via the links below: (MUST BE THROUGH THOSE LINKS)

Uninstall_flash_player.exe - http://download.macromedia.com/pub/flashplayer/current/uninstall_flash_player.exe

We installed the Flash Player:

Full_flashplayer_win_msi - http://www.macromedia.com/go/full_flashplayer_win_msi or install_flash_player_10_active_x.msi

*********
Problem persists? YES!

start / Control Panel / Internet Options / delete / delete everything and mark the "Delete Files and Settings also

stored for supplements. "

Click the Settings button in the "history of navigation" / button "View objects" / remove all objects that are as

uninstalled or damaged. After removing the objects click "OK."

Click the tab "Advanced" option and click on "Restore advanced settings," then the button "reset" and again

the "Reset" button.

Still tab "Advanced", uncheck the option "Enable third party browser extensions."

Tab "Privacy", click the "advanced" and check "Override automatic cookie handling" and also mark

"Always allow session cookies", click "OK"

Tab "Security", click "Custom Level" and then click the "reset" and "OK."

Navigate to the folder C: \ Windows \ SysWOW64 \ Macromed and Rename the folder to Macromed.old

Clicking Start / Run / type Regedit
Go to the key: HKEY_LOCAL_MACHINE \ Software \ Wow6432Node \ Macromed - Rename to Macromed.old

Go to the key: HKEY_CURRENT_USER \ Software \ Macromed - Rename the key to Macromed.old

Restart the computer.

**** VERY IMPORTANT ****

After restarting the computer, install the Flash Player by downloading done in the beginning "Full_flashplayer_win_msi"

install_flash_player_10_active_x.msi

Soon after installed, go to youtube or any site of preference and see if the flash worked.

If you have 2 browsers such as Firefox, you need to install flash for firefox.
Sign http://get.adobe.com/br/flashplayer/ through Firefox and install the Flash again.

Dec 26, 2008 | Computers & Internet

Not finding what you are looking for?

300 people viewed this tip

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Loading...