Results 1 to 4 of 4

Thread: MySQL PHP database within site

  1. #1
    Join Date
    Jun 2012

    Smile MySQL PHP database within site

    Hi everyone

    I have tried to post this in the most relevant place, please forgive if I haven't followed any posting regulations as I'm new to the site.

    I am currently attempting to create a search feature similar to the one found here http://www.s-h-a.co.uk/searchresults.php to return results according to a certain criteria.

    Im assuming you store all the data in a SQL database and somehow link it in the site so that it queries the database when you click search, however I am not finding any solid information or tutorials on how to do this. I understand that researching MySQL and learning it is a mission on its own. But aside from that is MySQL the way to do it? Or are there any other solutions.

    I will probably be using WordPress for the sites platform if that makes anything easier or harder.

    Thanks, any information is greatly appreciated.

  2. #2
    Join Date
    Jan 2006
    The hosting company you are using will have information on how to setup the MySql database. Generally depending upon your hosting system, one would use their administration system such as C-Panel, select MySQL Database, and create your new database. It will then tell you how to log in using the root path, username, and password you created the DB with. Once created you can use phpMyAdmin to create tables. Your PHP code will then access the DB from the website you created.

  3. #3
    Join Date
    Aug 2004
    MySQL is certainly a viable option for the database side of things, but by no means the only one -- PostgreSQL is a similar sort of open-source RDBMS that is essentially comparable and which some might prefer. But those are only two of the more commonly used options. While the choice of DBMS will affect some of the implementation specifics (not a lot if you can abstract it out, such as with the PDO extension in PHP), it's probably not your biggest concern for now.

    Probably of more importance right now is determining your database design -- how the data will be organized to maximize reading and writing from the database -- and that will take more than a forum post or two to deal with it. The actual DBMS you'll use may be more dependent on where you plan to host the site and the server-side environment you'll be working with -- or if you favor a particular environment and DBMS, then that will drive your choice on hosting.
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

  4. #4
    Join Date
    Jun 2012
    Thanks guys,

    Some helpful information, I have actually created a database within MySQL under my C-Panel, I should probably of said that before. I just need to get to grips with creating tables and what the different settings and fields mean.

    So it is simple enough to make a form search my database (which will be of around 100 different hotels) and return the relevant ones to a results page?

    Thanks again!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center



X vBulletin 4.2.2 Debug Information

  • Page Generation 0.09970 seconds
  • Memory Usage 2,862KB
  • Queries Executed 15 (?)
More Information
Template Usage (32):
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (4)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (1)navbar_moderation
  • (1)navbar_noticebit
  • (1)navbar_tabs
  • (2)option
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (26):
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/functions_navigation.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_facebook.php
  • ./includes/functions_calendar.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (70):
  • init_startup
  • friendlyurl_resolve_class
  • init_startup_session_setup_start
  • database_pre_fetch_array
  • database_post_fetch_array
  • init_startup_session_setup_complete
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • load_show_variables
  • load_forum_show_variables
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • strip_bbcode
  • friendlyurl_clean_fragment
  • friendlyurl_geturl
  • forumjump
  • cache_templates
  • cache_templates_process
  • template_register_var
  • template_render_output
  • fetch_template_start
  • fetch_template_complete
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • build_navigation_data
  • build_navigation_array
  • check_navigation_permission
  • process_navigation_links_start
  • process_navigation_links_complete
  • set_navigation_menu_element
  • build_navigation_menudata
  • build_navigation_listdata
  • build_navigation_list
  • set_navigation_tab_main
  • set_navigation_tab_fallback
  • navigation_tab_complete
  • fb_like_button
  • showthread_complete
  • page_templates