- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How can we handle NULL values stored in a MySQL table by using PHP script?
We can use the if...else condition in PHP script to prepare a query based on the NULL value. To illustrate it we are having the following example −
Example
In this example, we are using the table named ‘tcount_tbl’ having the following data −
mysql> SELECT * from tcount_tbl; +-----------------+----------------+ | tutorial_author | tutorial_count | +-----------------+----------------+ | mahran | 20 | | mahnaz | NULL | | Jen | NULL | | Gill | 20 | +-----------------+----------------+ 4 rows in set (0.00 sec)
Now, the following is a PHP script that takes the value of ‘tutorial_count’ from outside and compares it with the value available in the field.
<?php $dbhost = 'localhost:3036'; $dbuser = 'root'; $dbpass = 'rootpassword'; $conn = mysql_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('Could not connect: ' . mysql_error()); } if( isset($tutorial_count )) { $sql = 'SELECT tutorial_author, tutorial_count FROM tcount_tbl WHERE tutorial_count = $tutorial_count'; } else { $sql = 'SELECT tutorial_author, tutorial_count FROM tcount_tbl WHERE tutorial_count IS $tutorial_count'; } mysql_select_db('TUTORIALS'); $retval = mysql_query( $sql, $conn ); if(! $retval ) { die('Could not get data: ' . mysql_error()); } while($row = mysql_fetch_array($retval, MYSQL_ASSOC)) { echo "Author:{$row['tutorial_author']} <br> ". "Count: {$row['tutorial_count']} <br> ". "--------------------------------<br>"; } echo "Fetched data successfully
"; mysql_close($conn); ?>
- Related Articles
- How can we create a MySQL table by using PHP script?
- How can we create a MySQL temporary table by using PHP script?
- How can we delete an existing MySQL table by using PHP script?
- How can we delete a MySQL database by using PHP script?
- How can we select a MySQL database by using PHP script?
- How can we insert data into an existing MySQL table by using PHP script?
- How can we create a new database by using PHP script?
- How can we update the values in one MySQL table by using the values of another MySQL table?
- How can we handle a result set inside MySQL stored procedure?
- How can we find the duplicate values available in a MySQL table by using JOINS?
- How can we update values in a MySQL table?
- How can we write PHP script to count the affected rows by MySQL query?
- How can we fetch all the data from MySQL table by using mysql_fetch_array() function, returning an array with the numeric index, in PHP script?
- How can we display all the records from MySQL table with the help of PHP script?
- How MySQL stored function evaluates if it got NULL value while using the dynamic values from a table?

Advertisements