Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- // Configuration
- $DBHOST = "host"; //mysql host name
- $DBUSER = "user"; //database username
- $DBPASS = "pass"; //database password
- $DBNAME = "db"; //database name
- $database = fopen('text.csv', 'r+');
- $headers = fgetcsv($database);
- $unique = array();
- $queries = array();
- while( ($data = fgetcsv($database) ) !== FALSE ) {
- if( !in_array($data[0], $unique) ) {
- $queries[] = "UPDATE Product SET Custom1Ind = 1, Custom1Title = '" . $data[1] . "', Custom2Ind = 1, Custom2Title = '" . $data[2] . "' WHERE SKU = '" . $data[0] . "' AND StoreID = 24";
- $unique[] = $data[0];
- }
- }
- fclose($database);
- foreach( $queries as $query ) {
- //mysql_query( $query );
- echo $query."<br>";
- }
- ?>
Add Comment
Please, Sign In to add comment