How to display SQL/Database content in pages built with Elementor | WordPress Tutorial

[@esooghazy]

I've been looking for a quick video to populate db table data for a few days. Thanks a lot!

[@artron_games]

Thank you so much man, you helped me a lot. was looking for a way to use wordpress with php and you were able to show and teach it clearly. This opened up a thousand opportunities for implementation !!!. I can't wait to build systems with an amazing and functional design.

[@ceciliaclaros7960]

Wow, excellent explanation. Thank you, and congrats 👏🏼 👏🏼

[@sanders123]

Great video and reply to comments. Thank you sir!

[@cpincpersonal]

Nice video. Clear and concise. Thanks!

[@DennisHorn1981]

Thank you! Very clear and precise with excellent pace!

[@clausius594]

Thank you very much ! Very useful for one who wants to create design with elementor but wants more complex pages with code.

[@gunrunjk]

Thanks for your explanation, in my case, when I update my data base, it is not updated in my page, when I turn off chrome browser and connect again, it would be effect, how can I update my web page when I try press the F5 key/?

[@algonte]

Thank you, very clear and useful explanation

[@Gillan007]

this right here is probably the answer to my problem. thank you very much 🙏

[@casaazul1284]

Great tutorial, thanks a lot. It was very clear and gave a pretty good Idea of what we can do. I have one question, you used wpdb, what should I use to get info from a remote DB? I want to pull information from restaurant pos to display menu product descriptions and prices in the restaurant website. any advice will be appreciated.

[@tijania]

Thanks for sharing. Do you have a video showing how to add (or manage) the database from the front end? Meaning, how would you add a new player or change the player’s team as a user of the site? Also, do you have a video showing how you connected the database to wp?

[@jojosoba3493]

did you get any info on this?

[@dionstr17]

Thank you very much for this beautiful tutorial. Really simple and clear in guidance. Can we make the same thing but to pull the data from an other database (that is hosted on the same server/panel)?

[@Sleepyshy]

Great tutorial! I am excited to use this while building my current project site. Now to figure out how to populate the table with user data that is unique to the user and entered by the user. Huzzah!

[@indradg1]

Hi, I just did this. I populated custom user data by the users. The process is the same. You just need to query the 'User_meta_data' from your SQL database.

[@jeremiahryland3376]

Sorry to be so off topic but does any of you know of a way to get back into an Instagram account..? I was dumb lost the account password. I love any help you can offer me.

[@metroplexlocksmith]

@@indradg1 can you search data based on different drop down menus selected by user ?

[@tartanrambo]

This is a great tutorial. Thank you! But, I have a question. How would I be able to take a job application submission from Elementor Forms and view this as an html page? Or, in a list which links to a page-view showing the applicants photo and details that can be used to setup job interviews by HR? I would appreciate your thoughts.

[@rezavafaei5523]

thanks for your great video, may I ask how can I add a filter to this table by code?

[@Jason-ri8th]

This is from a MySQL table within the same wordpress site. Is this possible for an SQL table outside of the wordpress datatabase?

[@alinaz8243]

Hi Jason, wondering the same thing. Did you manage to figure it out?

[@caviadalaboratorio5383]

YOU'RE AN ANGEL THANK YOU

[@ab.normal.]

Thank you for this helpful tutorial. Can we add search bar to the display?

[@josephlivengood4508]

Will this work for over 750 vehicles? The images are on a separate table but match the vehicle wid number for that image. I cannot find a plugin to help me connect the correct image to the vehicle, Only around 350 of them have images. Will this do it?

[@chrismccafferty83]

Do we need to configure any setting first. Followed this step by step and not working 😢

[@sanghamidhanasekar2940]

How to add filter, pagination, records per page in that table? I already built a data table using php and script with all those feature I said above ,I dont know how to integrate all thoe in a php fie

[@samuelvijay8187]

i have a website which data base has to reflect in another page of my site, can u plz help me

[@francoislejeune6386]

Hey ! Thank you so much for the tutorial :) Question : how would you implement a pagination ? I have like 1000 entries that I would like to split into pages of 10 elements... Is it possible ? I kind of struggle to find a solution... thank you so much mate

[@francoislejeune6386]

I found a solution if needed comment here

[@tom-greg]

@@francoislejeune6386 I would like to know your solution :)

[@satoukazuma2671]

@@tom-greg Damn, the lad left ya on read

[@hectorlitecoin1416]

Very helpful, thank you!

[@balwansdharmasya]

Thank you so much it helped a lot

