₦airaland Forum

cant just find whats wrong with my insert statement

checked the types on my db and made sure its in the right order but no way out

its in the screenshot below

working with dynamic data which i looped through and escaped before inserting

pls help

3exe3:
cant just find whats wrong with my insert statement

checked the types on my db and made sure its in the right order but no way out

its in the screenshot below

working with dynamic data which i looped through and escaped before inserting

pls help

it is your mysql version

3exe3:
cant just find whats wrong with my insert statement

checked the types on my db and made sure its in the right order but no way out

its in the screenshot below

working with dynamic data which i looped through and escaped before inserting

pls help

Let the the screenshot of the insert code

youngpresidooo:
it is your mysql version

Thanks will try changing the version

ensure that all string values are quoted and integer values are not quoted

youngpresidooo:
it is your mysql version

That is wrong

Ensure the values are quoted

3exe3:
cant just find whats wrong with my insert statement

checked the types on my db and made sure its in the right order but no way out

its in the screenshot below

working with dynamic data which i looped through and escaped before inserting

pls help

Are we magicians, paste the full SQL queries,
Hian. na wa for person wey look for solution o

It's obviously a syntactic error...paste the statement here so we can debug. .can't remember the last time I used native queries sef. .except short ones though ..most ORM/ODM abstracts them

qtguru:
Ensure the values are quoted

private function getData($data)
{
foreach($data as $row => $value)
{
$this->rows[] = $this->escape($row);
$this->values[] = $this->escape($value);
}
}


protected function insert($table, $data)
{
$this->getData($data);
$sql = 'INSERT INTO '.$table.'('.implode(',', $this->rows).') VALUES ('.implode(',', $this->values).')';
if(!$this->query($sql))
{
return $this->error();
}
return $sql;
}



if(REQUEST_METHOD === 'POST')
{
$data = array(
'firstname' => (string)$_POST['firstname'],
'lastname' => (string)$_POST['lastname'],
'username' => (string)$_POST['username'],
'password' => (string)sha1($_POST['password']),
'email' => (string)$_POST['email'],
'gender' => (string)$_POST['gender'],
'phonenumber' => (string)$_POST['phonenumber'],
'address' => USER_LOCATION,
'date_joined' => date(DateTime::RFC2822),
'user_level' => 'user',
'is_verified' => 0
);
}

solved it

with

'\''.$this->escape($value).'\''

3exe3:
solved it

with

'\''.$this->escape($value).'\''

Use PDO my brother, I get it is a lot of code but it pays off in the long run. is this company work or personal project ? if personal project then continue

qtguru:
Use PDO my brother, I get it is a lot of code but it pays off in the long run. is this company work or personal project ? if personal project then continue

Personal

Why u asking

3exe3:
Personal

Why u asking

I was looking at Database Support, PDO will allow your port your code to any DB, and using Prepared statements is much safer, for real life projects you can't use this type of code. that's why I asked

3exe3:
Personal

Why u asking

Also A Company is looking for a PHP Developer, OOP Knowledge is mostly required, let me know later

qtguru:
Also A Company is looking for a PHP Developer, OOP Knowledge is mostly required, let me know later

in prophet isaiah voice 'Here I am send me".

I got what it takes thats what I mean by the way.

What do I need to do.

3exe3:
in prophet isaiah voice 'Here I am send me".

I got what it takes thats what I mean by the way.

What do I need to do.

send email to okeowo.aderemi@yandex.com so I can explain. Thanks

qtguru:
send email to okeowo.aderemi@yandex.com so I can explain. Thanks

sent it now as woyenghilabofa@outlook.com