www.webdeveloper.com
Results 1 to 6 of 6

Thread: Get a result date from sql with php?

  1. #1
    Join Date
    May 2017
    Posts
    16

    Get a result date from sql with php?

    hi, i have a date on mysqli and i am tryying to get it with php with this code


    PHP Code:
    $queryt mysqli_query($link,"SELECT mest FROM inventario WHERE user = '$id'"); 
    but this dont return nothing, then i used a fetch arrayy but just returned the word "array" someone know the function for get the result of a date on mysqli ?

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    22,326
    mysqli_query() does not return a value or even a result row. For a select query, it either returns a mysqli_result object, or false if there was some error. So you could do something like:
    PHP Code:
    $result mysqli_query($link,"SELECT mest FROM inventario WHERE user = '$id'");
    if(
    $result == false) {
      
    error_log(mysqli_error($link));
      die(
    "DB error, error message logged");
    }
    if((
    $row mysqli_fetch_row($result)) != false) {
      
    $queryt $row[0];
    }
    else {
      
    // whatever you want to do if no match was found

    "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
    May 2017
    Posts
    16
    Quote Originally Posted by NogDog View Post
    mysqli_query() does not return a value or even a result row. For a select query, it either returns a mysqli_result object, or false if there was some error. So you could do something like:
    PHP Code:
    $result mysqli_query($link,"SELECT mest FROM inventario WHERE user = '$id'");
    if(
    $result == false) {
      
    error_log(mysqli_error($link));
      die(
    "DB error, error message logged");
    }
    if((
    $row mysqli_fetch_row($result)) != false) {
      
    $queryt $row[0];
    }
    else {
      
    // whatever you want to do if no match was found


    ty i couldnt find on w3school information but worked, btw what mean the row[0] ? because is not an array is only 1 value right ?

  4. #4
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    22,326
    The result row is an array, but since you only selected one field, it's an array with only one element, thus the zeroth element of that array.

    The PDO database extension has a fetchColumn() method which makes it simpler in that sort of case (only need that one method call to get that one column), but it does not appear that the mysqli_result object has the same sort of thing, so it takes that extra step to actually grab the value of interest.

    .
    "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

  5. #5
    Join Date
    May 2017
    Posts
    16
    Quote Originally Posted by NogDog View Post
    The result row is an array, but since you only selected one field, it's an array with only one element, thus the zeroth element of that array.

    The PDO database extension has a fetchColumn() method which makes it simpler in that sort of case (only need that one method call to get that one column), but it does not appear that the mysqli_result object has the same sort of thing, so it takes that extra step to actually grab the value of interest.

    .
    o tyy, but i am not studyng pdo yet i dont see necessary ty !;D

  6. #6
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    22,326
    Not saying you have to use PDO -- though personally I prefer it. I find it a bit cleaner to use, along with the benefit that you can generally use the same code flow/methods regardless of whether you use MySQL or any other supported DBMS. (I happen to use PostgreSQL a lot.) One step at a time is fine, however.
    "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.13970 seconds
  • Memory Usage 2,906KB
  • Queries Executed 15 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (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
  • (3)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (6)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (1)navbar_moderation
  • (1)navbar_noticebit
  • (1)navbar_tabs
  • (2)option
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)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