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

MySQL Primary key gap
Alright, so I have a table with 26 entries in it (id, filename, caption) for my image randomiser (ht

Google Map
I have done Google Map Integration for one my project. But for that we need the "latitude and l

Data type mismatch
Hi,
I am migrating data from algol to c.I mapped real datatype in algol to double datatype in

Error with login script
I am getting an error with my login script:

Error:
Code: Warning: Cannot modify header inf

php wont update my db
hello,

sorry for posting in mysql forum but i dont know where exactly is the problem but here

generating all possible random letters
hi'

how can i randomize the letters a,b,c,d,e all possible ways, and i want to print the res

Multi Level Array Problem
hi all,

For example I have array like below:

$temp = array(array('north america', 'us'

Add_Months not Easy to Understand
Oracle is number 1, very fast and very easy. But....
OK, I think but have a problem, only 1 pro

checkbox update
I am having a brain fart right now and i cant remember how to do this. if anyone could help that wou

want a code for uploading and downloading
i m trying to upload and download to my site..i need upload and download code ...i use a code for up