sql stuff

[VistaBoy]

okay i have tryed to make this for over 4 hours and still do not get how to do it so here i am

what i want to do is make a function that can make my sql stuff like this

$userq = select("*", "users", array('aid' => $this->cookies[aid], 'username' => $this->cookies[username], 'password' => $this->cookies[password], 'sesid' => $this->cookies[sid]));


$groupq = select("*", "groups", "group = '$this->user[group]'");

select(the fiealds or the *, what table , a array or the normal for WHERE);

thank you your help if you can give it.

[Agnostic Bear]

I've made it so it's just array('field' => 'value') not normal, it'll save time in the long run if you ever need to add anything. This should be near enough what you're looking for, took me a few minutes to whip it up.

<?php
function selectSql( $what, $from, $where = null )
{
    $what = ( $what === '*' ) ? '*' : '`' . $what . '`';
    $query = 'SELECT ' . $what . ' FROM `' . $from . '` ';
    if( is_array( $where ) )
    {
        foreach( $where as $key => $value )
        {
            $query .= '`' . $key . '` = \'' . $value . '\'';
        }
    }
    return mysql_query( $query );
}

?>

You'll have to clean the input yourself.

[VistaBoy]

Yo thank you but the bit i do not get is how to make array('field' => 'value','field2' => 'value2','field3' => 'value3') and that would be field = 'value' AND field2 = 'value2' AND field3 = 'value3' and so on.

[VistaBoy]

Sorry for two post but would some thing like this do it?

<?php
function select( $type = '*', $from, $where = null )
{
    $count = count($where);
    $i = 1;
    $query = 'SELECT ' . $what . ' FROM `' . $from . '` ';
    if( is_array( $where ) )
    {
        foreach( $where as $key => $value )
        {
            $query .= ' `' . $key . '` = \'' . $value . '\'';
            if($count > $i)
            {
                $query .= ' AND';
                $i++;
            }
        }
    }
    else
    {
            die('error in sql missing array');
    }
    return mysql_query( $query );
}

?>

[Agnostic Bear]

I've made it so it's just array('field' => 'value') not normal, it'll save time in the long run if you ever need to add anything. This should be near enough what you're looking for, took me a few minutes to whip it up.

<?php
function selectSql( $what, $from, $where = null )
{
    $what = ( $what === '*' ) ? '*' : '`' . $what . '`';
    $query = 'SELECT ' . $what . ' FROM `' . $from . '` ';
    if( is_array( $where ) )
    {
        foreach( $where as $key => $value )
        {
            $query .= '`' . $key . '` = \'' . $value . '\'';
        }
    }
    return mysql_query( $query );
}

?>

You'll have to clean the input yourself.

]

Oops sorry, forgot the AND part, but no that wouldn't do it, however this would:

<?php
function selectSql( $what, $from, $where = null )
{
    $what = ( $what === '*' ) ? '*' : '`' . $what . '`';
    $query = 'SELECT ' . $what . ' FROM `' . $from . '` ';
    if( is_array( $where ) )
    {
        foreach( $where as $key => $value )
        {
            $query .= '`' . $key . '` = \'' . $value . '\' AND ';
        }
        $query = preg_replace( '#AND $#', '', $query );
    }
    return mysql_query( $query );
}

?>

[VistaBoy]

Cool thanks as i want to learn from this how dose

$query = preg_replace( '#AND $#', '', $query ); 

like in how dose it know to remove the AND at the end??

[Agnostic Bear]

Cool thanks as i want to learn from this how dose

$query = preg_replace( '#AND $#', '', $query ); 

like in how dose it know to remove the AND at the end??

the $ = end of string, so it will only remove it if it matches "AND " then the end of the string.

[VistaBoy]

Umm ye i got an issue with it okay it only dose it with in classes funny?

okay this is my code

       $getkeyq = $this->db->select('*', 'keys', array('keycode' => $keycode));
        $getkeyf = $this->db->fetch_array($getkeyq);
        $getscriptq = $this->db->select('*', 'scripts', array('script' => $script));
        $getscriptf = $this->db->fetch_array($getscriptq);
            
        if($this->db->num_rows($getkeyq) == '1' && $this->db->num_rows($getscriptq) == '1' ) { 

and if i input the right data it still saying its not right like it not finding any rows but there is but when i tack out the mysql_query bit in my data_layer and echo the $getkeyf to see what it shows it shows "Resource id #8" and not a prober query???

[VistaBoy]

Sorry for two post but i fixed the error it was mt clean it was to go it sriped all the contents.