Pastebin
API
tools
faq
paste
Login
Sign up
Please fix the following errors:
New Paste
Syntax Highlighting
<html> <head> <meta charset="UTF-8"> <title></title> </head> <body> <?php //Importe les extensions si elle ne sont pas dèjà présente require_once 'C:\xampp\htdocs\PhpProject\PHPExcel-1.8\PHPExcel-1.8\Classes\PHPExcel.php'; require_once 'C:\xampp\htdocs\PhpProject\PHPExcel-1.8\PHPExcel-1.8\Classes\PHPExcel\IOFactory.php'; require_once('C:\xampp\htdocs\PhpProject\PHPExcel-1.8\PHPExcel-1.8\Classes\PHPExcel\Writer\CSV.php'); $PHPExcel = new PHPExcel(); //Création de la feuille PHPExcel relié à la feuille excel ps_product $ps_product = PHPExcel_IOFactory::load("ps_product.xlsx"); $sheet = PHPExcel_IOFactory::createReader('Excel2007'); $sheet = $sheet->load('ps_product.xlsx'); $sheet = $PHPExcel->setActiveSheetIndex(0); //Création de la feuille PHPExcel relié à la feuille excel ps_product $sheetr = PHPExcel_IOFactory::createReader('Excel2007'); $sheetr = $sheetr->load('Tarif fournisseur 2019.xlsx'); $sheetr->setActiveSheetIndex(0); //Création de la feuille PHPExcel relié à la feuille excel ps_product_test $sheet_test = PHPExcel_IOFactory::createReader('Excel2007'); $sheet_test = $sheet_test->load('ps_product_test.xlsx'); $sheet_test->setActiveSheetIndex(0); //Connexion à la base de données $bdd = new mysqli("localhost", "root", "", "soyons_chimie_biotechnologie"); $host = "localhost"; $username = "root"; $passwd = ""; $dbname = "soyons_chimie_biotechnologie"; if ($bdd->connect_errno) { echo "Echec lors de la connexion à MySQL : (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } $link = mysqli_connect($host, $username, $passwd, $dbname); $bdd->set_charset("UTF_8_general_ci"); //Méthode pour chercher la dernière variable de la table $requete = 'SELECT * FROM ps_product'; $resultat = $bdd->query($requete); $last = '0'; while ($ligne = $resultat->fetch_assoc()) { if ($ligne > $last) { $last++; } } $last++; //Méthode pour remplir le tableau ps_product en fonction de Tarif fournisseur 2019 $colonne0 = 65; $colonne1 = 65; $colonne2 = 65; $passage = $last; $ligneFourniseeur = 7; $machin = 0; $write; for ($ligne = 0; $ligne < 54; $ligne++) { if ($colonne0 == 91 || $machin > 0) { $machin++; //Methode quand la ligne arrive à AZ pour passer à BA if ($ligne == 52) { $colonne2++; $colonne1 = 65; } //Methode quand la ligne arrive à BA pour repasser à A else if ($ligne == 53) { $a0 = chr($colonne2); $a1 = chr($colonne1); $a2 = $passage; $write = "$a0$a1$a2"; $colonne1 = 65; $colonne2 = 65; } //Methode quand la ligne arrive à Z pour passer à AA-AZ else { $a0 = chr($colonne2); $a1 = chr($colonne1); $a2 = $passage; $write = "$a0$a1$a2"; $colonne1++; } } //Methode pour aller de A à Z else { $a0 = chr($colonne0); $a1 = $passage; $write = "$a0$a1"; } /*Technique pour remplir les tableaux ps_product avec Tarif Fournisseur 2019 Pour comprendre pourquoi ces valeurs sont placé comme ça aller à: PrestaShop\Word PrestaShop\ps_product.docx Marche pour la fiche Rogo pour changer de tableau il faut changer $ligneFourniseeur et les valeurs du switch pour les case 2/3/16/21 */ switch ($ligne) { case 0: $sheet_test->getActiveSheet()->setCellValue($write, $passage); break; case 1: $sheet_test->getActiveSheet()->setCellValue($write, '0'); break; case 2: $vendeur = 0; $vend = 'J' . $ligneFourniseeur; //Voir table mySQL ps_manufacturer pour comprendre les ID switch ($sheetr->getActiveSheet()->getCell($vend)->getValue()) { case 'Nahita': $vendeur = 4; break; case 'Avignon': $vendeur = 5; break; case 'Jipo': $vendeur = 6; break; case 'Endo Glassware': $vendeur = 7; break; case 'Simax': $vendeur = 8; break; case 'Selecta': $vendeur = 9; break; case 'Kartell': $vendeur = 10; break; case 'VitLab': $vendeur = 11; break; case 'TS': $vendeur = 12; break; case 'Glassco': $vendeur = 13; break; case 'RSG': $vendeur = 14; break; case 'Saint Gobain': $vendeur = 15; break; case 'Filtre RS': $vendeur = 16; break; case 'RS France': $vendeur = 17; break; case 'Zuzi': $vendeur = 18; break; case 'Ghäasel': $vendeur = 19; break; case 'Knittel': $vendeur = 20; break; case 'Anumbra': $vendeur = 21; break; case 'Gilac': $vendeur = 22; break; case 'Agencinox': $vendeur = 23; break; case 'Qualicolor': $vendeur = 24; break; case 'Technosklo': $vendeur = 25; break; case 'Nahita-Blue': $vendeur = 26; break; case 'Orto Alresa': $vendeur = 27; break; case 'RS Lab': $vendeur = 28; break; case 'Ura Technic': $vendeur = 29; break; case 'Socorex': $vendeur = 30; break; case 'Digipette': $vendeur = 31; break; case 'Ratiolab': $vendeur = 32; break; case 'Bomex': $vendeur = 33; break; case 'Gibertini': $vendeur = 34; break; case 'KNF': $vendeur = 35; break; case 'Univet': $vendeur = 36; break; case 'Endo Plasticware': $vendeur = 37; break; case 'Endo Protectlab': $vendeur = 38; break; case 'Plum': $vendeur = 39; break; case 'Emag': $vendeur = 40; break; case 'Preciss Europe': $vendeur = 41; break; default: $vendeur = 53; break; } $sheet_test->getActiveSheet()->setCellValue($write, $vendeur); break; case 3: $category = 0; $cat = 'D' . $ligneFourniseeur; //Voir table mySQL ps_category_lang pour comprendre les ID switch ($sheetr->getActiveSheet()->getCell($cat)->getValue()) { case 'Mortiers': $category = 12; break; case 'Dessiccateurs': $category = 13; break; case 'Tubes': $category = 14; break; case 'Flacon à vis': $category = 15; break; case 'Portoirs et supports': $category = 16; break; case 'Bouchons': $category = 17; break; case 'Microscopie': $category = 18; break; case 'Microbiologie': $category = 19; break; case 'Bac et plateaux': $category = 20; break; case 'Mobilier': $category = 21; break; case 'Béchers': $category = 23; break; case 'Carafes': $category = 24; break; case 'Fioles': $category = 25; break; case 'Flacons ISO': $category = 26; break; case 'Flacons à vis': $category = 27; break; case 'Flacon à rodage': $category = 28; break; case 'Flacons compte-goutte': $category = 29; break; case 'Flacons laveurs': $category = 30; break; case 'Bidons': $category = 31; break; case 'Flacons': $category = 32; break; case 'Verrerie volumétrique': $category = 33; break; case 'Evaporation': $category = 34; break; case 'Incinération': $category = 35; break; case 'Eprouvettes': $category = 36; break; case 'Fioles jaugées': $category = 37; break; case 'Pipettes graduées': $category = 38; break; case 'Pipettes jaugées': $category = 39; break; case 'Pipettes,autres': $category = 40; break; case 'Burettes': $category = 41; break; case 'Cônes d\'Imhoff': $category = 42; break; case 'Montages': $category = 43; break; case 'Chauffage': $category = 44; break; case 'Tuyauterie et accessoire': $category = 45; break; case 'Spatules/cuillères': $category = 46; break; case 'Matériel à dissection': $category = 48; break; case 'Mono-rotor': $category = 49; break; case 'Minicentrifugeuses': $category = 50; break; case 'Microhématocrite': $category = 51; break; case 'Pour micro-tubes': $category = 57; break; case 'Universelles': $category = 58; break; case 'Grande capacité': $category = 59; break; case 'Microscopes': $category = 61; break; case 'Stéréomicroscopes': $category = 62; break; case 'Caméras vidéo': $category = 63; break; case 'Spectophotomètres': $category = 64; break; case 'Polarimètres': $category = 65; break; case 'Réfractomètres': $category = 66; break; case 'Loupes': $category = 67; break; case 'Etuves': $category = 69; break; case 'Bains': $category = 70; break; case 'Chauffe-ballons': $category = 71; break; case 'Réfrigération/Congélation': $category = 72; break; case 'Balances': $category = 75; break; case 'pH-mètres': $category = 76; break; case 'Conductimètres': $category = 77; break; case 'Thermomètres': $category = 78; break; case 'Temps': $category = 79; break; case 'Densimètres': $category = 80; break; case 'Viscosimètres': $category = 81; break; case 'Agitateurs magnétique': $category = 83; break; case 'Barreaux magnétique': $category = 84; break; case 'Agitateurs vibrateurs': $category = 85; break; case 'Agitateurs multidimensionnels': $category = 87; break; case 'Agitateurs à tige': $category = 88; break; case 'Auxiliaires de pipetage': $category = 90; break; case 'Distributeurs': $category = 91; break; case 'Pointes et autres consommables': $category = 92; break; case 'Seringues': $category = 93; break; case 'Pompes': $category = 94; break; case 'Equipements/pièces en verre': $category = 96; break; case 'Purification d\'eau': $category = 97; break; case 'Evaporateurs rotatifs': $category = 98; break; case 'Système de filtration': $category = 99; break; case 'Creusets filtrants': $category = 100; break; case 'Entonnoirs': $category = 101; break; case 'Ampoules à décanter': $category = 102; break; case 'Papier filtre': $category = 103; break; case 'Filtres seringues': $category = 104; break; case 'Pompes à vide': $category = 105; break; case 'Modèles': $category = 107; break; case 'Préparations microscopiques': $category = 108; break; case 'Physique': $category = 109; break; case 'Blouse de protection': $category = 110; break; case 'Douches et lave-oeil': $category = 111; break; case 'Verrerie Industrielle & Tubing': $category = 113; break; case 'Verrerie à rodage à vis': $category = 114; break; case 'Tubes, boro': $category = 115; break; case 'Capillaires': $category = 116; break; case 'Baguettes': $category = 117; break; case 'Nettoyage et stérilisation': $category = 119; break; case 'Sciences de la vie': $category = 120; break; case 'Préparation d\'échantillons': $category = 121; break; case 'Analyses des eaux, aliments': $category = 122; break; case 'Articles p/ usage clinique': $category = 123; break; default: $category = 128; } $sheet_test->getActiveSheet()->setCellValue($write, $category); break; case 4: $sheet_test->getActiveSheet()->setCellValue($write, '1'); break; case 5: $sheet_test->getActiveSheet()->setCellValue($write, '1'); break; case 6: $sheet_test->getActiveSheet()->setCellValue($write, '0'); break; case 7: $sheet_test->getActiveSheet()->setCellValue($write, '0'); break; case 8: $sheet_test->getActiveSheet()->setCellValue($write, ''); break; case 9: $sheet_test->getActiveSheet()->setCellValue($write, ''); break; case 10: $sheet_test->getActiveSheet()->setCellValue($write, ''); break; case 11: $sheet_test->getActiveSheet()->setCellValue($write, '0.00000'); break; case 12: $sheet_test->getActiveSheet()->setCellValue($write, '0'); break; case 13: $sheet_test->getActiveSheet()->setCellValue($write, '1'); break; case 14: $sheet_test->getActiveSheet()->setCellValue($write, 'NULL'); break; case 15: $sheet_test->getActiveSheet()->setCellValue($write, '0'); break; case 16: $prix = 'L' . $ligneFourniseeur; //Methode pour récupérer la valeur dans le tableau Tarif fournisseur 2019 $sheet_test->getActiveSheet()->setCellValue($write, $sheetr->getActiveSheet()->getCell($prix)->getValue()); break; case 17: $sheet_test->getActiveSheet()->setCellValue($write, '0.000000'); break; case 18: $sheet_test->getActiveSheet()->setCellValue($write, ''); break; case 19: $sheet_test->getActiveSheet()->setCellValue($write, '0.0000000'); break; case 20: $sheet_test->getActiveSheet()->setCellValue($write, '0.00'); break; case 21: $ref = 'G' . $ligneFourniseeur; $sheet_test->getActiveSheet()->setCellValue($write, $sheetr->getActiveSheet()->getCell($ref)->getValue()); break; case 22: $sheet_test->getActiveSheet()->setCellValue($write, ''); break; case 23: $sheet_test->getActiveSheet()->setCellValue($write, ''); break; case 24: $sheet_test->getActiveSheet()->setCellValue($write, '0.00000'); break; case 25: $sheet_test->getActiveSheet()->setCellValue($write, '0.00000'); break; case 26: $sheet_test->getActiveSheet()->setCellValue($write, '0.00000'); break; case 27: $sheet_test->getActiveSheet()->setCellValue($write, '0.00000'); break; case 28: $sheet_test->getActiveSheet()->setCellValue($write, '2'); break; case 29: $sheet_test->getActiveSheet()->setCellValue($write, '1'); break; case 30: $sheet_test->getActiveSheet()->setCellValue($write, '0'); break; case 31: $sheet_test->getActiveSheet()->setCellValue($write, '0'); break; case 32: $sheet_test->getActiveSheet()->setCellValue($write, '0'); break; case 33: $sheet_test->getActiveSheet()->setCellValue($write, '0'); break; case 34: $sheet_test->getActiveSheet()->setCellValue($write, '1'); break; case 35: $sheet_test->getActiveSheet()->setCellValue($write, '301-category'); break; case 36: $sheet_test->getActiveSheet()->setCellValue($write, '0'); break; case 37: $sheet_test->getActiveSheet()->setCellValue($write, '1'); break; case 38: $sheet_test->getActiveSheet()->setCellValue($write, '0000-00-00'); break; case 39: $sheet_test->getActiveSheet()->setCellValue($write, '0'); break; case 40: $sheet_test->getActiveSheet()->setCellValue($write, 'new'); break; case 41: $sheet_test->getActiveSheet()->setCellValue($write, '1'); break; case 42: $sheet_test->getActiveSheet()->setCellValue($write, '1'); break; case 43: $sheet_test->getActiveSheet()->setCellValue($write, 'both'); break; case 44: $sheet_test->getActiveSheet()->setCellValue($write, '0'); break; case 45: $sheet_test->getActiveSheet()->setCellValue($write, '0'); break; case 46: $sheet_test->getActiveSheet()->setCellValue($write, '0'); break; case 47: $sheet_test->getActiveSheet()->setCellValue($write, '0'); break; case 48: $sheet_test->getActiveSheet()->setCellValue($write, '02/07/2019 10:12:00'); break; case 49: $sheet_test->getActiveSheet()->setCellValue($write, '02/07/2019 10:12:00'); break; case 50: $sheet_test->getActiveSheet()->setCellValue($write, '0'); break; case 51: $sheet_test->getActiveSheet()->setCellValue($write, '3'); break; case 53: $sheet_test->getActiveSheet()->setCellValue($write, '1'); break; } if ($ligne == 53) { $machin = 0; $colonne0 = 64; $ligne = -1; $passage++; if ($passage == $last + 301) { $ligne = 53; } $ligneFourniseeur++; } $colonne0++; } echo "check"; $sheet_test = PHPExcel_IOFactory::createWriter($sheet_test, 'Excel2007'); $sheet_test->save('ps_product_test.xlsx'); //mysqli_close($link); //A enlever /* //Affichage table mysql ps_manufacturer $requete = 'SELECT * FROM ps_manufacturer'; $resultat = $bdd->query($requete); while ($ligne = $resultat->fetch_assoc()) { echo $ligne['id_manufacturer'] . " " . $ligne['name'] . " " . $ligne['date_add'] . " " . $ligne['date_upd'] . " " . $ligne['active']; echo "</br>"; } //Affichage tabel mysql ps_manufacturer //Affichage table mysql ps_category_lang $requete = 'SELECT * FROM ps_category_lang'; $resultat = $bdd->query($requete); while ($ligne = $resultat->fetch_assoc()) { echo $ligne['id_category'] . " " . $ligne['id_shop'] . " " . $ligne['id_lang'] . " " . $ligne['name'] . " "; echo $ligne['description'] . " " . $ligne['link_rewrite'] . " " . $ligne['meta_title'] . " " . $ligne['meta_keywords'] . " "; echo $ligne['meta_description']; } //Affichage table mysql ps_category_lang //Affichage table mysql ps_category $requete = 'SELECT * FROM ps_category'; $resultat = $bdd->query($requete); while ($ligne = $resultat->fetch_assoc()) { echo $ligne['id_category'] . " " . $ligne['id_parent'] . " " . $ligne['id_shop_default'] . " " . $ligne['level_depth'] . " "; echo $ligne['nleft'] . " " . $ligne['nright'] . " " . $ligne['active'] . " " . $ligne['date_add'] . " "; echo $ligne['date_upd'] . " " . $ligne['position'] . " " . $ligne['is_root_category']; echo "</br>"; } //Affichage table mysql ps_category //Affichage table mysql ps_product_lang $requete = 'SELECT * FROM ps_product_lang'; $resultat = $bdd->query($requete); while ($ligne = $resultat->fetch_assoc()) { echo $ligne['id_product'] . " " . $ligne['id_shop'] . " " . $ligne['id_lang'] . " " . $ligne['description'] . " "; echo $ligne['description_short'] . " " . $ligne['link_rewrite'] . " " . $ligne['meta_description'] . " " . $ligne['meta_keywords'] . " "; echo $ligne['meta_title'] . " " . $ligne['name'] . " " . $ligne['available_now'] . " " . $ligne['available_later'] . " "; echo $ligne['delivery_in_stock'] . " " . $ligne['delivery_out_stock']; } //Affichage table mysql ps_product_lang //Affichage table mysql ps_product $requete = 'SELECT * FROM ps_product'; $resultat = $bdd->query($requete); while ($ligne = $resultat->fetch_assoc()) { echo $ligne['id_product'] . " " . $ligne['id_supplier'] . " " . $ligne['id_manufacturer'] . " " . $ligne['id_category_default'] . " "; echo $ligne['id_shop_default'] . " " . $ligne['id_tax_rules_group'] . " " . $ligne['on_sale'] . " " . $ligne['online_only'] . " "; echo $ligne['ean13'] . " " . $ligne['isbn'] . " " . $ligne['upc'] . " " . $ligne['ecotax'] . " "; echo $ligne['quantity'] . " " . $ligne['minimal_quantity'] . " " . $ligne['low_stock_threshold'] . " " . $ligne['low_stock_alert'] . " "; echo $ligne['price'] . " " . $ligne['wholesale_price'] . " " . $ligne['unity'] . " " . $ligne['unit_price_ratio'] . " "; echo $ligne['additional_shipping_cost'] . " " . $ligne['reference'] . " " . $ligne['supplier_reference'] . " " . $ligne['location'] . " "; echo $ligne['width'] . " " . $ligne['height'] . " " . $ligne['depth'] . " " . $ligne['weight'] . " "; echo $ligne['out_of_stock'] . " " . $ligne['additional_delivery_times'] . " " . $ligne['quantity_discount'] . " " . $ligne['customizable'] . " "; echo $ligne['uploadable_files'] . " " . $ligne['text_fields'] . " " . $ligne['active'] . " " . $ligne['redirect_type'] . " "; echo $ligne['id_type_redirected'] . " " . $ligne['available_for_order'] . " " . $ligne['available_date'] . " " . $ligne['show_condition'] . " "; echo $ligne['condition'] . " " . $ligne['show_price'] . " " . $ligne['indexed'] . " " . $ligne['visibility'] . " "; echo $ligne['cache_is_pack'] . " " . $ligne['cache_has_attachments'] . " " . $ligne['is_virtual'] . " " . $ligne['cache_default_attribute'] . " "; echo $ligne['date_add'] . " " . $ligne['date_upd'] . " " . $ligne['advanced_stock_management'] . " " . $ligne['pack_stock_type'] . " "; echo $ligne['state']; echo "</br>"; } //Affichage table mysql ps_product mysqli_close($link); //Remplissage du tableau ps_manufacturer $colonne03 = 65; $passage03 = 0; $nbrLigne03 = 5; for ($ligne = 0; $ligne < ($nbrLigne03 * 112); $ligne++) { if ($colonne03 == 70) { $colonne03 = 65; $passage03++; echo "</br>"; } echo chr($colonne03); echo $passage03; echo " "; $colonne03++; } //Remplissage du tableau ps_manufacturer //Remplissage du tableau ps_category_lang $colonne02 = 65; $passage02 = 0; $nbrLigne02 = 9; for ($ligne = 0; $ligne < ($nbrLigne02 * 112); $ligne++) { if ($colonne02 == 74) { $colonne02 = 65; $passage02++; echo "</br>"; } echo chr($colonne02); echo $passage02; echo " "; $colonne02++; } //Remplissage du tableau ps_category_lang //Remplissage du tableau ps_category $colonne01 = 65; $passage01 = 0; $nbrLigne01 = 11; for ($ligne = 0; $ligne < ($nbrLigne01 * 112); $ligne++) { if ($colonne01 == 76) { $colonne01 = 65; $passage01++; echo "</br>"; } echo chr($colonne01); echo $passage01; echo " "; $colonne01++; } //Remplissage du tableau ps_category //Remplissage du tableau ps_product_lang $colonne00 = 65; $passage00 = 0; $nbrLigne00 = 14; for ($ligne = 0; $ligne < ($nbrLigne00 * 112); $ligne++) { if ($colonne00 == 79) { $colonne00 = 65; $passage00++; echo "</br>"; } echo chr($colonne00); echo $passage00; echo " "; $colonne00++; } //Remplissage du tableau ps_product_lang //Remplissage du tableau ps_product $colonne0 = 65; $colonne1 = 65; $colonne2 = 65; $passage = 1; $machin = 0; for ($ligne = 0; $ligne < 54; $ligne++) { if ($colonne0 == 91 || $machin > 0) { $machin++; if ($ligne == 52) { $colonne2++; $colonne1 = 65; } else if ($ligne == 53) { echo chr($colonne2), chr($colonne1); echo $passage; $colonne1 = 65; $colonne2 = 65; } else { echo chr($colonne2), chr($colonne1); echo $passage; $colonne1++; } } else { echo chr($colonne0); echo $passage; } if ($ligne == 53) { $machin = 0; $colonne0 = 64; $ligne = -1; $passage++; if ($passage == 112) { $ligne = 53; } echo "</br>"; echo "</br>"; } $colonne0++; echo "'"; } //Remplissage du tableau ps_product /* //Convertisseur xls en csv $excel_readers = array( 'Excel5', 'Excel2003XML', 'Excel2007' ); $reader = PHPExcel_IOFactory::createReader('Excel5'); $reader->setReadDataOnly(false); $path = 'test123.xls'; $excel = $reader->load($path); $writer = PHPExcel_IOFactory::createWriter($excel, 'CSV'); $writer->setUseBOM(true); $writer->save('test123.csv'); echo 'File saved to csv format'; //Convertisseur xls en csv */ /* //Pour ps_product echo '<table border="1">'; $un = 0; $gauche = 1; $haut = 65; $haut2 = 65; $haut3 = 0; foreach ($sheet->getRowIterator() as $row) { foreach ($row->getCellIterator() as $cell) { ($cell->getValue()); if ($haut == 91 || $haut3 > 0) { $haut3++; if ($un == 26) { echo chr($haut2), chr(65); } else if ($un == 52) { $haut2++; echo chr($haut2), chr(65); } else if ($un == 53) { echo chr(65); } else { echo chr($haut2), chr($haut); } } else { echo chr($haut); } if ($haut == 91) { $haut = 65; } if ($un == 53) { $haut3 = 0; $haut = 65; $haut2 = 65; $gauche++; $un = 0; } $haut++; $un++; echo $gauche; echo " "; echo " "; } echo "</tr>"; } echo '</table>'; $writer = new PHPExcel_Writer_Excel2007($PHPExcel); $writer->save('C:\xampp\htdocs\PhpProject\poule.xlsx'); //Tableau ps_product //Afficahge tableau echo '<table border="1">'; $un = 0; foreach ($sheet->getRowIterator() as $row) { echo '<tr>'; foreach ($row->getCellIterator() as $cell) { echo "<td>"; echo($cell->getValue()); echo " "; $un++; echo "</td>"; if ($un == 53) { echo "</br>"; } } echo "</tr>"; } echo '</table>'; //Affichage tableau //Remplir tableau //Supression à partir d'une virgule $poule = 15; $poulet = 18; $oui = "Je suis dans le train, j'aime pas"; echo $oui; if (strstr($oui, ',') == true) { echo "</br> non"; $moins = strpos($oui, ','); $plus = strlen($oui); $non = substr($oui, 0, $moins - $plus); echo "</br>"; echo $non; } //Supression à partir d'une virgule //Création tableau echo '<table border="1">'; for ($i = 65; $i < 91; ++$i) { echo "<td>"; $passage = 0; $ch = 65; echo chr($i), PHP_EOL; if ($i == 90) { echo "</tr>"; for ($j = 65; $j < 91; ++$j) { echo "<td>"; echo chr($ch), chr($j), PHP_EOL; echo "</td>"; if ($j == 90) { if ($j == 90 && $ch == 90) { $j = 90; } else { $ch++; $j = 64; echo "</tr>"; } } } } $ch++; echo "</td>"; } echo "</table>"; //Création tableau //Test PHP echo "<h1>"; echo"Addition = "; echo $poule + $poulet; echo "</br>"; echo "Soustraction = "; echo $poule - $poulet; echo "</br>"; echo "Multiplication = "; echo $poule * $poulet; echo "</br>"; echo "Division = "; echo $poule / $poulet; echo "</br>"; echo "Modulo = "; echo $poule % $poulet; echo "</br>"; echo "Incrémentation = "; echo ++$poule; echo "</br>"; echo "Décrémentation = "; echo --$poule; echo "</br>"; echo "Exponatiation = "; echo $poule ** $poulet; echo "</h1>"; echo "Elle écrivit dessus, \"Retour à l'expéditeur\"."; //Test PHP */ ?> </body> </html>
Optional Paste Settings
Category:
None
Cryptocurrency
Cybersecurity
Fixit
Food
Gaming
Haiku
Help
History
Housing
Jokes
Legal
Money
Movies
Music
Pets
Photo
Science
Software
Source Code
Spirit
Sports
Travel
TV
Writing
Tags:
Syntax Highlighting:
None
Bash
C
C#
C++
CSS
HTML
JSON
Java
JavaScript
Lua
Markdown (PRO members only)
Objective C
PHP
Perl
Python
Ruby
Swift
4CS
6502 ACME Cross Assembler
6502 Kick Assembler
6502 TASM/64TASS
ABAP
AIMMS
ALGOL 68
APT Sources
ARM
ASM (NASM)
ASP
ActionScript
ActionScript 3
Ada
Apache Log
AppleScript
Arduino
Asymptote
AutoIt
Autohotkey
Avisynth
Awk
BASCOM AVR
BNF
BOO
Bash
Basic4GL
Batch
BibTeX
Blitz Basic
Blitz3D
BlitzMax
BrainFuck
C
C (WinAPI)
C Intermediate Language
C for Macs
C#
C++
C++ (WinAPI)
C++ (with Qt extensions)
C: Loadrunner
CAD DCL
CAD Lisp
CFDG
CMake
COBOL
CSS
Ceylon
ChaiScript
Chapel
Clojure
Clone C
Clone C++
CoffeeScript
ColdFusion
Cuesheet
D
DCL
DCPU-16
DCS
DIV
DOT
Dart
Delphi
Delphi Prism (Oxygene)
Diff
E
ECMAScript
EPC
Easytrieve
Eiffel
Email
Erlang
Euphoria
F#
FO Language
Falcon
Filemaker
Formula One
Fortran
FreeBasic
FreeSWITCH
GAMBAS
GDB
GDScript
Game Maker
Genero
Genie
GetText
Go
Godot GLSL
Groovy
GwBasic
HQ9 Plus
HTML
HTML 5
Haskell
Haxe
HicEst
IDL
INI file
INTERCAL
IO
ISPF Panel Definition
Icon
Inno Script
J
JCL
JSON
Java
Java 5
JavaScript
Julia
KSP (Kontakt Script)
KiXtart
Kotlin
LDIF
LLVM
LOL Code
LScript
Latex
Liberty BASIC
Linden Scripting
Lisp
Loco Basic
Logtalk
Lotus Formulas
Lotus Script
Lua
M68000 Assembler
MIX Assembler
MK-61/52
MPASM
MXML
MagikSF
Make
MapBasic
Markdown (PRO members only)
MatLab
Mercury
MetaPost
Modula 2
Modula 3
Motorola 68000 HiSoft Dev
MySQL
Nagios
NetRexx
Nginx
Nim
NullSoft Installer
OCaml
OCaml Brief
Oberon 2
Objeck Programming Langua
Objective C
Octave
Open Object Rexx
OpenBSD PACKET FILTER
OpenGL Shading
Openoffice BASIC
Oracle 11
Oracle 8
Oz
PARI/GP
PCRE
PHP
PHP Brief
PL/I
PL/SQL
POV-Ray
ParaSail
Pascal
Pawn
Per
Perl
Perl 6
Phix
Pic 16
Pike
Pixel Bender
PostScript
PostgreSQL
PowerBuilder
PowerShell
ProFTPd
Progress
Prolog
Properties
ProvideX
Puppet
PureBasic
PyCon
Python
Python for S60
QBasic
QML
R
RBScript
REBOL
REG
RPM Spec
Racket
Rails
Rexx
Robots
Roff Manpage
Ruby
Ruby Gnuplot
Rust
SAS
SCL
SPARK
SPARQL
SQF
SQL
SSH Config
Scala
Scheme
Scilab
SdlBasic
Smalltalk
Smarty
StandardML
StoneScript
SuperCollider
Swift
SystemVerilog
T-SQL
TCL
TeXgraph
Tera Term
TypeScript
TypoScript
UPC
Unicon
UnrealScript
Urbi
VB.NET
VBScript
VHDL
VIM
Vala
Vedit
VeriLog
Visual Pro Log
VisualBasic
VisualFoxPro
WHOIS
WhiteSpace
Winbatch
XBasic
XML
XPP
Xojo
Xorg Config
YAML
YARA
Z80 Assembler
ZXBasic
autoconf
jQuery
mIRC
newLISP
q/kdb+
thinBasic
Paste Expiration:
Never
Burn after read
10 Minutes
1 Hour
1 Day
1 Week
2 Weeks
1 Month
6 Months
1 Year
Paste Exposure:
Public
Unlisted
Private
Folder:
(members only)
Password
NEW
Enabled
Disabled
Burn after read
NEW
Paste Name / Title:
Create New Paste
Hello
Guest
Sign Up
or
Login
Sign in with Facebook
Sign in with Twitter
Sign in with Google
You are currently not logged in, this means you can not edit or delete anything you paste.
Sign Up
or
Login
Public Pastes
Improved Sed.cs
C# | 5 hours ago | 11.77 KB
Horrible formatting made better
C# | 5 hours ago | 0.37 KB
How to correctly instantiate an HttpClient
C# | 5 hours ago | 0.72 KB
VLF: VLF Notes: VMware ESXi for VSI/VMS hobby...
20 hours ago | 14.59 KB
best journal
21 hours ago | 0.05 KB
evdev 2nd seat v4.04
Python | 1 day ago | 21.13 KB
LearnDash - Aelia Currency Switcher integrati...
PHP | 1 day ago | 5.25 KB
bcachefs read error
1 day ago | 1.11 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
