function process_spreadsheet($path) { $keys = array(); $newArray = array(); $data = csv_to_array($path, ','); // Set number of elements (minus 1 because we shift off the first row) $count = count($data) - 1; //Use first row for names $labels = array_shift($data); foreach ($labels as $label) { $keys[] = $label; } // Add Ids, just in case we want them later $keys[] = 'id'; for ($i = 0; $i < $count; $i++) { $data[$i][] = $i; } // Bring it all together for ($j = 0; $j < $count; $j++) { $d = array_combine($keys, $data[$j]); if (!is_empty_str($d["ID"])) { // $newArray[$j] = $d; $newArray[$d["ID"]] = $d; } } return $newArray; }
/** * Run the database seeds. * * @return void */ public function run() { function csv_to_array($filename = '', $delimiter = ',') { if (!file_exists($filename) || !is_readable($filename)) { return FALSE; } $header = NULL; $data = array(); if (($handle = fopen($filename, 'r')) !== FALSE) { while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE) { if (!$header) { $header = $row; } else { $data[] = array_combine($header, $row); } } fclose($handle); } return $data; } $csvFile = public_path() . '/csvs/categories.csv'; $datas = csv_to_array($csvFile); DB::table('categories')->delete(); foreach ($datas as $data) { Categories::create($data); } }
/** * Run the database seeds. * * @return void */ public function run() { function csv_to_array($filename = '', $delimiter = ',') { if (!file_exists($filename) || !is_readable($filename)) { return FALSE; } $header = NULL; $data = array(); if (($handle = fopen($filename, 'r')) !== FALSE) { while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE) { if (!$header) { $header = $row; } else { $data[] = array_combine($header, $row); } } fclose($handle); } return $data; } $csvFile = public_path() . '/exams.csv'; $areas = csv_to_array($csvFile); DB::table('exams')->insert($areas); }
function print_hotels() { $hotels = csv_to_array('hotels.csv'); foreach ($hotels as $hotel) { #var_dump($hotel); $shorttel = str_replace(' ', '', $hotel["tel"]); $img = isset($hotel["img"]) && $hotel["img"] ? $hotel["img"] : 'generic_hotel.jpg'; echo <<<EOL <div class='hotel'> <a class='imga' href="img/hotels/{$img}"> <img src="img/hotels/_{$img}" /> </a> <h3>{$hotel["name"]}</h3> <div class="address"> {$hotel["street"]}<br> {$hotel["loc"]} </div> <a class="web" href="{$hotel["url"]}">{$hotel["url"]}</a> <a class="mail" href="mailto:{$hotel["email"]}">contact</a> <a class="tel" href="tel:{$shorttel}">{$hotel["tel"]}</a> </div> EOL; } }
protected function csv_to_array($data) { if (defined('STRICT_TYPES') && CAMEL_CASE == '1') { return (array) self::parameters(['data' => DT::TEXT])->call(__FUNCTION__)->with($data)->returning(DT::TYPE_ARRAY); } else { return csv_to_array($data); } }
function pre_import($filename) { $results = array(); foreach (csv_to_array($filename, FALSE) as $csv) { #var_dump($csv); $results[] = array('firstname' => $csv[1], 'lastname' => $csv[2], 'phone' => $csv[3], 'email' => $csv[4]); } return $results; }
public function createBits($csv) { #load csv to an array $local = csv_to_array($csv); foreach ($local as $singleBit) { $container = array_values($singleBit); $T = new BitWord(); $T->setWord(trim($container[0])); $T->setDefinition(trim($container[1])); $T->setSynonym(trim($container[2])); #ADD INITIALIZED BIT TO bit property array $this->bits[] = $T; unset($T); } }
function uploadFiletoDB($UserFileName) { $TransactionArray = array(); $TblName = TableName; $FileName = $_FILES[$UserFileName]['name']; $FileServerName = $_FILES[$UserFileName]['tmp_name']; $CSVFIle = 'transactionTable.csv'; $CSVDelimiter = ';'; $ValidRecordswrited = 0; $InvalidRecords = 0; if (getFileExtension($FileName) == 'xlsx') { convertXLStoCSV($FileServerName, $CSVFIle); $CSVDelimiter = ','; } else { $CSVFIle = $FileServerName; } $TransactionArray = csv_to_array($CSVFIle, $CSVDelimiter); if (sizeof($TransactionArray) > 100000) { echo '<br>'; echo "Error - file rows cont is to much"; return false; } $Connection = mysql_connect(ServerName, UserName, Password); $db_selected = mysql_select_db(DBName, $Connection); if (!$Connection) { die("Connection failed: " . mysql_error()); } foreach ($TransactionArray as $Line) { if (checkTransactionRecord($Line)) { $Request = "INSERT INTO {$TblName}(`Account`, `Description`, `CurrencyCode`, `Ammount`) VALUES ('{$Line['Account']}','{$Line['Description']}','{$Line['CurrencyCode']}',{$Line['Amount']})"; $result = mysql_query($Request); if (!$result) { echo 'Query error: ' . mysql_error(); } else { $ValidRecordswrited++; } } else { $InvalidRecords++; } } mysql_close($Connection); echo '<br> <br>'; echo "Valid records writed to DataBase: {$ValidRecordswrited}"; echo '<br>'; echo "Invalid records count: {$InvalidRecords}"; }
<?php $sDestinationFile = __DIR__ . '/../languages.php'; $aSourcesFiles = array('languages' => __DIR__ . '/Languages.csv', 'directionalities' => __DIR__ . '/LanguagesDirectionality.csv', 'scripts' => __DIR__ . '/LanguagesScripts.csv'); $aData = csv_to_array($aSourcesFiles['languages']); $aDirectionalitiesSrc = csv_to_array($aSourcesFiles['directionalities']); foreach ($aDirectionalitiesSrc as $sLanguageCode => $aDirectionality) { if (isset($aData[$sLanguageCode])) { $aData[$sLanguageCode]['Directionality'] = $aDirectionality['Directionality']; } } $aScriptsSrc = csv_to_array($aSourcesFiles['scripts']); foreach ($aScriptsSrc as $sLanguageCode => $aScript) { if (isset($aData[$sLanguageCode])) { $aData[$sLanguageCode]['Script'] = $aScript['Script']; } } file_put_contents($sDestinationFile, "<?php\n\nreturn " . var_export($aData, true) . ";\n"); /** * Convert a comma separated file into an associated array. * The first row should contain the array keys. * * Example: * * @param string $sFilename Path to the CSV file * @param string $sDelimiter The separator used in the file * @return array * @link http://gist.github.com/385876 * @author Jay Williams <http://myd3.com/> * @copyright Copyright (c) 2010, Jay Williams * @license http://www.opensource.org/licenses/mit-license.php MIT License
function csv_to_array($filename = '/Users/emmanuel.manyike/Desktop/use.csv', $delimiter = ';') { if (!file_exists($filename) || !is_readable($filename)) { echo "file does not exist\n"; } $header = NULL; $data = array(); if (($handle = fopen($filename, 'r')) !== FALSE) { echo "file exist\n"; $handle2 = fopen('/private/var/www/spree.local/htdocs/app/code/local/Touchlab/SpreeDbUpdates/data/spreedbupdates_setup/data-upgrade-0.1.52-0.1.53.php', 'w'); $counter = 0; while ($row = fgets($handle)) { $row = trim($row, "\r\n"); $sizedata = explode(';', $row); $string = "UPDATE eav_attribute_option SET sort_order = {$sizedata['1']} WHERE option_id = {$sizedata['0']}; " . PHP_EOL; if ($handle2) { fwrite($handle2, $string); } else { echo "inside else"; echo $string; } } echo "done bro"; fclose($handle2); fclose($handle); } return $data; } //UPDATE eav_attribute_option SET sort_order = 0 WHERE option_id = 832; $csvData = csv_to_array();
<?php require_once "functions.php"; // Get array from CSV $str = stripslashes($_POST["csv"]); $data = csv_to_array($str); // Find row with the most columns $col_count = 0; foreach ($data as $row) { $col_count = count($row) > $col_count ? count($row) : $col_count; } ?> <div class="fog"></div> <div class="edit_table" style="display:none;"> <div class="modal_window_header" class="clearfix"> Edit Table <a class="close_modal" href=""></a> </div> <div class="edit_table_content"> <table> <tr> <td class="row_selector blank"></td> <?php for ($col = 0; $col < $col_count; $col++) { ?> <td class="column_selector"><?php echo num_to_chars($col + 1);
<?php $news = csv_to_array('data/science_advisory_committee.csv'); // sort by date, newest on top function compare_lastname($a, $b) { return strnatcmp($a['last_name'], $b['last_name']); } usort($news, 'compare_lastname'); echo "<ul>\n"; foreach ($news as $v) { echo " <li>{$v['first_name']} {$v['last_name']}</li>\n"; } echo "</ul>\n";
<?php require_once "./includes/db_connection.php"; require_once "./includes/cvsProcess.php"; ?> <?php $the_array[] = csv_to_array('transactions.csv'); foreach ($the_array as $array_row) { foreach ($array_row as $array_element) { //echo print_r($array_element); // echo $array_element['Date']; // echo "<br>"; $trans_date = $array_element['Date']; $original_description = addslashes($array_element['Original Description']); $amount = $array_element['Amount']; $transaction_type = $array_element['Transaction Type']; $trans_date = date("Y-m-d", strtotime($trans_date)); $query = "INSERT INTO mintImport (trans_date, original_description, amount, transaction_type)\n VALUES ('{$trans_date}', '{$original_description}', '{$amount}', '{$transaction_type}')"; $result = mysqli_query($connection, $query); if (!$result) { die("Database query failed."); } } } #print_r($_GET) #echo $deviceName; # ?deviceName=devicenamed&sensorName=sensorNamed&sensorReading=32
// on récupère la liste des images contenues dans le répertoire des tiles $tiles = find_all_files($TILES_DIR); $tilesImg = array(); foreach ($tiles as $index => $filename) { if ($filename == $IMG_SPACE) { unset($tiles[$index]); } else { $tilesImg[] = imagecreatefromstring(file_get_contents($TILES_DIR . $filename)); } } // on charge l'image contenant les espaces $spaceImg = imagecreatefromstring(file_get_contents($TILES_DIR . $IMG_SPACE)); // on récupère le contenu du fichier CSV $fileContent = file_get_contents($FILE_FACES); // on extrait le contenu CSV dans un tableau $tabFaces = csv_to_array($fileContent, $CSV_DELIMITER); // génération des images // on va calculer les dimensions des images pour chaque face $scale = $TILE_HEIGHT / $TILE_HEIGHT_M; foreach ($tabFaces as $index => $faceInfos) { // HEIGHT $faceInfos['img_height'] = $TILE_HEIGHT; // WIDTH : conversion en fonction des mètres $faceInfos['img_width'] = round($faceInfos['length'] * $scale); // FILE NAME $faceInfos['filename'] = $faceInfos['code'] . "_" . $faceInfos['face'] . ".png"; // on calcule le nombre de tiles qu'il faut mettre dans l'image $nbTiles = floor($faceInfos['img_width'] / $TILE_WIDTH); // on calcule le nombre d'espaces if ($nbTiles > 0) { $nbSpaces = $nbTiles - 1;
foreach ($gcdata as $k) { $p[] = $count == 0 ? '"' . $k . '"' : $k; $count++; } $chart_data[] = "[" . implode(",", $p) . "]"; } foreach ($gheader as $d) { $header_data[] = '"' . $d . '"'; } $header_data = "[" . implode(",", $header_data) . "]"; $chart_data = implode(",", $chart_data); $full_chart_data = "[" . $header_data . "," . $chart_data . "]"; return $full_chart_data; } $DataFile = $_SERVER['DOCUMENT_ROOT'] . "/googlechart/tread.csv"; $GChartData = csv_to_array($DataFile); $full_chart_data = BuildDataTable($GChartData['data'], $GChartData['header']); ?> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript"> google.load("visualization", "1", {packages:["corechart"]}); google.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable(<?php echo $full_chart_data; ?> ); var options = { title: '',
function load_countries_from_csv($file_name) { $tmp = csv_to_array($file_name); $cntryarr = array(); foreach ($tmp as $line) { $cntryarr[$line["iso"]] = $line["name_en"]; } unset($tmp); return $cntryarr; }
$( document ).ready(function() { $("your-circle").circliful({ animationStep: 5, foregroundBorderWidth: 5, backgroundBorderWidth: 15, percent:' . $value['Percent'] . '}); }); </script>'; if ($value['Percent'] <= 50) { echo "<tr>"; echo "<td><img src ='images/CapstoneImages/{$value['Team One']}.png' style = 'opacity:0.4;'>"; echo "{$value['Team One']}</td>"; echo "<td>{$value['Percent']}%</td>"; echo "<td><img src ='images/CapstoneImages/{$value['Team Two']}.png'>"; echo "{$value['Team Two']}</td>"; echo '</tr>'; //echo $donut; } else { echo "<tr>"; echo "<td><img src ='images/CapstoneImages/{$value['Team One']}.png'>"; echo "{$value['Team One']}</td>"; echo "<td>{$value['Percent']}%</td>"; echo "<td><img src ='images/CapstoneImages/{$value['Team Two']}.png' style = 'opacity:0.4;'></td>"; echo "<td>{$value['Team Two']}</td>"; echo '</tr>'; } } $gameData = csv_to_array('final_results_.csv'); $team_one = $_POST['Home']; $team_two = $_POST['Away']; showResults($gameData, $team_one, $team_two);
* * Example: * * @param string $filename Path to the CSV file * @param string $delimiter The separator used in the file * @return array */ function csv_to_array($filename = '', $delimiter = ',') { if (!file_exists($filename) || !is_readable($filename)) { return FALSE; } $header = NULL; $data = array(); if (($handle = fopen($filename, 'r')) !== FALSE) { while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE) { if (!$header) { $header = $row; } else { $data[] = array_combine($header, $row); } } fclose($handle); } return $data; } /** * Example */ print_r(csv_to_array('example.csv'));
foreach ($p->{'Value'} as $v) { $var = sprintf("%s", $v->attributes()->{'Var'}); $val = sprintf("%s", $v); $uom = sprintf("%s", $v->attributes()->{'Unit'}); if (!array_key_exists($var, $data) && is_numeric($val)) { $data[$var] = array('val' => array($val), 't' => array($t), 'uom' => $uom, 'lyr' => $name); } else { if (!isset($_REQUEST['nowOnly']) && is_numeric($val)) { array_push($data[$var]['val'], $val); array_push($data[$var]['t'], $t); } } } } } else { $csv = csv_to_array($dataString); for ($i = 0; $i < count($csv); $i++) { // assume that the min time represents all hits preg_match("/(\\d\\d\\d\\d)-(\\d\\d)-(\\d\\d)T(\\d\\d):(\\d\\d):(\\d\\d)Z/", $csv[$i]['time'], $a); $t = mktime($a[4], $a[5], $a[6], $a[2], $a[3], $a[1]); if (isset($_REQUEST['nowOnly'])) { if (!array_key_exists('time', $data) || $t < $data['time']) { $data['time'] = $t; } } foreach (array_keys($csv[$i]) as $vStr) { if ($vStr != 'time') { preg_match("/(.*)\\[(.*)\\]/", $vStr, $a); $var = $a[1]; $val = $csv[$i][$vStr]; $uom = $a[2];
<?php require_once 'init.php'; if (!$_FILES || empty($_FILES['backlog_file'])) { ?> <form action="" method="post" enctype="multipart/form-data"> <label> Select CSV File <input type="file" name="backlog_file" /> </label> <button type="submit">Upload</button> </form><?php } else { $backlog = csv_to_array($_FILES['backlog_file']['tmp_name']); save_array_to_file($backlog, 'uploads/backlog-current.php'); }
<?php /** * @link http://gist.github.com/385876 */ $ddl = csv_to_array("input.csv"); $currentTable = ""; foreach ($ddl as $attribute) { if ($currentTable != $attribute['table_name']) { if ($currentTable != "") { echo ");</br></br>"; } $currentTable = $attribute['table_name']; echo "CREATE TABLE {$currentTable}("; echo "</br>"; } $attributeName = $attribute['Attribute']; $dataType = $attribute['sql_type']; $isKey = " "; if ($dataType == 'varchar') { $dataType = "varchar(50)"; } if ($attribute['Key Type'] == "Primary") { $isKey = " Primary Key"; } echo "\t{$attributeName} \t\t{$dataType}{$isKey}\t\tNOT NULL,"; echo "</br>"; } echo ");"; echo "</br>"; // echo "<pre>";
/** * $resout is the residue table file created by writeMulticritChart * $rscc_file is the formatted rscc file * $multi_table is the multi crit chart (to get the prequel) * $outfile is the name out file that this function will write to * $raw_rscc_out is the raw rscc file */ function writeHorizontalChart($resout, $rscc_file, $multi_table, $outfile, $rscc_prequel_out) { $startTime = time(); // get prequel $in = fopen($multi_table, 'rb'); clearstatcache(); $data = fread($in, filesize($multi_table)); fclose($in); $multi = mpUnserialize($data); $prequel = $multi['prequel']; $in = fopen($resout, 'rb'); clearstatcache(); $data = fread($in, filesize($resout)); fclose($in); $res_table = mpUnserialize($data); $rscc_table = csv_to_array($rscc_file, ','); // {{{ integrate rscc into $res_table annd set $horiz_table foreach ($rscc_table as $info) { if (!array_key_exists($info['res_id'], $res_table)) { continue; } $res_table[$info['res_id']]['worst_b_bb'] = $info['worst_b_bb']; $res_table[$info['res_id']]['worst_cc_bb'] = $info['worst_cc_bb']; $res_table[$info['res_id']]['worst_2fo-fc_bb'] = $info['worst_2fo-fc_bb']; $res_table[$info['res_id']]['worst_b_sc'] = $info['worst_b_sc']; $res_table[$info['res_id']]['worst_cc_sc'] = $info['worst_cc_sc']; $res_table[$info['res_id']]['worst_2fo-fc_sc'] = $info['worst_2fo-fc_sc']; } // params = bb Density, sc Density, Clash, Ramachandran, Rotamer, // cB deviation, Bond length, Bond angle'); $mp_params = array('bb Density', 'sc Density', 'Clash', 'Ramachandran', 'Rotamer', 'cB deviation', 'Bond length', 'Bond angle'); $horiz_table = array(); // create array for horizontal table foreach ($mp_params as $param) { $horiz_table[$param] = array(); foreach ($res_table as $resid => $info) { if (substr($resid, -3) != "HOH") { $horiz_table[$param][$resid] = array(); } } } // }}} // {{{ set parameters // {{{ set bb Density foreach ($horiz_table['bb Density'] as $resid => $info) { $horiz_table['bb Density'][$resid]['value'] = array(); $horiz_table['bb Density'][$resid]['value']['2fo-fc'] = $res_table[$resid]['worst_2fo-fc_bb']; $horiz_table['bb Density'][$resid]['value']['cc'] = $res_table[$resid]['worst_cc_bb']; $s = "<center>Backbone Density<br />cc : "; $s .= $horiz_table['bb Density'][$resid]['value']['cc'] . "<br />2Fo-Fc : "; $s .= $horiz_table['bb Density'][$resid]['value']['2fo-fc'] . "</center>"; $horiz_table['bb Density'][$resid]['html'] = $s; $img = "no_out.png"; if ($horiz_table['bb Density'][$resid]['value']['2fo-fc'] < 1.1 || $horiz_table['bb Density'][$resid]['value']['cc'] < 0.75) { $img = "density_outA.png"; } if ($horiz_table['bb Density'][$resid]['value']['2fo-fc'] < 0.8 || $horiz_table['bb Density'][$resid]['value']['cc'] < 0.6) { $img = "density_outB.png"; } $horiz_table['bb Density'][$resid]['image'] = $img; } // }}} // {{{ set sc Density foreach ($horiz_table['sc Density'] as $resid => $info) { $horiz_table['sc Density'][$resid]['value'] = array(); $horiz_table['sc Density'][$resid]['value']['2fo-fc'] = $res_table[$resid]['worst_2fo-fc_sc']; $horiz_table['sc Density'][$resid]['value']['cc'] = $res_table[$resid]['worst_cc_sc']; $s = "<center>Backbone Density<br />cc : "; $s .= $horiz_table['sc Density'][$resid]['value']['cc'] . "<br />2Fo-Fc : "; $s .= $horiz_table['sc Density'][$resid]['value']['2fo-fc'] . "</center>"; $horiz_table['sc Density'][$resid]['html'] = $s; $img = "no_out.png"; if ($horiz_table['sc Density'][$resid]['value']['2fo-fc'] < 1.1 || $horiz_table['sc Density'][$resid]['value']['cc'] < 0.75) { $img = "density_outA.png"; } if ($horiz_table['sc Density'][$resid]['value']['2fo-fc'] < 0.8 || $horiz_table['sc Density'][$resid]['value']['cc'] < 0.6) { $img = "density_outB.png"; } if (endsWith($resid, "GLY") || endsWith($resid, "gly")) { $horiz_table['sc Density'][$resid]['value']['2fo-fc'] = '-'; $horiz_table['sc Density'][$resid]['value']['cc'] = '-'; $img = "null.png"; } $horiz_table['sc Density'][$resid]['image'] = $img; } // }}} // {{{ set Clash foreach ($horiz_table['Clash'] as $resid => $info) { if ($res_table[$resid]['clash_isbad']) { $horiz_table['Clash'][$resid]['value'] = $res_table[$resid]['clash_val']; // $info['value'] = $res_table[$resid]['clash_val']; $horiz_table['Clash'][$resid]['html'] = $res_table[$resid]['clash']; if ($horiz_table['Clash'][$resid]['value'] < 0.7) { $img = "clash_outA.png"; } elseif ($horiz_table['Clash'][$resid]['value'] < 1.0) { $img = "clash_outC.png"; } else { $img = "clash_outD.png"; } $horiz_table['Clash'][$resid]['image'] = $img; } else { $horiz_table['Clash'][$resid]['value'] = 0; $horiz_table['Clash'][$resid]['html'] = "<center>-</center>"; $horiz_table['Clash'][$resid]['image'] = "no_out.png"; } } // }}} // {{{ set Ramachandran foreach ($horiz_table['Ramachandran'] as $resid => $info) { $horiz_table['Ramachandran'][$resid]['value'] = $res_table[$resid]['rama_val']; $horiz_table['Ramachandran'][$resid]['html'] = $res_table[$resid]['rama']; if ($res_table[$resid]['rama_isbad']) { $img = "rama_out.png"; } else { $img = "no_out.png"; } $horiz_table['Ramachandran'][$resid]['image'] = $img; } // }}} // {{{ set Rotamer foreach ($horiz_table['Rotamer'] as $resid => $info) { $horiz_table['Rotamer'][$resid]['value'] = $res_table[$resid]['rota_val']; $horiz_table['Rotamer'][$resid]['html'] = $res_table[$resid]['rota']; if ($res_table[$resid]['rota_isbad']) { $img = "rotamer_out.png"; } else { $img = "no_out.png"; } if (endsWith($resid, "GLY") || endsWith($resid, "gly")) { $img = "null.png"; } $horiz_table['Rotamer'][$resid]['image'] = $img; } // }}} // {{{ set cB deviation foreach ($horiz_table['cB deviation'] as $resid => $info) { if ($res_table[$resid]['cbdev_isbad']) { $horiz_table['cB deviation'][$resid]['value'] = $res_table[$resid]['cbdev_val']; $horiz_table['cB deviation'][$resid]['html'] = $res_table[$resid]['cbdev']; $horiz_table['cB deviation'][$resid]['image'] = "cBd_out.png"; } else { $horiz_table['cB deviation'][$resid]['value'] = 0; $horiz_table['cB deviation'][$resid]['html'] = "<center>-</center>"; $horiz_table['cB deviation'][$resid]['image'] = "no_out.png"; } } // }}} // {{{ set Bond length foreach ($horiz_table['Bond length'] as $resid => $info) { if ($res_table[$resid]['bbonds_isbad']) { $horiz_table['Bond length'][$resid]['value'] = $res_table[$resid]['bbonds_isbad']; $horiz_table['Bond length'][$resid]['html'] = $res_table[$resid]['bbonds']; $horiz_table['Bond length'][$resid]['image'] = "bl_out.png"; } else { $horiz_table['Bond length'][$resid]['value'] = 0; $horiz_table['Bond length'][$resid]['html'] = "<center>-</center>"; $horiz_table['Bond length'][$resid]['image'] = "no_out.png"; } } // }}} // {{{ set Bond angle foreach ($horiz_table['Bond angle'] as $resid => $info) { if ($res_table[$resid]['bangles_isbad']) { $horiz_table['Bond angle'][$resid]['value'] = $res_table[$resid]['bangles_isbad']; $horiz_table['Bond angle'][$resid]['html'] = $res_table[$resid]['bangles']; $horiz_table['Bond angle'][$resid]['image'] = "ba_out.png"; } else { $horiz_table['Bond angle'][$resid]['value'] = 0; $horiz_table['Bond angle'][$resid]['html'] = "<center>-</center>"; $horiz_table['Bond angle'][$resid]['image'] = "no_out.png"; } } // }}} // }}} $table1 = array(); $table1['prequel'] = $prequel; $table1['rscc_prequel'] = getRsccPrequel($horiz_table, $rscc_prequel_out); $table1['horiz_table'] = $horiz_table; $out = fopen($outfile, 'wb'); fwrite($out, mpSerialize($table1)); fclose($out); echo "Formatting horizontal chart table took " . (time() - $startTime) . " seconds\n"; }
if (($handle = fopen($filename, 'r')) !== FALSE) { while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE) { // if(!$header) // $header = $row; // else // $data[] = array_combine($header, $row); $data[] = $row; } fclose($handle); } return $data; } require_once $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/include/prolog_before.php"; set_time_limit(30); $filelist = getenv("DOCUMENT_ROOT") . "/test/ts_list.csv"; $carlist = csv_to_array($filelist); echo "<pre>"; if (CModule::IncludeModule("iblock")) { $el = new CIBlockElement(); foreach ($carlist as $cardata) { //print_r( $cardata ); $PRODUCT_ID = null; $PROP = array("71" => "12.08.2015", "66" => 2073, "70" => 12, "72" => 700, "73" => preg_replace("/\\s/", "", $cardata[0]), "67" => preg_replace("/\\s/", "", $cardata[1]), "76" => preg_replace("/\\s/", "", $cardata[2]), "75" => 6488); $arLoadProductArray = array("MODIFIED_BY" => 1, "IBLOCK_SECTION_ID" => false, "IBLOCK_ID" => IBLOCK_SK_CHASSIS_ID, "PROPERTY_VALUES" => $PROP, "NAME" => empty($PROP["76"]) ? $PROP["73"] : $PROP["76"], "ACTIVE" => "Y"); // print_r( $arLoadProductArray ); if ($PRODUCT_ID = $el->Add($arLoadProductArray)) { echo "New ID: " . $PRODUCT_ID; } else { echo "Error: " . $el->LAST_ERROR; print_r($arLoadProductArray); echo "<hr/>";
$prepareData[$header[$n]] = $items[$n]; } $data[] = $prepareData; } } return $data; } //This scraper holds modern synths. //Delete existing data $info = scraperwiki::table_info($name = "swdata"); if (!empty($info)) { scraperwiki::sqliteexecute("DELETE FROM swdata"); //Truncate the table before adding new results } $modernSynthData = file_get_contents("https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0Aht1e-sbjyvPdHJmaUIzTEctZl8tc2tVWjdjYnFpOGc&single=true&gid=0&output=csv"); $modernSynthData = csv_to_array($modernSynthData); //print_r($modernSynthData); $synths = array(); $counter = 0; foreach ($modernSynthData as $synth) { if (!empty($synth)) { $synths[$counter]['manufacturer'] = $synth['Manufacturer']; $synths[$counter]['name'] = $synth['Synth Name']; $synths[$counter]['url'] = $synth['Source URL']; $synths[$counter]['images'] = $synth['Images']; $counter++; } } //print_r($synths); if (!empty($synths)) { scraperwiki::save_var('total_results', count($synths));
$final_data[] = str_getcsv($parse_it, ',', '"'); } return $final_data; } //----------------------------------------------------------------------------------------| //--------------------uncomment this stuff when you want to insert into MySQL!!-----------| //----------------------------------------------------------------------------------------| //connect to mysql, which we'll be using to keep track of everything. //$mysqli = new mysqli('127.0.0.1', 'root', '', 'test', '3306'); /* check connection */ //if (mysqli_connect_errno()) { // printf("Connect failed: %s\n", mysqli_connect_error()); // exit(); //} //put the path to your csv here. $csv = csv_to_array('backlinks.csv'); use SEOstats\Services as SEOstats; // Create a new SEOstats instance. $seostats = new \SEOstats\SEOstats(); //--------------------------------------------------------------------------| //----------echo HTML, in case we just want to take a quick look------------| //--------------------------------------------------------------------------| echo "<div class='row'><h1>External Backlinks Stats</h1></div>"; foreach ($csv as $row) { try { $url = "http://www." . $row[0]; //get rid of that comma $link_num = str_replace(",", "", $row[1]); $linked_pages = $row[2]; // Bind the URL to the current SEOstats instance. if ($seostats->setUrl($url)) {
</table> <?php if (isset($_POST["submit"])) { if (isset($_FILES["file"])) { if ($_FILES["file"]["error"] > 0) { } else { //if file already exists if (file_exists("upload/" . $_FILES["file"]["name"])) { echo $_FILES["file"]["name"] . " already exists. "; } else { //Store file in directory "upload" with the name of "uploaded_file.txt" $storagename = "uploaded_file.xls"; move_uploaded_file($_FILES["file"]["tmp_name"], "upload/" . $storagename); print 'Import successfully!'; } } } else { echo "No file selected <br />"; } } print parse_excel_to_table("upload/" . $storagename); $profiles = csv_to_array("upload/" . $storagename); for ($i = 0; $i < count($profiles); $i++) { $username = $profiles[$i]; $user = user_load_from_name($username); $uid = $user['User_ID']; if ($user['Role_ID'] == 2) { delete_course_user($cid, $uid); create_course_user($cid, $uid); } }
/* Link to edit the map: http://umap.openstreetmap.fr/en/map/anonymous-edit/78775%3AQazSqz7NxNtECK5cabetfRbeKfU */ ?> <iframe width="100%" height="600px" frameBorder="0" src="http://umap.openstreetmap.fr/en/map/hotels-near-irchel_78775?scaleControl=true&miniMap=false&scrollWheelZoom=false&zoomControl=true&allowEdit=false&moreControl=false&datalayersControl=false&onLoadPanel=undefined&captionBar=false"></iframe> <p> <a class="small" href="http://umap.openstreetmap.fr/en/map/hotels-near-irchel_78775"> See full screen </a> </p> <?php $hotels = csv_to_array('data/hotels.csv'); foreach ($hotels as $hotel) { #var_dump($hotel); if (!$hotel['show'] == "Y") { continue; } $shorttel = str_replace(' ', '', $hotel['tel']); $img = isset($hotel['img']) && $hotel['img'] ? $hotel['img'] : 'generic_hotel.jpg'; echo "<div class='hotel bordered'>\n"; echo " <a class='imga' href='img/hotels/{$img}'>\n"; echo " <img src='img/hotels/_{$img}' />\n"; if ($hotel['aircon'] === 'Y') { echo " <img title='has air conditioning' class='ico x1' src='img/aircon.png' />\n"; } if ($hotel['wifi'] === 'Y') { echo " <img title='has free wifi' class='ico x2' src='img/wifi.png' />\n";
$eid = sql_real_escape_string($_POST["eventId"]); $uid = sql_real_escape_string($_POST["userId"]);*/ if (!empty($_POST["deleteItems"])) { delete_pool_contents(); } else { $tmp_csv_file = $_FILES['uploadedfile']['tmp_name']; //$ext = pathinfo($_FILES['uploadedfile']['name'], PATHINFO_EXTENSION); //$target_path = "/var/www/backend/parti-pics/$uid.$ext"; ////$target_path = $target_path . basename( $_FILES['uploadedfile']['name']); if (!empty($_POST["workbookId"])) { $tmp_csv_file = "/tmp/" . uniqid(time(0)); // download_file("https://docs.google.com/spreadsheet/ccc?key={$_POST["workbookId"]}&gid={$_POST["sheetId"]}&output=csv", $tmp_csv_file, "/tmp/" . uniqid(time(0))); download_file("https://docs.google.com/spreadsheets/d/{$_POST["workbookId"]}/export?format=csv&id={$_POST["workbookId"]}&gid={$_POST["sheetId"]}", $tmp_csv_file, "/tmp/" . uniqid(time(0))); //file_put_contents($tmp_csv_file, file_get_contents("https://docs.google.com/spreadsheet/ccc?key={$_POST["workbookId"]}&gid={$_POST["sheetId"]}&output=csv")); } $csv_data = csv_to_array($tmp_csv_file); if ($csv_data) { //if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)){ $check = TRUE; if (count($csv_data) > 0) { foreach ($REQUIRED_FILEDS as $field) { if (!isset($csv_data[0][$field])) { $check = FALSE; break; } } } if ($check) { if (!empty($_POST["deleteFirst"])) { delete_pool_contents(); }
die; } function csv_to_array($file = '', $length = 0, $delimiter = ';') { $header = NULL; $data = array(); if (($handle = fopen($file, 'r')) !== FALSE) { while (($row = fgetcsv($handle, $length, $delimiter)) !== FALSE) { if (!$header) { $header = $row; } else { $data[] = array_combine($header, $row); } } fclose($handle); } return $data; } include_once 'include/Webservices/Create.php'; foreach (csv_to_array($file) as $row) { //print_r($row); try { $row = vtws_create('Accounts', $row, $current_user); echo "Organisation: " . $row['id'] . PHP_EOL; } catch (WebServiceException $ex) { $msg = $ex->getMessage(); $msg .= print_r($row, true) . "\n"; error_log($msg, 3, $file . "-error.log"); echo $msg; } }
public function Get_record_file_handle() { //<--this function helps to find and return clculating records data $csvStored_data = ""; $start_date = $this->get_date_period_start(); $end_date = $this->get_date_period_ends(); $month_start = $start_date[1] - 1; //<--special arrangement for yahoo finance data (0 -> january) $month_ends = $end_date[1] - 1; //<--special arrangement for yahoo finance data (0 -> january) $file = 'http://ichart.yahoo.com/table.csv?s=' . $this->company_symbol . '&a=' . $month_start . '&b=' . $start_date[2] . '&c=' . $start_date[0] . '&d=' . $month_ends . '&e=' . $end_date[2] . '&f=' . $end_date[0] . '&g=' . $this->interval . '&ignore=.csv'; $stored_data = CompanyData::get_last_updated_record($this->company_symbol); //<-- this function finds the data from database if ($stored_data) { if (date("Y-m-d", strtotime($stored_data->updated)) < date("Y-m-d", time()) || $stored_data->accuracy < $this->precision) { $csvStored_data = csv_to_array($file, ','); //<----exploring CSV file if (count($csvStored_data) > 4) { //<--checks for the genuinity $company_id = Company::find_company_id_company_symbol($this->company_symbol); $prediction = CompanyData::where('comp_id_fk', '=', $company_id)->delete(); $company = CompanyData::create(array('comp_id_fk' => $company_id, 'csvdata' => serialize($csvStored_data), 'updated' => date("Y-m-d H:i:s", time()), 'accuracy' => $this->precision)); } } else { $csvStored_data = unserialize($stored_data->csvdata); } $this->company_description = $stored_data->description; $this->company_address = $stored_data->address; } else { $company = new Company(); $company->company_name = trim($this->company_name); $this->company_description = get_Company_data($this->company_symbol, 'desci'); get_Company_logo($this->company_symbol); //<--fuction used to copy image $company->description = $this->company_description; $company->company_symbol = trim($this->company_symbol); $csvStored_data = csv_to_array($file, ','); //<----exploring CSV file if (count($csvStored_data) > 4) { //<--checks for the genuinity $company = Company::create(array('company_name' => trim($this->company_name), 'company_description' => get_Company_data($this->company_symbol, 'desci'), 'description' => $this->company_description, 'company_symbol' => trim($this->company_symbol))); if ($company) { if ($csvStored_data) { get_Company_logo($this->company_symbol); //<--fuction used to copy image } $CompanyData = CompanyData::create(array('comp_id_fk' => trim($company->id), 'csvdata' => serialize($csvStored_data), 'updated' => date("Y-m-d H:i:s", time()), 'accuracy' => $this->precision)); $predict_data = Prediction::create(array('comp_id_fk' => trim($company->id))); } } } return !empty($csvStored_data) ? $csvStored_data : false; }