Any MySQL Sugar coat to lessen MySQL codes?

Mgccl

MySQL querys are hard, are they any sugar coat function make you only need to provide an array and it will automatically genorate the query for you? It will be very helpful.

thepeccavi

If you study them hard enough, MySQL queries are easy and useful... Basicly there are three types:

INSERT (makes a new row)
UPDATE (updates row(s) in a table)
and SELECT (gets data from a table)

If you study these, you will find MySQL queries easier and VERY useful...

As far as I know, there is not a function to do what you would like... you may have to build a custom function or get someone to do tbhat for you.
I can't be bothered to do that at the moment, and I think that you would be better doing it yourself (as it will give you experience with PHP and MySQL), but I'm sure that someone may do that for you...

Hope this helps!

madwormer2

I use phpMyAdmin to create my queries, and then I copy them into my code. That way I know it'll work.

Although clearly it's better to know how to do it without something generating code for you.

thepeccavi

As do I... phpMyAdmin isn't always the most effective, so it helps to know about the queries, for example, you may forget to leave the single-quotes around a variable name when you copy that query into your PHP code, so it always helps to know what you are doing...

This can be learned from practice, and everyone here will help you debug your queries...

Mgccl

I just made a sugar coat... haven't test it yet
here are the codes:
see if there is any error

function func_mysql_select_gen($select, $as, $from, $where, $order, $limit_offset, $limit_maxrow) {
$query = 'SELECT';
$i = 0
while ($select[$i]){
$query. = $select[$i];
if ($select[$i+1]) {
$query. = ', '
}
else {
$query. = ' ',
}
$i++
}
if ($as){
$query. = 'AS '.$as;
}
if ($from){
$query. = ' FROM '.$from;
}
if ($where
$query. = ' WHERE '.$where;
}
if ($order){
$query. = ' ORDER BY '.$order;
}
if ($limit_offset){
$query. = ' LIMIT '.$limit_offset;
}

if ($limit_maxrow){
$query. = ', '.$limit_maxrow;
}
return $query;
}

Rodney_H_

If you can write this function, and pass it the needed arguments, then writing a query without this should be easy...

I think what you are looking for is a DB class.