MySQL Use Array From Non Existent Column

Question

I'm not sure if my title is even worded correctly. Hopefully I can explain this in a concise manner. I'm trying to select all from a database:

if (! empty ( $fname ) && ! empty ( $lname )) {
        $query5 = "select * from " . $db_prefix . "customer_det where (fname = '" . $fname . "' and lname = '" . $lname . "')";
            $result5 = $mysqli->query ( $query5 ) or die ( mysql_error () );
    } else {
        $query5 = "select * from " . $db_prefix . "customer_det where phone = '" . $phone . "'";

        $result5 = $mysqli->query ( $query5 ) or die ( mysql_error () );

    }

Then my next statement basically says if $result5 === NULL then insert stuff. Problem is I'm var_dump($result5) and it looks like it's printing out an array.

object(mysqli_result)#4 (5) { ["current_field"]=> int(0) ["field_count"]=> int(34) ["lengths"]=> NULL ["num_rows"]=> int(0) ["type"]=> int(0) }

Basically what I'm trying to say is how can I write an IF $result5 = non existent statement. Is it a count or num_rows function im looking for here?

Jason McCreary · Accepted Answer · 2012-11-06 21:18:37Z

1

mysqli_query() returns a mysqli_result object.

You want to check one of it's properties not for null, for example:

if ($result5->num_rows == 0)

Note: I also encourage you to read about SQL Injection.

edited Nov 6, 2012 at 21:18

answered Nov 6, 2012 at 21:13

Jason McCreary

73.3k23 gold badges140 silver badges177 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

smada Over a year ago

Thanks Jason I'll go ahead and try that. This is the first time using the improved MySQLi module after three weeks using PHP 4.8 without MySQLi, etc

Jason McCreary Over a year ago

No worries. If you are new mysqli, you may want to jump straight to PDO. Be a better PHP Developer.

smada Over a year ago

Jason, I read your comments on that blog. Why do you advocate PDO over MySQLi? I've seen a little documentation on both and I have an entire volume of OReilly and Apress books on both but I'm curious if there's more benefits with PDO. I did read that the PDO connector does work with a number of databases. I have read all about SQL injection and sanitizing input. I have some form validation regarding the input boxes. I've seen the real escape functions, etc. Fortunately or unfortunately, what I'm coding is in a protected area. A user account would have to be compromised first.

Jason McCreary Over a year ago

Why don't you move your comment to that post and we'll continue our discussion there.

Collectives™ on Stack Overflow

MySQL Use Array From Non Existent Column

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related