Many feilds and stored procedure.

Codes here !

Moderators: egami, macek, gesf

Post Reply
marsheng
New php-forum User
New php-forum User
Posts: 5
Joined: Mon Jun 05, 2017 1:30 am

Wed Sep 06, 2017 3:41 am

I'm currently using something along these lines.

Code: Select all

    $add_bike = $conn->prepare('INSERT INTO bikes (MNZID,MemID) VALUES (?,?)'); 
    $add_bike->bind_param('ss',$mnzID,$memID);
    
    $mnzID = $_SESSION['mnzID'];
    $memID = $_SESSION['memID'];
    
    $add_bike->execute();  
 
I now have another update routine but I have 60 fields. They are along the lines ABC_01to ABC_60. Any way to make this easier than 60 sets of parameters and umpteen mistakes ?

User avatar
hyper
php-forum Active User
php-forum Active User
Posts: 498
Joined: Mon Feb 22, 2016 5:52 pm

Wed Sep 06, 2017 4:33 pm

Where is your data coming from, and how is it stored / generated?

marsheng
New php-forum User
New php-forum User
Posts: 5
Joined: Mon Jun 05, 2017 1:30 am

Thu Sep 07, 2017 3:19 am

I have 60 fields on an HTML form. All coming from $POST variables.

Post Reply