Validating MySQL queries on php

Question

Is it possible to get the query that it's being tried to be executed on PHP?

Here is the code i'm trying:

public static function executeInsertQuery($sqlQuery)
{
    $dbTable = mysql_query($sqlQuery, self::$_dbLink);

    if($dbTable === false){
        Models_Error::throwException("Connection to table failed.", 'database');
    }

    return null;
}

How can I validate that to be always an Insert into query?

Niet the Dark Absol · Accepted Answer · 2014-07-16 16:18:58Z

1

Don't rely on being passed a query.

In my current project, if I want to insert something, it looks like this:

DB::insert("tablename",array(
    "column" => "value",
    "col2"   => "val2",
    "foo"    => "bar"
));

This is then translated into a proper query (using PDO in this case, but that doesn't matter here)

answered Jul 16, 2014 at 16:18

Niet the Dark Absol

326k86 gold badges480 silver badges604 bronze badges

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

2 Comments

juanecabellob Over a year ago

thanks! I will try it that way, but anyways I'm interested in the validation process.

juanecabellob Over a year ago

I mean, it's absolutely better defining the functions so, that it's clear the function, but I find really interesting the validation process of large strings

Collectives™ on Stack Overflow

Validating MySQL queries on php

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related