Jump to content

alvarogtc

New Members
  • Posts

    1
  • Joined

  • Last visited

Posts posted by alvarogtc

  1. how i can make a insert using this fuctions I m learning php, as using this functions (mysqli abstract) but after update wont work any more.



    /** insert data array */
    public function insert(array $arr)
    {

    if ($arr)
    {
    $q = $this->make_insert_query($arr);
    $return = $this->modifying_query($q);
    $this->autoreset();
    return $return;
    }
    else
    {
    $this->autoreset();
    return false;
    }
    }

    complement



    /** insert query constructor */
    protected function make_insert_query($data)
    {
    $this->get_table_info();
    $this->set_field_types();
    if (!is_array(reset($data)))
    {
    $data = array($data);
    }
    $keys = array();
    $values = array();
    $keys_set = false;
    foreach ($data as $data_key => $data_item)
    {
    $values[$data_key] = array();
    $fdata = $this->parse_field_names($data);
    foreach ($fdata as $key => $val)
    {
    if (!$keys_set)
    {
    if (isset($this->field_type[$key]))
    {
    $keys[] = '`' . $val['table'] . '`.`' . $val['field'] . '`';
    }
    else
    {
    $keys[] = '`' . $val['field'] . '`';
    }
    }
    $values[$data_key][] = $this->escape($val['value'], $this->is_noquotes($key), $this->field_type($key), $this->is_null($key),
    $this->is_bit($key));
    }
    $keys_set = true;
    $values[$data_key] = '(' . implode(',', $values[$data_key]) . ')';
    }
    $ignore = $this->ignore ? ' IGNORE' : '';
    $delayed = $this->delayed ? ' DELAYED' : '';
    $query = 'INSERT' . $ignore . $delayed . ' INTO `' . $this->table . '` (' . implode(',', $keys) . ') VALUES ' . implode(',',
    $values);
    return $query;
    }

    before update this class i used to insert data like this



    $db = Sdba::table('users');
    $data = array('name'=>'adam');
    $db->insert($data);

    this method of insert dont works on new class. if i try like this i got empty columns and empty values.


    thanks for any help complete class download http://goo.gl/GK3s4E


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.