insert/update functions for mysql, what do you think?

Posted on 16th Feb 2014 07:03 pm by admin

I am working on two really simple functions that automatically generate (and execute) insert and update mysql queries and I have some questions:

Can there be any problems later on if functions treat numeric and string values the same? The function reports error if some value is neither numeric nor string (checked by using is_numeric and is_string functions), otherwise it just uses mysql_real_escape_string on all values in array and adds '' everywhere. Unlike microsoft access, mysql doesn't seem to care if you put '' on numeric value.

The simplest usage of insert function (for form data entry) would be:

db_insert('users', 'name,e_mail,bio', $_REQUEST);

First argument is table, another is the list of fields (separated by comma) , and third is the associative array of data that you want to insert.

Can you notice any problems?

Your Answer:

Login to answer

Other forums

SAP Treasury - Commodities
We are running SAP ECC 6.0 with Treasury Activated.
EA-FIN is also activated (SFW5).

Giving the below syntax error
Dear Experts,

I have used 2 buttons in gui status as display and cjhange.When the user wi

Problem with PHP/mySQL login code
Hello,

There is an error in my login script and I can't figure out what it is...
I believe

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
RTF fomatting to email content 
Im trying to sen an email with content is picked up from a rtf-file (file_get_contents('*.rtf'). Mai
MySQL-PHP Query Results Help 
Hello all. I'm hoping to be able to get some help in solving a problem with query/rowcount output. I
search function 
HI guys,

if anyone could point us in the right direction of how to do this, or provide some t
AJAX form submit 
I recently built a form that submits data to my database with an ajax function that is called throug
Loops and Classes 
I am making a template system and everything seems to be going well up until I have to loop in a var
socket communication between c++/java and sending image 
hi, 

i have a class in c++ called win32_sockserver which creates socket to java. i am trying