Jump to content


Photo

Search in dreamweaver


  • Please log in to reply
4 replies to this topic

#1 zaki

zaki
  • New Members
  • Pip
  • Newbie
  • 2 posts
  • LocationScotland ..::.. UK

Posted 29 March 2004 - 10:30 AM

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.

#2 homchz

homchz
  • Members
  • PipPipPip
  • Advanced Member
  • 93 posts
  • LocationLee, New Hampshire

Posted 29 March 2004 - 02:30 PM

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

#3 morpheus.100

morpheus.100
  • Members
  • PipPipPip
  • Advanced Member
  • 145 posts

Posted 31 March 2004 - 10:14 PM

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.

#4 morpheus.100

morpheus.100
  • Members
  • PipPipPip
  • Advanced Member
  • 145 posts

Posted 31 March 2004 - 10:16 PM

date should read as data in above text!!

#5 zaki

zaki
  • New Members
  • Pip
  • Newbie
  • 2 posts
  • LocationScotland ..::.. UK

Posted 01 April 2004 - 09:03 PM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users