[@mariejeantulibao9798]

The table displays on preview but when I add the shortcode to a live page, it wont show

[@marghdarshan9639]

How did you established the connection between php and MySQL Will you please help me

[@thewbltr1370]

Great tutorial! But I would like to ask, how if I need to only count the number of rows on the table and display the result in Elementor? Would that be possible? I'm not that knowledgeable about PHP so, if you can help me then it's great! Thanks!

[@prasaddiwan8808]

Yes its possible. You need to change the SQL query to "SELECT count(*) as 'total_rows' from Table_name;" and then in the foreach you may print the total_rows as $result->total_rows.

[@shitofshit2]

Can you help me through it? I created a new database in myPHPAdmin, and created a table like yours. But shows me nothing though.

[@AmeerHamza-dq7ck]

Thanks sir your video is so much helpfulll.

[@adeptwareconsulting3348]

Hello, what if I don't want to display it as a table. Just as text, how should I modify the snippet?

[@programmingtutorials185]

Hello, i am not exactly sure what you are trying to do, but here is a suggestion: First, replace line 4 of the snippet with the following line: $result = $wpdb->get_results( "SELECT Name, Team, Position, Height FROM nbaplayer", ARRAY_A); Then, replace lines 14-19 with the following: echo ''; foreach ($result as $row) { $line = implode(", ", $row); echo $line . ''; } echo ''; This prints each row of the SQL table as a separate line in a text paragraph. Let me know if it helps.

[@adeptwareconsulting3348]

​@@programmingtutorials185 Hi ! Thank you for your reply! I am trying to show text from the database on my live page using a shortcode. I tried but it still did not work I have:

[@programmingtutorials185]

@@adeptwareconsulting3348 From what i see, the prepare method takes two arguments but you give it only one. In your case, since you don't use any php variables in your query, i guess you can omit it. Also, if Project_Title is of String type, you need to enclose the value in single quotes. $sql = "SELECT InitialBrief FROM Portal_100 WHERE Project_Title = 'Project 1' "; $results = $wpdb->get_results($sql, ARRAY_A); If this still doesn't work, run the query directly from your database user interface and check if it's valid and try to correct it if not. Also, where do you put that php code? Do you use the shortcode with [Initial_Brief] in your page?

[@adeptwareconsulting3348]

@@programmingtutorials185 Hi and Thanks again. I am using the shortcode to display in front end. I finally got it to work. ( It seems that you can only use PRIMARY columns to select the WHERE variable. Also no spaces. I changed Project 1 to a number and altered the code as follows and it worked!! Thanks again.

[@jasonwilliamson7630]

This Is Great! I've tried it and it works! I have a question, how to write to the database from the web post?

[@milindrahatwal]

How can I play the videos that are present in my sql database on the website?

[@habiiba3986]

Hi, how do I link ACF with sql data

[@setindesenvolvedorweb9681]

i need put a search, how i can do that? seach to find names dor exemple.

[@janjeremyingay2553]

good day can i ask how to show the total row count of your database table in wordpress?

[@dwikdw_]

great tutorial !! i follow right away and implement form to submit data but the table need update manualy apply changes in elementor editor, not update dynamically, can you help me sir ?

[@saurabhbhauwala9749]

Can u create a website link with Sql database where one can add row from from end and the same data gets stored in database. Also to get details of files once drag and drop on website.... captured and stored in sql data base

[@TchadRexMusic]

Thanks for your video.

[@dyprmn]

How to create download button?

[@albaseltraining1440]

You are the best

[@RealDC19]

how do you add the shortcode to the snippet without using that plugin? i already have a snippet plugin and to migrate all of that info over would be too much

[@RealDC19]

Anybody wanting to know at the beginning as the first line just before "global $wpdb;" add this function show_db_table() { then at the very end after the closing "}" add this add_shortcode ('show_db', 'show_db_table'); your shortcode will be [show_db]

[@RealDC19]

you have to add another "}" under "echo "";" to close it off again before he add_shortcode

[@vierbeinercheck5995]

Hello Expert How can In finden the source code not for a table. I need a source code which Shows only one dataset. Your table Shows more than one dataset. I would like to show something smilar an Input screen which Shows one dataset. In bestimmten case it is possible to edit this displayed dataset direct in Frontend. Do you have a video about displaying only one dataset? Or do you know a Plugin for showing an existing dataset. (Yes, I know it is possible eg with Contact Form 7 a dataset. But which Plugin or code is possible to show one dataset. Thank you very much in advance Harald from Germany

[@DoomDaam]

this is just perfect! thanks

[@verkaufdeinbike]

Do you know how to list only the last 10 database entries? Great video! Thank you a lot!

[@worthsalive]

You can do that by using the Order by clause and Limit cluase in your query. For example, you can Order by the create_date field and Limit 10 eg: SELECT * FROM table_name ORDER BY create_date LIMIT 10

[@verkaufdeinbike]

@@worthsalive Thank you very much !

[@aishwaryanr4072]

If I have to execute only the php code separately to check the outputs, how will be able to do that?

[@programmingtutorials185]

What do you mean to check the ouputs?

[@noukimoto574]

Your're the best!

[@guillaumealex4680]

Hi. Thank you for the very detailed and informative tutorial. I am new to wordpress. I am blocked. I would like to create a page in WordPress. In this page, I want to insert an ACF form whose fields come from a MySQL data file that I created. By clicking on a save button for example, the entries in the fields of the form are sent to the database. I'm completely lost. If you could guide me a little it would be appreciated. Thank you in advance. N.B I am French speaking.

[@josebenth8502]

Del modo que lo hace tu vs un plugin que configure para enviar phpmailer. cual metodo es el mejor?

[@erikafortes331]

Hello there, and if i want to fetch an image url and show it on image, is it possible?

[@programmingtutorials185]

I would do it like that.

[@ninjaisfast]

Hey, great tutorial ! What if I want to only return one row from the table, using a variable that I declare in the script? Say in your script, if you had for example requestedName = Lebron James, how would you look up that name in the table and only return that row? Thanks :)

[@pjones6749]

You would have to use PHP to pass the variable (seatch query) to a SQL string to SELECT only that row

[@chrakesh5181]

Much useful tutorial...how to insert data using form..

[@programmingtutorials185]

This is a very general response. You will need to link the form to a php script that will execute on server side when the form is submitted. This script will have to a)validate the form input, b)insert the input in the database using sql and c)redirect the user to a page saying whether the data was stored successfully.

