Get wp_current_user_id using PHP and MySQL

Thanks to @Samuel Elh I manage to get this done.

I added this to my order-confirmation.php after I included config.php

    require ('../wp-blog-header.php');

    global $wpdb;

    global $current_user;
    get_currentuserinfo();

    $skrivID = $current_user->ID;

Then the insert query, I added the table I wanted the user ID stored in and used the variable $skrivID as value.

        $sql = mysqli_query($db_conn, "
        INSERT INTO ordre(
            userID,
            user_fname,
            user_lname,
            user_address, 
            user_email,
            user_phone, 
            service_chosen,
            user_note,
            order_date,
            statusID
        )
        VALUES(
            '".$skrivID."',
            '".$_POST['user_fname']."',
            '".$_POST['user_lname']."',
            '".$_POST['user_address']."',
            '".$_POST['user_email']."',
            '".$_POST['user_phone']."',
            '".$_POST['service_chosen']."',
            '".$_POST['user_note']."',
            '".date('Y-m-d')."',
            '1' 
        )
    ");

Ran the form with two different users and voila

http://dump.no/files/b007c7cd4c6e/2016-05-19_10_28_18-frigg.hiof.no___localhost___interaktiv_v1631___ordre___phpMyAdmin_2.9.1.1.jpg

Thanks again Samuel!

Related Posts:

  1. Has anyone tried putting PHP ActiveRecord on WordPress?
  2. How to create and work with custom data / tables (i.e., for arbitrary data)?
  3. Adding Custom Forms
  4. Databases – Submitting data from inputs to database [closed]
  5. db converts decimal number wrong
  6. Adding data to custom wordpress database table
  7. $_POST returning empty values
  8. How to send custom form submissions to WordPress Database?
  9. Confuse between forms and tables
  10. Updating the database after parsing CSV document
  11. custom search query database in child theme
  12. Insert data from form to database
  13. How to pass username into form that sends data to database
  14. Custom form that stores data in mysql database
  15. Putting form result in my database
  16. Bulk data save in custom table
  17. Can’t insert into a database wordpress
  18. How to stop form resubmission on page refresh
  19. How to check if image is already stored in a site’s post database? (network)
  20. add_filter the_content str_replace after shortcode
  21. WordPress will not operate correctly
  22. How to Join two tables from separate databases within WordPress
  23. Import 10,000 Users into WordPress WITH a specific ID for each user
  24. if statement on database query
  25. Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
  26. Passing POST data from one WP post to another
  27. How to group 2 radio buttons in a widget?
  28. How to generate page content from database the right way?
  29. Proper way to edit a post via phpMyAdmin without breaking the compare revisions tool
  30. phpMyAdmin displays error when importing database
  31. Get Admin Email Address From External PHP page
  32. How to get the POST TITLE using the POST ID?
  33. Why is the post meta[] empty when I make a call to the wordpress rest api?
  34. WordPress Scheduled Event Request Blocking
  35. Trying to establish connection to External Database
  36. How to create a form and display its content as table in admin panel?
  37. How to insert a single row to WP database table?
  38. How can I reuse the code to capture a param in a URL and place in a value in a hidden form?
  39. $wpdb->update with multiple parameters gives error
  40. wp search-replace on database returns PHP fatal error: Array and string offset access syntax with curly braces is no longer supported
  41. Is it possible to create a wordpress database with php code?
  42. Store a default value for a transient on plugin activation
  43. Split reads to a different connection string
  44. custom user role wordpress – grant guest access to edit.php without insert/update/delete
  45. inserting a post from an extern php file but post content doesn’t show on wp site
  46. Show success or error messages in Ajax response to WordPress custom registration form
  47. wp_mail file attachment not being placed in upload folder?
  48. Form Security: nonce vs. jQuery
  49. Not connecting to database in file with multiple MySQL connections
  50. Trying do build a contact form
  51. Can a page contain php code?
  52. Building a REST API for your web app exposes primary keys of DB records?
  53. Saving data from custom form in wordpress database
  54. wpdb Cannot Update column in Database
  55. How to add post meta in while loop?
  56. How to set cookies
  57. PHP Contact form
  58. WPDB – Read and write value from / to database
  59. Simple php in wordpress widget [closed]
  60. How do I make this Metabox show current DB value?
  61. How to Generate a list of Most Commented post?
  62. Why when I create a new post I found 2 record related to this post into the posts database table?
  63. Make a page (url) not cacheable [closed]
  64. Display multi-select box choices in a bullet list [closed]
  65. Using Ajax to submit a form, and run a SQL Select query based on user input from the form
  66. What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
  67. Tracking Visitor LatLng with WordPress using JS, PHP. How to put data which was extract using JS into DB
  68. Custom PHP form needs refresh to load page correctly
  69. Submiting with problems on one of the options php wprdpress
  70. code that I can run, or a plug in to show what sql tables something pulls information from
  71. Adding column to wpex_users
  72. Using wpdb to connect to a different database is not working
  73. Using transients to store form notifications
  74. not able to access $_POST on backend profile update
  75. Custom Plugin Develoment, Form Action
  76. wordpress form action page not found
  77. How to query a staging database?
  78. Trouble with checked() for array of multiple checkboxes
  79. Custom HTML form using PHP – help with ajax/username validation
  80. I changed the password for the database user of my website, updated wp-config.php and wordpress asks to be reinstalled
  81. I want to use wordpress database in android app using json encode?
  82. Form direction to .php on localhost
  83. Ajax call URL 404’ing when pushed to staging server
  84. Can form entries from a WordPress form go to a database
  85. Update only some custom user fields
  86. Dynamic form variables for post meta
  87. Can not manually create a database ( db, user, pass ) for a plugin
  88. two wordpress sites, two themes, one database, same content
  89. Headers for Contact Form are wrong
  90. Check if values exists DB
  91. MySQL database migration to WordPress
  92. Host does not allow remote connection, so how do I transfer data to my WordPress site?
  93. MySQL Engine vs. Charset
  94. Custom query_posts() parameter
  95. How to check if a value exists in one of two database tables
  96. How to edit the default database of WordPress [closed]
  97. HOW TO Insert Existing PHP Code to WOrdPress
  98. Where to put include php file?
  99. notify users when changed database
  100. Display total count of products in orders of a specific order status