Insert data into database and display in HTML table using PHP and MYSQL | Tutorial - 55
HTML-код
- Опубликовано: 24 май 2019
- Here, we insert data into a database table and display in HTML table using PHP and MYSQL. Fetch data from database table and result in display in HTML table using PHP while loop.
In this tutorial, we will understand the two PHP concepts. First, insert or register data into MYSQL database table and second select data from database table using select query.
You can display data in an HTML table or simple format using the PHP script.
Here, you will clear about insertion operation and select operation.
Follow the steps -
1. Create an MYSQL database table.
2. Create a config.php file.
3. Make an HTML form.
4. Create PHP script form data insert into a database table.
5. Select data and display in HTML table on the same page.
Watch the PHP tutorial until the end.
Part 2 is here-
• Display data in HTML t...
Complete PHP tutorials in Hindi
bit.ly/32IsMuI
bit.ly/2y0VFnI
Complete PHP Tutorials
bit.ly/2XVTyRi
bit.ly/2TT3lAK
Website
technosmarter.com
For any question use our Smarter QA platform.
Ask the Question
bit.ly/2Ee7LOj
or other videos by Techno Smarter...Subscribe below links!!
Facebook
/ technosmarter
Twitter
/ technosmarter
RUclips Channel
plus.google.com/1038408050263...
Instagram
/ technosmarter
#mysql #PHPTUTORIALS #insert #display #programming #trending
Reference -
1. Insert data into a database in PHP.
2. Register user data into MYSQL database table using PHP.
3. Insert and display data into an HTML table by PHP.
4. PHP tutorials.
5. Language - HINDI
. 
Наука
![Php : How To Search And Filter Data In Html Table Using Php And MySQL Database [ with source code ]](http://i.ytimg.com/vi/2XuxFi85GTw/mqdefault.jpg)
God thanks!! I have found a Great PROGRAMMER like you dear Thapa!
Welcome
Mza aa gya Bhai ❤❤❤
Great & thank you ❤️
Clear 👍
Thanks sir this is the video I was searching for
Welcome
You are true developer thank you for this video
Welcome Dear ...
Thankyou for making this video it helps me a lot in my Project 💕
Welcome
I am same as you
100% work. Thanks a lot.
Welcome
Thank you sir, this video help me more for my website and has clear all the concepts
Welcome..
Thank u so much such a great tutorial 👌👌🙏
Welcome..
great explanation, got it very easily ❤
Thank you
Very Good High Level Thinking
Thank you .....
Legend are watching this video in 2021😂
Kya baat hai bhabhi ji😂😂
2022 also
😂2023
No mam... Legends are watching this video in 2024 ✌️
thank you sir!!!
Welcome
Thank you so much sir🙂🙃
Welcome
Thank You Brother ❤ Lots of love to you!!
You're most welcome
php getting popular day by day
Thanks alot sir !
Welcome
Jaise connection file humne include ki thi 1st page ki linking me toh 2nd page Ko link m dobara file banegi ya Wahi include kr du???
Connection file ek bar hi bnti hai fir usi file ko hum sabhi page pe top pe at the beginning include kra lete hain .
For example watch registration and login form in php
ruclips.net/video/kinYAbkq8JE/видео.html
Thanks 😊
Welcome
thanks a lot
You are most welcome
Sir jaise hmme first page ki linking ke liye connection file bnayi thi toh sir 2nd page Ko linked krne ke liye dobara bnanai pdegi vo file.
No , include same connection file
For example watch registration and login form in php
ruclips.net/video/kinYAbkq8JE/видео.html
Sir PLZZ mere bhi ye doubt hai jaise connection file humne 1st page ki linking me bnayi toh agle page ki linking me dobara bnegi ya ussi hi include kr lu plzzz sir reply
Connection file ek bar hi bnti hai fir usi file ko hum sabhi page pe top pe at the beginning include kra lete hain .
Very Very Nice explain in short time with fully function solve for data store...
Thank You
thanx brother
Welcome.....
Thanks
Welcome
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, array given in. This is showing when I run the program and please tell me how to insert photo in database and display ,plzz plzzz do help.
There may problem in your query and other things before the fetch array .
Check your query and connection variable in mysqli_query() function .
You can check here
technosmarter.com/php/PHP-insert-data-in-database-and-display-in-table.html
You can check question and answer here
Reference
technosmarter.com/qa/643/mysqli_fetch_array-expects-parameter-mysqli_result-bool-given-line
Sir, by selecting the data from the database, according to the id and adding the column, how will it be done in the same table?
Select data by id and insert by insert query.
@@TechnoSmarter sir please videos
ruclips.net/video/fBfVvUm2N-g/видео.html
@@TechnoSmarter thnq sir.sir you explain very well in the video
Sir, if there is a video related to how a 12 months salary sheet is made for a salary employee and how per tax is calculated, please send it.
what if I want to link another html page in place of function.php
how can I submit data in database and go to another html page simultaneously???
You can use header () function to redirect (jump to ) another pager after submitting .
Header function Reference
technosmarter.com/php/header-function.php
Header function in Hindi
technosmarter.com/PHP-in-Hindi/header-function.php
Brother how can we add more column?
Add more columns in database table and then add more fields in your query and code .
Ultra legend are watching this video in 2022
Sir meri database connection nehi ho raha .
or connection.php me kuch show nehi ho raha he .
Koi warning bhi nehi..
Fir aap kaise kah sakte hain ki database connect nhi jab aapko koi issues nhi mil raha hain
Baaki reference ke liye kis trah se database connect krte hain yahan par dekh sakte h
technosmarter.com/qa/506/how-to-connect-the-html-page-to-the-mysql-database-using-php
If condition m test kijiye ki connection variable true h ki nhi .
Baaki niche diye gye code ka use kr sakte h jis se connection.php ko run krne par error show hogi agar koi mistake h to ...
The failed message is coming data can not be saved
What's happening
May be issues in your query or database columns .
nice video...after watching many videos..I have find out the answer from your video...Thanku Sir
Welcome Priyanka Balley .
Hey Priyanka
You can use our QA forum to ask any question and get best answer .
technosmarter.com/qa
You should join it .
@@TechnoSmarter Ok thanks!
Welcome
Do you not make video on data update or delete on database by this following processes?
How to take print out of particular content from database?
Watch this for registration and printout
ruclips.net/video/xXyh0qA0Y2o/видео.html
@@TechnoSmarter sir print me date show nahi ho raha h
@@rameshmeena7582 You have to fetch data from the database and print. Watch that video carefully.
Sir plzz rply krna aap bhaut acha smjahte ho plzzzzzzzzzzzz sir
Already replied
Write a program to continuously take a input for students details from the console or html ,the user should be able to add multiple students details once .the data should be saved in a database . Once the data is saved the user should be able to edit and delete option should allow for the bulk delete. plse code
We will definitely create .
my form automaticaly submit with blank data what is the solution of this issue ...?
Check your variables value inside if block of code
then check values are coming or not from form fields
Then
Check your insert query .
@@TechnoSmarter thanks it helps
Welcome
It is neither showing success nor failure and data is not getting entered into the database. It shows MySQL has returned an empty result. Pls do help.
Check your insert query
same error
Kindly check your insert query or remove date from query then try again .
MySQL returned an empty result set can anyone answer what is the reason
Check your table name .
Check your query for the same purpose .
Check data available in your table or not .
Sir data insert ni hori h plz tell me kal interview h mera
Kindly share your issues .
it keeps on failing. i checked all the codes
Kindly share your issues
I have to make one table. Can you help me.
Yes . Data in html table or database table .
It's basic operation
Hmm
THANKS
Welcome
Sir Can we do these process in android?
Yes ... You have to work on android .
@@TechnoSmarter how?
@@TechnoSmarter can I talk you somewhere?
@@TechnoSmarter I was asking to do in Android Phone
Fo reference find android tutorial by link
www.google.com/search?sxsrf=ALeKk00he9hxenSnqwjaX_pdQgGbGcx8Lw%3A1612527294388&source=hp&ei=vjYdYNm4FZPZz7sPnbW9gAE&q=insert+and+display+in+android&oq=insert+and+display+in+an&gs_lcp=ChFtb2JpbGUtZ3dzLXdpei1ocBABGAAyBQghEKABMgUIIRCgATIFCCEQoAEyBQghEKABMgUIIRCgAToHCCMQ6gIQJzoECCMQJzoICAAQsQMQgwE6AggAOgUIABCxAzoFCC4QsQM6BggAEBYQHjoICCEQFhAdEB5QqwxYvFBgnl9oA3AAeACAAf4CiAHyK5IBCDAuOS4xNC4ymAEAoAEBsAEP&sclient=mobile-gws-wiz-hp
Sir meri website ki linking nahi hori sir plzzz plzzz sir
Kya aapne sitemap submit kar diya Google webmaster main ?
@@TechnoSmarter sir I am new to ur channel.sir mujhe sitemap Kya cheej hai mujhe smj Ni Aara aap Kya Bol re ho plzz ek Baar detail me smj do
Sitemap.xml ek XML file hoti hain jisme aapki website ke sabhi links hote hain jaise
example.com/sitemap.xml
Is trah se apni website ka sitemap check kijiye yousitename.com/sitemap.xml
Us sitemap url ko Google console webmaster site map tool main submit kijiye jis se kuch dino baad aapki website Google search engine m link ho jayegi. . .....
Can we do the same using VScode and xammp?
Yes , why not
But my code is not working without phpmyadmin , I'm using Xammp VScode and MySQL CLI@@TechnoSmarter
Please help
PHPMYADMIN comes with xampp server . You can connect php page to database by phpmyadmin also create database in phpmyadmin .
But whenever I'm trying to open it, it's showing invalid setting, access denied
Kr Liya
Share your issues
how to get source code of this ??
Go to reference link or part two
technosmarter.com/php/PHP-insert-data-in-database-and-display-in-table.html
while inserting data into database id is not auto incrementing. its showing 0 everytime
Edit your id column and make it auto Increment first .
@@TechnoSmarter yep... It worked.. thank you...
Welcome
@@TechnoSmarter hey...
M trying to give an input in textarea which have single quotes, semicolons.. and after inserting the data into db.. else statement is executing..
How to make this working with single quotes, semicolons etc
Create textarea
Give a name to textarea
Use that name with post
Handle value via post and store in a variable
Use that variable in a insert query like others fields
Done ......
Nahi ho Ra insert code bhi thousand times check
Share issues
Any I need code
Simple php admine panel
Text changer
Admin page to home page
Mines php to php text changer
We are not getting your point but you can find admin panel in many sources .
Check here and you can get source code there
technosmarter.com/shop
Sir mera failed aya hai same kaiya waise hi
Share your errors .
Also you can check tutorial here
technosmarter.com/php/PHP-insert-data-in-database-and-display-in-table.html
Sir database me data insert nahi ho raha he..
Check your query . Correct your insert query .
You can check complete tutorial here
technosmarter.com/php/PHP-insert-data-in-database-and-display-in-table.html
@@TechnoSmarter sir ho gaya tq..
Welcome
@@daxeshsoni4842 can you explain me plz muze same failed hi aa raha hai
Um part 1 and 2 are the same.
No , Part 2 is the next part to complete part 1 . These are not same .
ruclips.net/video/qJLQkge0Kcg/видео.html
Plz make English videos so all of us can understand .
For English tutorial , you can visit link in description and read complete tutorial with source .
Reference for this tutorial -
bit.ly/2W3DcWa
@@TechnoSmarter thanks very helpful
Welcome
my data it says failed...what mistake i ve done?>
Something issue with your MySQL query in PHP . Check your insert query
@@TechnoSmarter $result = mysqli_query($mysql,"INSERT into form-2 values('$name','$lastname','$email')"); its totally fine ?
What about row I'd ?
Auto Increment or not
Not in your query as empty value
For more clarification visit tutorial
technosmarter.com/php/PHP-insert-data-in-database-and-display-in-table.html
Or ask question on our QA forum
where>
Word to word sab same hai but kuch nahi ho raha error bhi nahi aa rahi and database me store bhi nahi ho raha... please help me!!!
Check your MySQL query or post your question on our qa forum
@@TechnoSmarter okay
I have sent the question please reply asap because I have to do project based on this!!!
We provide support between 10 AM to 6 PM on our qa forum . You will receive answer soon between given time .
Error: mysqli_connect():(HY000/1045):Access denied for use 'exam'@'localhost'(using password: YES) sir aesii error aa rahi he..
Set correct connection details .
Check how to connect database
technosmarter.com/qa/506/how-to-connect-the-html-page-to-the-mysql-database-using-php
And
Inserting operation
technosmarter.com/php/PHP-insert-data-in-database-and-display-in-table.html
Koi bhi error nh aa rhi lekin record bhi save nh ho rha or else vali statement print ho rhi hai har baar
Iska matlab hain ki query m issue acche se check kijiye
Sir query me issue Kese check krte hai
Video main query dekho and apni query dekho match ho rahi h kya ya koi issue h .
Sir I am sorry. But ek choti si help or krdoo Muje ye bta do Kitne minit per query dikhai hai aapne Kyuki muje pahchan nh hai .plz sir
@@monusinghal8606 Query use kahte hain jo data ko insert karne ya fetch karne ke liye MYSQL database ke liye use ki jaati hain aapne . Aapne apne code main query create ki hogi use check kijiye -
query Like this with PHP -
$result = mysqli_query($cser, "INSERT INTO crud2(pname,pcode,pprice) VALUES('$pname','$pcode','$pprice')");
Reference ke liye aap is PHP tutorial ko bhi check kar sakte hain technosmarter.com/php/PHP-insert-data-in-database-and-display-in-table.html
isme fields different hain par kaam same hi hain insert and display in HTML table .
baaki koi bhi issue rahta hain to humare QA forum par question post kar sakte hain
QA forum ki link aapko description main mil jayegi .
Plzz Facebook par kis Naam se ho ye bta do sir plzzzzzzzzzzzz
Techno Smarter
Same name on facebook , Insta and twitter .
You can visit tutorial page
And comment
technosmarter.com/php/PHP-insert-data-in-database-and-display-in-table.html
source code pls??
technosmarter.com/php/PHP-insert-data-in-database-and-display-in-table.html
Sir aap Facebook par ho sir aap Ko messenger par code ki pic bejni thi
Share your issues
Error
Which type of error ?
dont working
Kindly share your issues
Sir failed likha Aara h
Check your query or connection file
@@TechnoSmarter sir aapko plz aap apna no de do m pic bej dunga code ku
Maine sab check kar liya
Try tutorial on site
technosmarter.com/php/PHP-insert-data-in-database-and-display-in-table.html
Aap Ko show kr dunga prblem
ok
Success message ata hi nhi or error bhi nhi ara he
Means aapke code behaviour main problem hain acche se check kijiye or nhi hua to fir dobara comment krna
@@TechnoSmarter nhi chal rha
Kya issue aa raha hain
@@TechnoSmarter failed a rha h
@@TechnoSmarter I think database is not connecting
Don't work :/
Kindly share your issues.
PLZZ reply de do sirr
Connection file ek bar hi bnti hai fir usi file ko hum sabhi page pe top pe at the beginning include kra lete hain .
For example watch registration and login form in php
ruclips.net/video/kinYAbkq8JE/видео.html
It shows success but the data's aren't inserted in the database
Check your table name and values .
@@TechnoSmarter it is correct bro but still it doesn't inserting the values
Use our qa forum and post your question with your code . Qa forum link in description . We will test your code and will answer you .
@@TechnoSmarter sure thing bro
vai thora sans lelo uske bad bolo video knowledgeable hai but ache se bolo
😊 Thanks for your feedback . Check latest videos.
You know.... If you are going to speak another language, at least have the common courtesy to say that in the title.
Sure but web tutorial in English language . You can check in description
You can check tutorial on our website
bit.ly/2W3DcWa
Language - English
please not everyone understands your language
If you are looking for English tutorial then check this tutorial on our website .
Language - English
technosmarter.com/php/PHP-insert-data-in-database-and-display-in-table.html
The failed message is coming data can not be saved
What's happening
Kindly check your query , database columns .
Aap Ko show kr dunga prblem
Sure you can show on facebook