How to select not null values from mysql table using pdo in php?

Asked Mar 01 '18 at 04:50

Active Mar 01 '18 at 05:10

Viewed 44 times

I am trying to create a base class for all my CRUD purposes. I have a method to create an array from all the input and table row parameters passed in the method to be executed in $query->execute. For that reason I was wondering if the below format will work.

$query = $pdo->prepare('SELECT * FROM table WHERE row = :row');
$query->execute(array(':row' => NOT NULL));

edited Mar 01 '18 at 05:02

asked Mar 01 '18 at 04:50

Nooglers BIT

SELECT * FROM table WHERE row is NOT NULL? – Your Common Sense Mar 01 '18 at 04:53
Yes, but for specific reasons I want to fetch the data using the format demonstrated above – Nooglers BIT Mar 01 '18 at 04:56
so you should post these reasons in the question to make it sensible – Your Common Sense Mar 01 '18 at 04:57

How to select not null values from mysql table using pdo in php?

0 Answers0