Welcome Guest, Not a member yet? Register   Sign In
Inserting data into mysql from a form(What everybody assumes every newbie ought to figureout for himself/herself).Help i
#1

[eluser]phpserver[/eluser]
View:::

myform.php

Controller

<?

class Arc extends Controller {
//Validation function included
function insert_into_mysql()
{

//Help

}

}
?>

Model

<?

class Model extends Controller{

function insert()
{
//help
}

}

?>

I have spent a whole week trying to insert data from a form into mysql,i have failed terribly.
I am used to using '$_POST[email]' format when posting data and nothing so far works.
I want to insert email and username into a database from a form as you can gather from above.
Will somebody come to my resque,its friday goddamn it,it has been a long five days.
#2

[eluser]Murodese[/eluser]
You're a bit mixed up. The controller defines functions that are uri-friendly, so in your case, you'd probably want it to look more like this;

Controller (arc.php):

Code:
class Arc extends Controller
{
    function Arc()
    {
        parent::Controller();
        $this->load->model('arc_model');
    }

    function create()
    {
        if ($this->input->post('submit')) // this assumes that your submit button is called "submit"
        {
            $this->arc_model->insert($this->input->post('username'), $this->input->post('email'));
        }
        else
        {
            $this->load->view('userform');
        }
    }
}

Model (arc_model.php):

Code:
class Arc_model extends Model
{
    function Arc_model()
    {
        parent::Model();
    }

    function insert($username, $email)
    {
        $data = array(
            'username' => $username,
            'email'    => $email
        );

        return $this->db->insert('tablename', $data);
    }
}

View (userform.php) would be whatever your html forms are (form names would be username, email and submit).

Set up like this, you'd go to http://baseurl/index.php/arc/create and give your form a submit of the same url, and it'd add the row to your db.
#3

[eluser]phpserver[/eluser]
where do the validation function come in our controller?.
#4

[eluser]Murodese[/eluser]
The validation functions would pretty much replace the if($this->input->post('submit')) that I have there. There's a lot of examples on the validation user guide page, check it out.

http://ellislab.com/codeigniter/user-gui...controller
#5

[eluser]phpserver[/eluser]
Thanks a lot Murodese.




Theme © iAndrew 2016 - Forum software by © MyBB