Jump to content

Archived

This topic is now archived and is closed to further replies.

zaki

Search in dreamweaver

Recommended Posts

I am new to php in dreamweaver, i have setup my sql database and can connect to it via dreamweaver mx,i want to create a database with name,telephone number and address and create asearch field in dreamweaver with the name,phone number and address so people can search fora name and get all the other information about them(phone number,address.

Also i have all the date saved in microsoft access format,how can i transfer to mysql database or convert it to mysql database.

Can anyone help.

Thanks in advance.

Share this post


Link to post
Share on other sites

if you can export access to Excel you shoudl be all set. You can then take the Excel document and export as a text file and you can upload a text file to PHPMyAdmin.

I use Navicat to build and moify my table on my computer then upload the exported files to PHPMyadmin.(My provided soes not allow me direct access with Navicat (MySQL GUI).

 

http://www.navicat.com/

 

Free 30 trial which is nice, there are a ton of these out there if you look some are better than others, I liked this one for the price and options.

 

 

Good luck, if you need help I will do what I can but I have very littel experience with Access.

 

Josh

Share this post


Link to post
Share on other sites

Easy method for what you wish to achieve is to create a sigle form with dynamic list menu. Create a recordset to search by name and then use that date to populte the list menu. Create another page to display results based on a recordset to form variable. Call the form/listmenu into your resultes page with :-

<?php include ('filename.php');?>.

 

Result page will now show the form and once a selection has been made the page will refresh and display results.

Share this post


Link to post
Share on other sites

I just want to say thanks for all the help guys.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.