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?

Other php-forum

Inserting Data into a MS Access DB using PHP.
As part of my uni course I am doing a placement at a company whom want me to create a client zone fo

PHP and Javascript
Hi Guys,

Im trying to load the contents of an html file into a text area for editing, this is

DATEDIFF Question
First time post, and of course it is a help question.

I am using a WP plug-in to display prev

Help with echo()
I'm having some problems with this code:

Code: echo '
<A HREF="jav

this code is strange !
Hi i got this code from the web.. It checks for live and dead socks
It is working perfectly on my

help with variable
I've got a problem, i want to echo some images depending on the $id, however for me to get that id i

Can php detect connection speed and thereafter swap out elements?
No code to post, lads, yet. Just looking for a yay or nay at this stage:

Can a php script be

Specific name typed, specific image shown on html page
Hello,

Fairly new to PHP and was curious if someone might know how to solve a fairly simple r

array_combine() trouble w/csv file
I have a problem with a piece of code I wrote to import some records from a csv file into mysql. I h

help me fix these syntax errors...
I keep getting multiple syntax errors on this script like this one:

Parse error: syntax error