[insert_php]<\/p>\n
$servername = “localhost”;
\n $username = “blueridg_bridge”;
\n $password = “kr~COSJQ7DP5”;
\n $dbname = “blueridg_bridge”;<\/p>\n
\/\/ Create connection
\n $conn = mysqli_connect($servername, $username, $password, $dbname);
\n if( mysqli_connect_errno() ){
\n echo “Failed to connect: “.mysqli_connect_errno();
\n }else{
\n $row = 0;<\/p>\n
if( ($csv = fopen(“products.csv”, “r”) ) !== FALSE ){
\n while ( ($data = fgetcsv($csv, 1000, “,”)) !== FALSE ){
\n $sqlData =””;<\/p>\n
$num = count($data);
\n if($row != 0){
\n for ($i=0; $i < $num; $i++){\n $sqlData = $sqlData.\"'\".$data[$i].\"',\";\n $dataId = $data[0];\n }\n $sqlData = substr($sqlData,0,-1);\n\n $query = 'SELECT * FROM bridge_products WHERE id = '.$dataId;\n\n $result = mysqli_query($conn, $query);\n\n if($result === FALSE) {\n die(mysqli_error());\n }else{\n $noRows = mysqli_num_rows($result);\n if($noRows > 0){
\n echo ‘Updating ‘.$data[1];
\n $sql = “UPDATE bridge_products SET name='”.$data[1].”‘, packaging='”.$data[2].”‘, regular_price='”.$data[3].”‘, wholesaler_price='”.$data[4].”‘, distributor_price='”.$data[5].”‘, promoting='”.$data[6].”‘, category='”.$data[7].”‘ WHERE id = “.$dataId;
\n if(mysqli_query($conn, $sql)){
\n echo ‘ — Done!
‘;
\n }
\n }else{
\n echo ‘Creating ‘.$data[1];
\n $sql = “INSERT INTO bridge_products (id, name, packaging, regular_price, wholesaler_price, distributor_price, promoting, category) VALUES (“.$sqlData.”)”;
\n if(mysqli_query($conn, $sql)){
\n echo ‘ — Done!
‘;
\n }
\n }
\n }
\n }<\/p>\n
$row++;
\n echo ‘
‘;
\n }
\n fclose($csv);
\n }
\n }<\/p>\n
[\/insert_php]<\/p>\n","protected":false},"excerpt":{"rendered":"
[insert_php] $servername = “localhost”; $username = “blueridg_bridge”; $password = “kr~COSJQ7DP5”; $dbname = “blueridg_bridge”; \/\/ Create connection $conn = mysqli_connect($servername, $username, $password, $dbname); if( mysqli_connect_errno() ){ echo “Failed to connect: “.mysqli_connect_errno(); }else{ $row = 0; if( ($csv = fopen(“products.csv”, “r”) ) !== FALSE ){ while ( ($data = fgetcsv($csv, 1000, “,”)) !== FALSE ){ $sqlData =””;…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1414","page","type-page","status-publish","hentry","no-sidebar"],"_links":{"self":[{"href":"https:\/\/blueridgefood.com\/index.php\/wp-json\/wp\/v2\/pages\/1414","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blueridgefood.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blueridgefood.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blueridgefood.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blueridgefood.com\/index.php\/wp-json\/wp\/v2\/comments?post=1414"}],"version-history":[{"count":0,"href":"https:\/\/blueridgefood.com\/index.php\/wp-json\/wp\/v2\/pages\/1414\/revisions"}],"wp:attachment":[{"href":"https:\/\/blueridgefood.com\/index.php\/wp-json\/wp\/v2\/media?parent=1414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}