Database Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers Forums > Other Technologies > Database Help
Reload this Page

Looking for simple script

Discuss Looking for simple script in the Database Help forum on Codewalkers.
Looking for simple script General SQL help. Help with MySQL, MSSQL, Oracle, mSQL, PostgreSQL, etc.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today!
  #1  
Old July 15th, 2003, 02:49 PM
mdhall mdhall is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 158 mdhall User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
Looking for simple script
I'm looking for a simple program/script for a website. I can set up a Mysql database and tables. I just want an easy to use script to let my site users add info to the mysql databases, and do a search for categories, names, etc. For example, I am setting up a recipe/cookbook database, and another for employer job listings, and resumes. Both need a script for users to add to the database, and perform a search. I've looked at several scripts, but they arent what I want or dont function correctly. Any suggestions are appreciated.
Reply With Quote
  #2  
Old July 16th, 2003, 11:34 AM
Hatcher Hatcher is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Location: Yarm, Cleveland, England
Posts: 395 Hatcher User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
Send a message via AIM to Hatcher Send a message via Yahoo to Hatcher
RE: Looking for simple script
Search on www.hotscripts.com they'll most likely have the script that you want on their.
Reply With Quote
  #3  
Old July 16th, 2003, 11:41 AM
mdhall mdhall is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 158 mdhall User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
RE: Looking for simple script
i've found one to add to the db like i want it to, so i'm ok there...now i need a way to let users search the db, using keyword, dropdown box, etc.
Reply With Quote
  #4  
Old July 16th, 2003, 04:15 PM
Hatcher Hatcher is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Location: Yarm, Cleveland, England
Posts: 395 Hatcher User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
Send a message via AIM to Hatcher Send a message via Yahoo to Hatcher
RE: Looking for simple script
Now, same on hotscripts again, search for search box's, orcheck through the search files up for download of check for a tutorial.

Youre best off with the tutorial coz ur learning AND getting thescript you want
Reply With Quote
  #5  
Old July 19th, 2003, 03:50 PM
mdhall mdhall is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 158 mdhall User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
RE: Looking for simple script
OK, absolutely nothing is working as far as being able to search mysql with a keyword.I have tried at least a dozen scripts, nothing is helping. Do the fields in mysql need special settings are far as index, primary key, etc.?

The table is for job listings, and has the following fields:
id, company, phone, location, website, first, last, fax, email, position, experience, duties, addinfo.

I want to be able to let users search in company, location, position, & experience with one or 2 keywords.

Someone please help...I'm ready to give up.
Reply With Quote
  #6  
Old July 23rd, 2003, 05:55 PM
mdhall mdhall is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 158 mdhall User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
RE: Looking for simple script
Ok, here is what I have. For the job listings, a company enters basic info into a form, and that form inserts that info to mysql with no problem. To show the listings in the database, this is the script I have.
php Code:
Original - php Code 
  1.  
  2. <? 
  3. $username="xxxxxx"; 
  4. $password="xxxxxx"; 
  5. $database="xxxxxx"; 
  6.  
  7. mysql_connect(mysqldb,$username,$password); 
  8. @mysql_select_db($database) or die( "Unable to select database"); 
  9. $query="SELECT * FROM carrierjobs"; 
  10. $result=mysql_query($query); 
  11.  
  12. $num=mysql_numrows($result); 
  13.  
  15.  
  16. echo "<b><center>Current Job Listings</center></b><br><br>"; 
  17.  
  18. $i=0; 
  19. while ($i < $num) { 
  20.  
  21. $company=mysql_result($result,$i,"company"); 
  22. $location=mysql_result($result,$i,"location"); 
  23. $phone=mysql_result($result,$i,"phone"); 
  24. $website=mysql_result($result,$i,"website"); 
  25. $first=mysql_result($result,$i,"first"); 
  26. $last=mysql_result($result,$i,"last"); 
  27. $fax=mysql_result($result,$i,"fax"); 
  28. $email=mysql_result($result,$i,"email"); 
  29. $cat=mysql_result($result,$i,"cat"); 
  30. $experience=mysql_result($result,$i,"experience"); 
  31. $duties=mysql_result($result,$i,"duties"); 
  32. $addinfo=mysql_result($result,$i,"addinfo"); 
  33.  
  34. echo "<b>$company</b><br> 
  35. Location: $location<br> 
  36. Phone: $phone<br> 
  37. Website: $website<br> 
  38. Name: $first $last<br> 
  39. Fax: $fax<br> 
  40. E-mail: $email<br> 
  41. Category: $cat<br> 
  42. Experience: $experience<br> 
  43. Duties: $duties<br> 
  44. Additional Info: $addinfo<br> 
  45. <br><hr><br>"; 
  46.  
  47. ++$i; 
  48. } 
  49.  
  50. ?> 

This works fine to show all the ads in the database. What I would like to do is add a textbox/keyword search to it, and have that search cover the fields of company, location, category, position, experience, and duties. Also, the search will bring up not just the keyword it looked for, but the entire ad/listing that the keyword is in, or else a link that will display the entire ad. I have tried using a keyword search with it but I must not be setting it up right.

Also, I would like something similair that uses a dropdown list to search only one field, for another table with recipes.
Reply With Quote
Reply

Viewing: Codewalkers Forums > Other Technologies > Database Help > Looking for simple script

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway.