Hallo,
kann mir jemand helfen? Ich habe einige Zeilen Code, welche Abfragen in einer Datenbank machen.
Seit ich php 7 habe funktioniert das nicht mehr. Nach längerem Einlesen, habe ich nun den Hinweis erhalten, dass man jetzt mysqli statt mysql verwenden muss, aber mein Skill bekommt die Änderungen nicht hin
Das ist meine connect.php
und hier die Abfragen in einer anderen Datei:
kann mir jemand helfen? Ich habe einige Zeilen Code, welche Abfragen in einer Datenbank machen.
Seit ich php 7 habe funktioniert das nicht mehr. Nach längerem Einlesen, habe ich nun den Hinweis erhalten, dass man jetzt mysqli statt mysql verwenden muss, aber mein Skill bekommt die Änderungen nicht hin
Das ist meine connect.php
Code:
<?php $dbHost = "localhost"; $dbUser = "d02aa999"; $dbPass = "7777bl321"; $dbName = "d02aa999"; $connect = @mysql_connect($dbHost, $dbUser, $dbPass); $selectDB = @mysql_select_db($dbName, $connect); $utf = @mysql_query( "SET NAMES 'utf8'", $connect ); ?>
HTML-Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <script> function back() { window.history.back(); } </script> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="stylesheet" type="text/css" href="layout.css" /> <title>Order Search</title> </head> <body> <div id="page"> <div class="topNaviagationLink"><a href="index.php">Home</a></div> </div> <div id="mainPicture"> <div class="picture" onclick="window.location='index.php';"> <div id="headerTitle"></div> </div> </div> <div class="contentBox"> <div class="innerBox"> <div class="contentTitle"> <form name="form2" method="post" action="updatemultiple.php"> <table class="table table-bordered table-striped"> <thead> <tr> <th>Auswahl</th> <th>Name Kunde</th> <th>Datum</th> <th>Bestell Nr.:</th> <th>Bestellstatus</th> <th>Paket Nr.:</th> <th>Versandfirma</th> </tr> </thead> <tbody> <?php $id = $_POST['on']; $id2 = $_POST['to']; require ('connect.inc.php'); echo '<input type="hidden" name="myVariable" value="'.($id).'">'; $sql = mysql_query("SELECT customers_name, date_purchased, orders_id, orders_status from orders where orders_id between $id and $id2 ORDER BY orders_id asc"); $query = mysql_query("SELECT orders_status_name,orders_status_id from orders_status where language_id = '2'"); $query2 = mysql_query("SELECT tracking_code, tracking_carrier from orders_tracking where orders_id between $id and $id2 ORDER BY orders_id asc"); $query3 = mysql_query("SELECT ct_carrier,ct_id from carrier_tracking where ct_language_id = '2'"); $c = 0; $d = 0; while($row3 = mysql_fetch_assoc($query3)){ // add each row returned into an array $array[$c] = $row3['ct_carrier']; $arrayid[$d] = $row3['ct_id']; $c++; $d++; } $index = 0; $array2 = array(); $index2 = 0; while ($row2=mysql_fetch_assoc($query)) { $array2[$index] = $row2['orders_status_name']; $array5[$index2] = $row2['orders_status_id']; $index++; $index2++; } while($row = mysql_fetch_array($sql)) { $a = $row['orders_status']; $query11 = mysql_query("SELECT orders_status_name from orders_status where orders_status_id = $a AND language_id='2'"); $row11 = mysql_fetch_array($query11); echo "<tr><td>"; ?> <input name="checkbox-<?php echo $row['orders_id']; ?>" type="checkbox" id="checkbox[]"> <?php $date = new DateTime($row['date_purchased']); echo "</td><td>" . $row['customers_name'];echo "</td><td>" . $date->format('d.m.Y H:i'); echo "</td><td>" . $row['orders_id']; echo"</td><td>"; echo "<select name='order_status-" . $row['orders_id'] . "'>"; echo "<option value='" . $row['orders_status'] . "'>". $row11['orders_status_name'] ."</option>"; for($i = 0;$i<$index;$i++){ echo "<option value='".$array5[$i]."'>".$array2[$i] ."</option>"; } echo "</select>"; echo "</td><td>"; $row33=mysql_fetch_array($query2); echo "<input type='text' name='tracking-" . $row['orders_id'] ."' value='". $row33['tracking_code']."'>"; /* $query45 = mysql_query("SELECT ct_carrier,ct_id from carrier_tracking where ct_id = $tc AND ct_language_id ='2'"); $row312=mysql_fetch_array($query45); echo "<option value='" . $row312['ct_id'] . "'>" . $row312['ct_carrier']. "</option>"; while ($row3=mysql_fetch_array($query3)) { echo "<option value='" . $row3['ct_id'] . "'>" . $row3['ct_carrier'] . "</option>"; } */ $tc = $row33['tracking_carrier']; echo"</td><td>"; echo "<select name='order_statuss-" . $row['orders_id'] . "'>"; $query45 = mysql_query("SELECT ct_carrier,ct_id from carrier_tracking where ct_id = $tc AND ct_language_id='2'"); $row312=mysql_fetch_array($query45); echo "<option value='" . $row312['ct_id'] . "'>" . $row312['ct_carrier']. "</option>"; for($i = 0;$i<$c;$i++){ echo "<option value='" . $arrayid[$i]. "'>" . $array[$i] . "</option>"; } echo "</select>"; } ?> </tbody> </table> <br /> <div align="center"> <input type="submit" value="Update" /> <input type="button" value="zurueck" onclick="back()"> </div> <br /> </form> <br /> <div class="contentText"></div> </div> </div></div></div> <div id="footer"><a href="#">web development</a> by <a href="#">Patt</a></div> </body> </html>
Kommentar