Display data in HTML table using MYSQL and PHP |Insert and fetch information | P - 2 |Tutorial - 56
HTML-код
- Опубликовано: 24 май 2019
- In this tutorial, we display data from MYSQL database in the HTML table using PHP. Insert data and fetch using MYSQL and PHP. In this tutorial, we create a PHP script for select data from database table and display in HTML table using PHP while loop. This is part 2.
Part 1 is here -
• Insert data into datab...
Reference for this tutorial -
bit.ly/2W3DcWa
PHP in Hindi -
PHP in Hindi | Arrays
bit.ly/2XSCsUB
Index array in PHP in Hindi
bit.ly/2LztlSe
PHP in Hindi |Two Dimensional Array
bit.ly/2JGc9bw
Associative array in PHP in Hindi
bit.ly/2Lz7Cde
PHP in Hindi| Array merge function
bit.ly/2JQM5t4
Complete PHP tutorials in Hindi
bit.ly/32IsMuI
bit.ly/2y0VFnI
PHP tutorials -
PHP file modes
bit.ly/2XCZgTz
Error handling mechanism in PHP
bit.ly/2Y4KogT
HTML form data convert into execel file using PHP
bit.ly/2M2whWX
Excel file data import into the database using PHP and MYSQL database
bit.ly/2Z5zwR8
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
. Наука
This is exactly what people want
Thanks sir for help my project
Welcome anytime
Bohot acha laga aapka video.
Thank you
Superb thank you ❣️
Most welcome.
Best work ...
Thank you ❤
Thank you sir...
Welcome
Impressive 👍👍🙏🙏
Thank you
Good work 👍
Thank you
me yhi problem face kr rha tha itni der se and got this video after 1-2hrs and my problem only solved with in 8 mints :))2:24am -2:32am
Great !
thnk you
Welcome
Hello Sir, I have a problem that I have two tables of one database i.e. cnp and pdp. Now I have created two php page, One page have two form fields Initial Budget and No. of people with Next button and it stored the field data in cnp table. Second php page also have many form fields but it has also common fields of first php page i.e. Initial Budget and No. of people. It stores its data in pdp table.
Now my question is that I wanna fetch the data from cnp table into the second php page's form field which has common field Initial Budget and No. of people. When the second page run then it should already fill with the data of Initial Budget and No. of people that's data in the cnp table. So please tell me how can fetch my data in form field from one table to another table of one same name database????
Waiting for your best reply...
Thanks & Regards
I can understand . You have two tables with same fields . Hey use join and join both table with same column . It will help you get dara from both table . You will be able select data from both table and display where you want .
Join both tables and select, display in form fields using one query .
@@TechnoSmarter I have already joined them but it's not working. Sometimes it shows error and sometimes it runs but data doesn't fetch from the database. Can u please write the code as assuming an example and tell me where I can put it in php coding??
Hey use our qa forum and description your complete need there . Our qa forum link in description . You will get better solution there with code .
@@TechnoSmarter When we fill the Initial Budget and No. of people in first php page then it stores the data in first table but these form fields are also available in second php page. And I wanna fetch this data for this second php page from the first table so that when I redirect from first php page to second php page then it has already filled with the data. Please write the code for help me out. You can assume your example.
Hey kindly use our qa forum . You will get better solution there . Ask question and describe about tables , issue , need .
technosmarter.com/qa
Can you help me ?
I want when i click a button from home.php (button name accepted requests) then it shows a table from my database
For that use PHP and AJAX on click button .
Like - button clicked
Then ajax executes onclick
Then display data from the database without page refresh on button click .
I have a question, plz help me,
I have a data in MS Access format (.mdb), now I want to show this data on html page using one search.
Plz help how i can call my data & shown at html page.
Thnx
Use our Q&A forum to get exact solution . Describe your think and get solutions there . QA Link in description or search techno smarter qa on google . You will get better solution
This question got answeres here - technosmarter.com/qa/490/show-database-records-on-html-page-on-search-button-using-php
Thanks
Welcome
Please teach me how to create form to enter data in two related tables having foreign key
Use our qa forum and ask this question with description .
Qa forum link in description .
Learn there .
Hey! What to do if i want to display entries in a different page?
Create a page show.php or display.php for example .
Then fetch data from the table .
First include config.php at the top
Fetch data by query . Use select query .
Display using while loop.
Done .
@@TechnoSmarter thank you so much 🙏
Hello sir why we use id and DESC and what is DESC ???
We provide unique I'd number to every row to implement logics like fetch row by id , update row by id etc .
DESC stands for Descending order .
If you want to fetch data from last inserted row . This is an order starts from id like 5,4,3,2,1 .This is newest data order . You can use ASC stants for Ascending Order . Opposite of DESC . This is oldest data order .
Thankyou so much sir for Helping 👍👍❤
I want to insert the fetch data to another html page in a table. How can I do that???
Create another file fetch.php and remove fetch code from the insert.php file .
In fetch.php
Include config file
Then select query code line
And then
data into table code .
Load fetch.php file . You will see data on another fetch.php file rather than insert.php
Thanks Sir, but one doubt is how to get Some text .My question is how to post div name or get div content.i.e $hold=$_POST['my_div'];echo $hold; not working.
Use AJAX to get data by div id or class .
Aslo you can use textarea . Set name of textarea and get value on post without ajax .
thanks for this sir. no need to english code speak for it.
You are welcome
Where to get video of update query
Update operation
ruclips.net/video/CVZ76bstYxE/видео.html
@@TechnoSmarter 🤩🤩🤩🥳🤗🤗Thanku sir
Welcome
how to insert data from sql to html page sir
If you want fetch data from mysql database and display in html page then follow the same video or start from first video here - insert an display on html page. .
ruclips.net/video/sZoeVfeTqM8/видео.html
Hi Sir,I have a question?,Can you please help me ,How to display the fetched data in another page
Create another page like show.php and fetch and display data .
Fetch by select query
Display by while loop
On any page .
@@TechnoSmarter Thank you Sir!
@@sececsea8936 hy bro can you send me code ?
Here.
technosmarter.com/php/PHP-insert-data-in-database-and-display-in-table.html
mysqli_fetch_array in php while loop is not working
Check your query .
Hii,
Jab me sirf refresh karta hu tab automatically data insert hota hai vahi data bar bar insert hota refresh karne ke bad form me kuch nahi dala to bhi
Uske liye aap condition laga dijiye mobile number already and values ka validation kijiye variable ki value empty ho to message show kre and form submit na ho
Your site is not working how i can get source code?
We have resolved that issue. Please check again.
part 1 link
Part 1 is here
ruclips.net/video/sZoeVfeTqM8/видео.html
How i can get source code?
Kindly check reference tutorial link in description box.
display data one name ko input lekar dusre pej pe kase le ja sakte he
Sessions ke through aap kitne bhi page par data le ja sakte h
technosmarter.com/php/Session-in-PHP.html
Tutorial for example
technosmarter.com/php/registration-and-login-form-in-php-and-mysql
Video example
ruclips.net/video/kinYAbkq8JE/видео.html
Some text .How do i find hello world using only PHP.No javascript ajax or else.
Use textarea instead of div in php.
It says Fatal error: Uncaught TypeError: mysqli_fetch_array()
Check your query syntax
Check array syntax
Check connection variable
Should be correct .
Sir Kya karu
Edit column then click AI and save
Iska Kya karu
??
Sir database me 0 ki entry aari hai
Id ko autoincrement bnao .
@@TechnoSmarter autoincreament kaise bnao sir bta do
Edit column then check on AI then save .
0 ki entry kyu aari h sir plzzzzzzzzzzzz btaye
Edit column then click AI and save
@@TechnoSmarter sir ye AI Kya likha aapne
Plzz btana sir aur ye Jo coloumn bnaye h unhe change karu
Yes change pe click kro
Then vahan pe AI likha hota h usme tick krke save krdo
AI means Autoincrement
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, array given in. This is showing then I run the program
Check your MYSQL query . I think there is a problem with your Mysql query .
Or ask your question and share your description with tried code .
Use our QA forum for best support
QA forum link in description .
That is my same problem
@@nandinipaliwal4371 I can get your point . You can use our QA forum for easy solution .
How to ask and get solution ?
ruclips.net/video/x2WQNyItqDU/видео.html
If you have any problem then you have to try our QA forum .
Techno Smarter QA
Thanks for watching
We are here to help you . You can discuss anything .
Check connection variable . The connection variable should be the same as config file . Use same connection variable in queries . That's why , you are getting this error .
Or share your Codes on techno smarter qa forum . You can search on google " techno smarter qa" and create a question and describe with codes .
You will get solution there .
i m also getting same error sor while i executing code
english
For English , go to the tutorial page
technosmarter.com/php/PHP-insert-data-in-database-and-display-in-table.html
i am not getting dob in table it is printing as 00-00-0000
Kindly check your $dob variable value and insert into the database for dob column using mysql query.
@@TechnoSmarter u mean length right... What should be value for that
No need to add length for datatype date.
dob datatype = date
Get value from the form. You have to create a datepicker using
then give a name
hold value using post method .
$dob=$_POST['dob'];
then insert this value in database using insert query.