Unlock the Power of Open Source! The " Linux New " SWAYAM Plus Course is live now and about 2,500 learners have already registered for it.

If you are a registered learner, the forum page is now active. Visit the page and get all your questions answered.

MySQL Part 4 - English

This is a sample video. To access the full content,
please Login

Questions posted on Forums
PHP and MySQL Tutorials - English

Questions posted on ST Forums:

could you please demo or give example to store and retrieve image in MySql?
hello sir, Through out the second level you taught how to store data , i.e only text data, today I came to know that we can store and retrieve images and display them on our webpage if so could you please make a demo for me or could you please give me a link to do that, all using php? please.....
Velu.N

Answer last updated on: Jan. 7, 2015, 7:37 p.m.

57

Outline:
MySQL (Part 4)

Getting data from the database table and displaying it.
SELECT QUERY - SELECT * FROM table_name WHERE att1='abc' // Query returns the value from the database where att1 = abc
mysql_num_rows() - Gives us the number of rows there are in the query we have just given out.
ORDER BY - Helps to order the output result as when selecting the values form the database. Use of DESC for Descending ordering / ASC for Ascending ordering

Width:	860	Height:	480
Duration:	00:07:28	Size:	5.6 MB

Show video info

Pre-requisite

MySQL Part 3

Assignment

Code files

mysql_part_4/
mysql_part_4/connection.php
mysql_part_4/member.php
mysql_part_4/mysql.php
mysql_part_4/mysql_part_4.txt
mysql_part_4/phpacademy1.sql.zip

Script

Timed Script

Slides

php/
php/3t-logo.pdf
php/php.pdf
php/php.tex

Spoken Tutorial, created on or before 31 Jan. 2025, by IIT Bombay is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License, except where stated otherwise
Based on a work at https://spoken-tutorial.org. Permissions beyond the scope of this license may be available at https://spoken-tutorial.org.

EduPyramids has repurposed some courses, which are now available on the main page. The older version of these courses can be accessed through https://spoken-tutorial.org/archived/.

Spoken Tutorial, developed at IIT Bombay, is brought to you by EduPyramids Educational Services Private Limited (DBA: EduPyramids Educational Services Pvt Ltd.). EduPyramids Educational Services Private Limited is currently incubated at SINE IIT Bombay. All transactions will be processed under the name EduPyramids Educational Services Private Limited.