Results 1 to 4 of 4

Thread: MySQL Query Function not working in MAMP - Please explain

  1. #1
    Join Date
    Sep 2013

    MySQL Query Function not working in MAMP - Please explain

    Im new to PHP/MySQL and currently reading PHP and MySQL Web Development by Luke Welling/Laura Thomson. I have been doing tutorials over the internet and I know about how individuals who post tutorials can sometimes not code the best way.

    Filename: index.php

    My problem:

    Cannot connect to database

    Example 1:
    $con = mysql_connect("localhost","root","root","blog1");
    Connects to Database

    Example 2:
    @ $db = new mysqli('localhost','root','root','blog1');
    if (mysqli_connect_errno()) {
    	echo "Error: Could not connect to database. Please try again later.";

    1.Will only MySQLI work in MAMP, or is there some setting in MAMP that I need to change to use MySQL(Other functions like select and query don't work for me)?
    2.Should a beginner be learning the object orientated programming?

    Thanks in advance!

  2. #2
    Join Date
    Aug 2004
    I don't really know anything about MAMP, but I do know that the old MySQL extension has been deprecated for quite awhile now, so you'd really be doing yourself a favor by just going ahead and using the newer MySQLi extension (or even PDO). You can use it in a procedural manner very similar to the old extension, but it certainly wouldn't hurt to start getting into OOP habits as early as possible.
    "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

  3. #3
    Join Date
    Mar 2007
    The irritating thing is that they constantly like to reinvent the wheel and make life harder.

    Take the SQLite tool, moved over to SQLite3 without giving any consideration to all those users with SQLite2 databases and no migration tool either.

    This is one of the biggest bug bearers of mine is that no consideration for backward compatibility is ever given, so what if something is depreciated, HTML4 has some right old fossil markup yet it is still supported, if a browser can support markup from the earliest websites, WTF is wrong with MySQL and SQLite people?

    SQLite3 now can't tell you how many records it has returned, it has to run the effing look up command TWICE, once to get the results, second one with the COUNT(*) function call in the query. Totally effing nutty backward retarded method if I ever saw one, its like "Oh were moving on to this platform but were taking out one of the most important functions of a query process because we think its better" total numbnutz the lot of them, give me a wall cuz that lot including MySQL and PHP lot need their heads banging against something hard to wake them up a bit.

    Some people have poured blood sweat and tears in to their code and because of a few retards in the industry, every one of the several billion users using code now has to recode their stuff.
    --> JavaScript Frameworks like JQuery, Angular, Node <--
    ... and please remember to wrap code with forum BBCode tags:-

    [CODE]...[/CODE] [HTML]...[/HTML] [PHP]...[/PHP]

    If you can't think outside the box, you will be trapped forever with no escape...

  4. #4
    Join Date
    Aug 2004
    For that matter, why can't I play one of my favorite all-time PC games on Windows 7, when it worked fine on like the 4 or 5 previous versions of Windows?

    Anyway, you can still install/enable the older MySQL extension if you need to be backward-compatible with existing code, but it's difficult for me to see why you would want to create new code using it instead of the MySQLi extension, which provides both functionality and performance enhancements, and keeps it in line with the latest MySQL releases and their associated APIs.
    "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

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.13109 seconds
  • Memory Usage 2,874KB
  • Queries Executed 15 (?)
More Information
Template Usage (33):
  • (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
  • (2)bbcode_code
  • (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 (72):
  • 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_postinfo_query
  • fetch_postinfo
  • 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