Closed

Write a PHP script: Update mysql db from array using mysqli prepared statement

Hello,

I need an easy PHP script to update 1 column (start to update from first empty field with string data type) from array (line

by line, row by row) using mysqli prepared statement.

- column1 auto_increment

- need to set utf8

- need to free memory after query finish

- need the script right now

Example data table:

column1 column2 column3 column4

row1 1 bad red apple

row2 2 good black world

row3 3 fresh john

row4 4 screen five

row5 5 slow red

row6 6 hello gold

If the array have 4 lines than after update the table must be updated like:

column1 column2 column3 column4

row1 1 bad red apple

row2 2 good black world

row3 3 fresh first john

row4 4 screen second five

row5 5 slow third red

row6 6 hello fourth gold

If the array have 6 lines than after update the table must be updated like:

column1 column2 column3 column4

row1 1 bad red apple

row2 2 good black world

row3 3 fresh first john

row4 4 screen second five

row5 5 slow third red

row6 6 hello fourth gold

row7 7 fifth

row8 8 sixth

This example only for understanding the logic, columns and the length will be different.

Thank you.

Skills: MySQL, PHP

See more: red black data, write query, update mysql, sixth, mysqli, db query, Apple script, php data table, php table array, mysql script utf8, mysql update field, apple gold, mysql query slow, php mysql statement, mysql query example, mysql column row, php good update, php script utf8, fresh script, update db script

About the Employer:
( 25 reviews ) Sturovo, Slovakia

Project ID: #7115175

7 freelancers are bidding on average $8/hour for this job

krishdts

Greetings, This is Kris from DreamzTechUSA. Please open the chat room so we can discuss this in details. To get an idea of the quality of our work you can check the below link : [login to view URL] More

$10 USD / hour
(84 Reviews)
8.3
pytho

[login to view URL] ® Portfolio HERE, I have reviewed your project description and I am confident I can complete your website with all the customization you want to have integrated in the back-end. I am an experie More

$5 USD / hour
(33 Reviews)
6.8
techvolcano

Hi, We are experts in php/mysql and complete your query requirement. Ready to start now. Thanks.

$20 USD / hour
(161 Reviews)
6.3
Churaliya

Hello Sir, I have done many similar systems. So I can build this system to you easily. I can deliver this system to you in 2 days. Also Please check my feedback. Looking forward to hear from you soon. Thanks.

$2 USD / hour
(37 Reviews)
6.1
P3Multisolution

Hi There, You found the right contractor who is efficiently able to start the work on your project from right now and hope to deliver a quality end product to you. Although i would be needing one document from your More

$7 USD / hour
(0 Reviews)
0.0
caothanhha9

A proposal has not yet been provided

$10 USD / hour
(0 Reviews)
0.0
thisys

Our php/mysql experts can get this done within 2-3 days. No need to waiting longer, we are highly qualified professional readily available to get this done.

$5 USD / hour
(0 Reviews)
0.0