[@NeelNarayan]

@@programmingtutorials185 How to do it with elevator pro form ? It's a big issue and there are no good tutorials available anywhere. Please help soon.

[@basutarudo]

thanks for tutorial!

[@jimmelbermudez]

Thank you very much sir

[@ookura3425]

Is it possible to create a login page using php built with Elementor?

[@programmingtutorials185]

I guess it should be possible, but i don't know the details. Personally to handle users (login, register) in my website, i use the wp-members plugin: wordpress.org/plugins/wp-members/ It may fit your needs. I think you can customize the login page with your own html/css (i am using the defaults)

[@walaachehebelaine2265]

Thank you 😍

[@rodolfoeliassealesposada3109]

Please. send me PHP code for this plugin.

[@luiscatalan3309]

Please do the same for APIs and external databases

[@kizuGi]

Nice work. Can you do this with MSSQL for example ?

[@jimbouch144]

Probably not

[@kizuGi]

@@jimbouch144 Good response You shook

[@jamesmacharia1263]

Thanks mate... I'd buy you a bottle of cold beer :D

[@ITManager-n5d]

Thank you!

[@vishwanathrvishoo451]

Bro is running WordPress in Local host 😮

[@gableroni]

Toni Kukoc:)) cool man

[@BusinessDuck69]

I followed your tutorial exactly, but I fail to see any of the rows being displayed. Could this be a security issue? I have the WordPress All in One Security plug in, and I'm wondering if it could be interfering with my ability to show this data. Any ideas?

[@programmingtutorials185]

If you suspect it could be the plugin, then i would say to deactivate it and try to load the page again. If it still not working, then it wasn't the plugin causing the problem. Don't forget to activate it again. So if still not works with the above, enable debugging in wordpress. See how it's done here: wordpress.org/support/article/debugging-in-wordpress/ Then load the page and open the file debug.log, which should be inside the wp-content directory, and check for any errors there.

[@jimmelbermudez]

PLease Tutorial for Insert data in web

[@itz-ratul]

Thank you.

[@himkafle6123]

Very useful

[@mohamedfoula503]

Thanks so much

[@kldzk]

ευχαριστουμε

[@shhamidi5989]

thx

[@devtec_nl]

👍🏼

[@_KASM_]

I love you

[@deolinnaidoo3378]

Ughh I hate php

[@oussamaachour1523]

hey there do you work as freelancer, if yes can I have your email to contact you, thanks

[@Arbi_52727]

can you combine html with php if i want to show the elements in better way instead of the classic table