How to insert all values frow row into mysql database using insert record?

Question

Hello i have a problem with my php where only the last value in the rows is inserted in the mysql database:Last value inserted from rows

mysql database only show the last value to be inserted from insert record

I want the three of the data to be inserted not only the last values... How do i do that?

here is my insert record behavior code:

 if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
 $insertSQL = sprintf("INSERT INTO ordering (productCode, Name, paymentMethod, Quantity, TotalPrice) VALUES (%s, %s, %s, %s, %s)",
                   GetSQLValueString($_POST['productcode'], "int"),
                   GetSQLValueString($_POST['Name'], "text"),
                   GetSQLValueString($_POST['PaymentMethod'], "text"),
                   GetSQLValueString($_POST['quantity'], "int"),
                   GetSQLValueString($_POST['totalprice'], "double"));

 mysql_select_db($database_perfume_connection, $perfume_connection);
 $Result1 = mysql_query($insertSQL, $perfume_connection) or die(mysql_error());

 $insertGoTo = "member_perfume_homepage.php";
 if (isset($_SERVER['QUERY_STRING'])) {
 $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
 $insertGoTo .= $_SERVER['QUERY_STRING'];
 }
 header(sprintf("Location: %s", $insertGoTo));
}

Community · Accepted Answer · 2017-05-23 10:27:04Z

1

Please show your html page from where you are sending post data. I think you should have to make an array of $_POST variables then you can get all the records at php side and you can insert all three records in table.

Try this

Please check the below link where you can find your solution Inserting Multiple Rows with PHP & MySQL

edited May 23, 2017 at 10:27

CommunityBot

11 silver badge

answered Oct 10, 2015 at 4:50

Shweta Patel

556 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

dreemax Over a year ago

hey, thank you for answering... I dont know how exactly to show html page... since im not so good at php because im mainly just doing this for school projects... can u show me how?i really ni to get this done before tuesday

dreemax Over a year ago

I tried that but i got so many errors.. + i dont understand that solution though in which to put where the coding is..

4EACH · Accepted Answer · 2015-10-10 05:32:01Z

0

Create Model that holds all table columns.

class OrderModel  extends BaseModel{

    public $id;
// Fill here all columns


    public function __construct($data) {
        foreach ($data as $key => $value) {
            $this->$key = $value;
        }
    }
public function get_table_name() {
return "ordering";
}
}

Create Base model class and put insert method in this class.

public function insert() {
        $dbh = DB::connect();
        $object_keys = array_keys(get_object_vars($this));
        $query = "INSERT INTO " . $this->get_table_name() . " (" . implode(',', $object_keys) . ") VALUES(:" . implode(',:', $object_keys) . ");";
        $sth = $dbh->prepare($query);
        foreach ($object_keys as $key) {
            $sth->bindParam(':' . $key, $this->$key);
        }
        $sth->execute();
        $this->id = $dbh->lastInsertId();
        return TRUE;
    }
$filtered_post = filter_input_array(INPUT_POST);
$order = New OrderModel($filtered_post);
$order->insert();

Use PDO instead mysql_ functions
Use Filter functions to filter POST Array

answered Oct 10, 2015 at 5:32

4EACH

2,1974 gold badges20 silver badges31 bronze badges

1 Comment

dreemax Over a year ago

Hey thank you for answering appreciate it... So what i nid to do?i copy back all of the codings and insert it in the php? or what?

Collectives™ on Stack Overflow

How to insert all values frow row into mysql database using insert record?

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest