Pomoc - Szukaj - Użytkownicy - Kalendarz
Pełna wersja: [MySQL][PHP]Bind Param
Forum PHP.pl > Forum > Przedszkole
Waloch016
19.11.2014, 11:36:54
Czy ktos moze zerknac co tu jest nie tak w kodzie?? Zaznaczam ze wszystkie kolumny w bazie istnieja. i laczyc tez sie laczy bo bledy nie wywala. 
[PHP] pobierz, plaintext 
  1.  <?php
  2. //include database connection
  3. $servername = "localhost";
  4. $username = "root";
  5. $password = "";
  6. $dbname = "system";
  7.  
  8. // Create connection
  9. $conn = new mysqli($servername, $username, $password, $dbname);
  10. // Check connection
  11. if ($conn->connect_error) {
  12.     die("Connection failed: " . $conn->connect_error);
  13. } 
  14.  
  15. // if the form was submitted/posted, update the record
  16. if($_POST){
  17.  
  18.     //write query
  19.     $stmt = $conn->prepare("UPDATE
  20.                 booking 
  21.             VALUES
  22.                 car = ?,
  23.                 date = ?,
  24.                 time = ?,
  25.                 number  = ?,
  26. 				name  = ?,
  27. 				type  = ?,
  28. 				price  = ?
  29.             WHERE
  30.                 id = ?");
  31.  
  32.  
  33.     // you can bind params this way,
  34.     // if you want to see the other way, see our add.php
  35.     $stmt->bind_param(
  36.         'sssissii',
  37.         $_POST['$car'],
  38.         $_POST['$date'],
  39.         $_POST['$time'],
  40.         $_POST['$number'],
  41. 		$_POST['$name'],
  42. 		$_POST['$type'],
  43. 		$_POST['$price'],
  44.         $_GET['$id']
  45.     );
  46.  
  47.     // execute the update statement
  48.     if($stmt->execute()){
  49.         echo "User was updated.";
  50.  
  51.         // close the prepared statement
  52.         $stmt->close();
  53.     }else{
  54.         die("Unable to update.");
  55.     }
  56. }
  57.  
  58. /*
  59.  * select the record to be edited,
  60.  * you can also use prepared statement here,
  61.  * but my hosting provider seems it does not support the mysqli get_result() function
  62.  * you can use it like this one http://php.net/manual/fr/mysqli.prepare.php#107568
  63.  
  64.  * so it I'm going to use $mysqli->real_escape_string() this time.
  65.  */
  66.  
  67. $sql = "SELECT
  68.             id, car, date, time, number, name, type, price
  69.         FROM
  70.             booking
  71.         WHERE
  72.             id = \"" . $conn->real_escape_string($_GET['id']) . "\"
  73.         LIMIT
  74.             0,1";
  75.  
  76.  
  77. // execute the sql query
  78. $result = $conn->query($sql);
  79.  
  80. //get the result
  81. $row = $result->fetch_assoc();
  82.  
  83. // php's extract() makes $row['firstname'] to $firstname automatically
  84. extract($row);
  85.  
  86. //disconnect from database
  87. $result->free();
  88. $conn->close();
  89. ?>
  90.  
  91. <!--we have our html form here where new user information will be entered-->
  92. <form action='edit.php?id=<?php echo $id; ?>' method='post' border='0'>
  93. <fieldset>
  94. <dl>
  95. 	<dt><label for="car" >Car Make:</label></dt>
  96. 	<dd><input name="car" type="text" value="<?php echo $car; ?>"></dd>
  97. 	<dt><label for="date">Date:</label></dt>
  98. 	<dd><input name="date"  type="text" id="datepicker" value="<?php echo $date; ?>"></dd>
  99. 	<dt><label for="time">Arrive Time:</label></dt>
  100. 	<dd><input name="time"  type="text" placeholder="13:00" value="<?php echo $time; ?>"></dd>
  101. 	<dt><label for="number">Tel. No.:</label></dt>
  102. 	<dd><input name="number" type="text" value="<?php echo $number; ?>"></dd>
  103. 	<dt><label for="name">Name:</label></dt>
  104. 	<dd><input name="name" type="text" value="<?php echo $name; ?>"></dd>
  105. 	<dt><label for="type" style="width:450px;">Type:</label></dt>
  106. 	<dd><select name="type" value="<?php echo $type; ?>">
  107.  <option value="0">Select</option>
  108.   <option value="Wash + Vac">Wash + Vac</option>
  109.   <option value="Mini Valet">Mini Valet</option>
  110.   <option value="Full Valet">Full Valet</option>
  111.   <option value="Detar">Detar</option>
  112.   <option value="Other">Other</option>
  113.  </select></dd>
  114. 	<dt><label for="price">Price:</label></dt>
  115. 	<dd><select name="price" value="<?php echo $price; ?>">
  116.  <option value="0">Select</option>
  117.   <option value="10">? 10</option>
  118.   <option value="15">? 15</option>
  119.   <option value="20">? 20</option>
  120.   <option value="25">? 25</option>
  121.   <option value="30">? 30</option>
  122.   <option value="35">? 35</option>
  123.   <option value="40">? 40</option>
  124.   <option value="45">? 45</option>
  125.   <option value="50">? 50</option>
  126.    <option value="55">? 55</option>
  127.   <option value="60">? 60</option>
  128.   <option value="65">? 65</option>
  129.   <option value="70">? 70</option>
  130.   <option value="75">? 75</option>
  131.   <option value="80">? 80</option>
  132.   <option value="85">? 85</option>
  133.   <option value="90">? 90</option>
  134.    <option value="95">? 95</option>
  135.   <option value="100">? 100</option>
  136.   <option value="105">? 105</option>
  137.   <option value="110">? 110</option>
  138.   <option value="115">? 115</option>
  139.   <option value="120">? 120</option>
  140.   <option value="125">? 125</option>
  141.   <option value="130">? 130</option>
  142.  </select></dd>
  143. 	<dt><input type="submit" name="submit" value="Add"></dt></dl>
  144. </fieldset>
  145. </form>
  146.  
  147. </body>
  148. </html>
[PHP] pobierz, plaintext

Szukalem w google, siedze 3 dzien i nie moge nic wyyslic. id, number, price to jest INT w bazie

Zapomnialem, przepraszam: Fatal error: Call to a member function bind_param() on a non-object in C:\wamp\www\edit.php on line 35

Wiem co znaczy blad, nie wiem jak naprawic. tak w razie w to pisze
nospor
19.11.2014, 11:40:12
Czy naprawde to taki problem napisać, czym objawia się błąd?
Turson
19.11.2014, 11:40:48
http://stackoverflow.com/questions/1705346...my-mysqli-query
Policz ile masz ? a ile danych bindujesz.
nospor
19.11.2014, 11:42:26
Zanim zadasz kolejne pytanie zastosuj sie tez do tego:
Temat: Jak poprawnie zada pytanie
Bo masz procz tego co napisał Turson całą masę innych błędów, ale ich nie widzisz, bo nie wyswietlasz ich na ekranie
Waloch016
19.11.2014, 11:47:19
Włączyłem raportowanie i dalej wywala tylko bind param a jak z bind param usunalem id dalej to samo.
nospor
19.11.2014, 11:50:42
Bo FATAL ERROR powoduje, ze nie dochodzisz do pozostalych bledow. Jak sie uporasz z FATAL ERROREM, to zobaczysz inne bledy smile.gif

Zobacz co zwraca ci PREPARE a moze doznasz olsnienia.
Waloch016
19.11.2014, 11:59:28
Nie wiem co jest grane... nie daje rady juz kod mi sie w oczach wli..
Turson
19.11.2014, 12:00:38
Po prostu zobacz w manualu MySQL jak UPDATE powinien wyglądać
Waloch016
19.11.2014, 12:06:46
Ok, mam ale danych w bazie nie zmienia...
nospor
19.11.2014, 12:10:42
Po pierwsze: pokaz kod po poprawkach
Po drugie: a poprawiles bledy o ktorych mowilem? Te bledy, ktore mialy ci sie pojawic po zastosowaniu do tematu, do ktorego cie odeslalem.
Waloch016
19.11.2014, 12:13:52 
[PHP] pobierz, plaintext 
  1.  <?php
  2.  
  3.      error_reporting(E_ALL);
  4.     ini_set('display_errors','1');
  5. //include database connection
  6. $servername = "localhost";
  7. $username = "root";
  8. $password = "";
  9. $dbname = "system";
  10.  
  11. // Create connection
  12. $conn = new mysqli($servername, $username, $password, $dbname);
  13. // Check connection
  14. if ($conn->connect_error) {
  15.     die("Connection failed: " . $conn->connect_error);
  16. } 
  17.  
  18. // if the form was submitted/posted, update the record
  19. if($_POST){
  20.  
  21.     //write query
  22. 	//$stmt == TRUE
  23.     $stmt = $conn->prepare("UPDATE
  24.                 `booking` 
  25.             SET
  26.                 car = ?,
  27.                 date = ?,
  28.                 time = ?,
  29.                 number  = ?,
  30. 				name  = ?,
  31. 				type  = ?,
  32. 				price  = ?
  33.             WHERE
  34.                 id = ?");
  35. 				//var_dump($stmt);
  36.  
  37.  
  38.     // you can bind params this way,
  39.     // if you want to see the other way, see our add.php
  40.     $stmt -> bind_param(
  41.         'sssissii',
  42.         $_POST['$car'],
  43.         $_POST['$date'],
  44.         $_POST['$time'],
  45.         $_POST['$number'],
  46. 		$_POST['$name'],
  47. 		$_POST['$type'],
  48. 		$_POST['$price'],
  49. 		$_POST['id']);
  50.  
  51.     // execute the update statement
  52.     if($stmt->execute()){
  53.         echo "User was updated.";
  54. 		header('Location: booking.php');
  55.  
  56.         // close the prepared statement
  57.         $stmt->close();
  58.     }else{
  59.         die("Unable to update.");
  60.     }
  61. }
  62.  
  63. /*
  64.  * select the record to be edited,
  65.  * you can also use prepared statement here,
  66.  * but my hosting provider seems it does not support the mysqli get_result() function
  67.  * you can use it like this one <a href="http://php.net/manual/fr/mysqli.prepare.php#107568" target="_blank">http://php.net/manual/fr/mysqli.prepare.php#107568</a>
  68.  
  69.  * so it I'm going to use $mysqli->real_escape_string() this time.
  70.  */
  71.  
  72. $sql = "SELECT
  73.             id, car, date, time, number, name, type, price
  74.         FROM
  75.             `booking`
  76.         WHERE
  77.             id = \"" . $conn->real_escape_string($_GET['id']) . "\"
  78.         LIMIT
  79.             0,1";
  80.  
  81.  
  82. // execute the sql query
  83. $result = $conn->query($sql);
  84.  
  85. //get the result
  86. $row = $result->fetch_assoc();
  87.  
  88. // php's extract() makes $row['firstname'] to $firstname automatically
  89. extract($row);
  90.  
  91. //disconnect from database
  92. $result->free();
  93. $conn->close();
  94. ?>
  95.  
  96. <!--we have our html form here where new user information will be entered-->
  97. <form action='edit.php?id=<?php echo $id; ?>' method='post' border='0'>
  98. <fieldset>
  99. <dl>
  100. 	<dt><label for="car" >Car Make:</label></dt>
  101. 	<dd><input name="car" type="text" value="<?php echo $car; ?>"></dd>
  102. 	<dt><label for="date">Date:</label></dt>
  103. 	<dd><input name="date"  type="text" id="datepicker" value="<?php echo $date; ?>"></dd>
  104. 	<dt><label for="time">Arrive Time:</label></dt>
  105. 	<dd><input name="time"  type="text" placeholder="13:00" value="<?php echo $time; ?>"></dd>
  106. 	<dt><label for="number">Tel. No.:</label></dt>
  107. 	<dd><input name="number" type="text" value="<?php echo $number; ?>"></dd>
  108. 	<dt><label for="name">Name:</label></dt>
  109. 	<dd><input name="name" type="text" value="<?php echo $name; ?>"></dd>
  110. 	<dt><label for="type" style="width:450px;">Type:</label></dt>
  111. 	<dd><select name="type" value="<?php echo $type; ?>">
  112.  <option value="0">Select</option>
  113.   <option value="Wash + Vac">Wash + Vac</option>
  114.   <option value="Mini Valet">Mini Valet</option>
  115.   <option value="Full Valet">Full Valet</option>
  116.   <option value="Detar">Detar</option>
  117.   <option value="Other">Other</option>
  118.  </select></dd>
  119. 	<dt><label for="price">Price:</label></dt>
  120. 	<dd><select name="price" value="<?php echo $price; ?>">
  121.  <option value="0">Select</option>
  122.   <option value="10">&euro; 10</option>
  123.   <option value="15">&euro; 15</option>
  124.   <option value="20">&euro; 20</option>
  125.   <option value="25">&euro; 25</option>
  126.   <option value="30">&euro; 30</option>
  127.   <option value="35">&euro; 35</option>
  128.   <option value="40">&euro; 40</option>
  129.   <option value="45">&euro; 45</option>
  130.   <option value="50">&euro; 50</option>
  131.    <option value="55">&euro; 55</option>
  132.   <option value="60">&euro; 60</option>
  133.   <option value="65">&euro; 65</option>
  134.   <option value="70">&euro; 70</option>
  135.   <option value="75">&euro; 75</option>
  136.   <option value="80">&euro; 80</option>
  137.   <option value="85">&euro; 85</option>
  138.   <option value="90">&euro; 90</option>
  139.    <option value="95">&euro; 95</option>
  140.   <option value="100">&euro; 100</option>
  141.   <option value="105">&euro; 105</option>
  142.   <option value="110">&euro; 110</option>
  143.   <option value="115">&euro; 115</option>
  144.   <option value="120">&euro; 120</option>
  145.   <option value="125">&euro; 125</option>
  146.   <option value="130">&euro; 130</option>
  147.  </select></dd>
  148. 	<dt><input type="submit" name="submit" value="Add"></dt></dl>
  149. </fieldset>
  150. </form>
  151.  
  152. </body>
  153. </html>
[PHP] pobierz, plaintext


Nie wywala mi bledow nic a nic
nospor
19.11.2014, 12:18:09
Wywal to:
header('Location: booking.php');

Nadal nie masz bledow na ekranie?
Waloch016
19.11.2014, 12:42:36
Ani jednego. Tylko wyswietla ze jest updated ale nie robi update bazy
nospor
19.11.2014, 12:58:16
Niemozliwe.... przeciez o to:
$_POST['$car'],
$_POST['$date'],
$_POST['$time'],
$_POST['$number'],
.....

Powinno rzucac samymi NOTICEami.... przeciez nie masz w POST takich pol
Waloch016
19.11.2014, 13:18:58
Kompletnie ani jednego bledu. 
[PHP] pobierz, plaintext 
  1.   // execute the update statement
  2.     if($stmt->execute() === TRUE){
  3.         echo "User was updated.";
  4. 		//header('Location: booking.php');
  5.  
  6.         // close the prepared statement
  7.         $stmt->close();
  8.     }else{
  9.         die("Unable to update.");
  10.     }
  11. }
[PHP] pobierz, plaintext


Dalem tak ale dalej bez reakcji
nospor
19.11.2014, 13:22:44
Napisalem ci gdzie masz blad
Dane typu $_POST['$car'],
nie istnieją. Nie masz w formularzu takich pol. Staraj sie prosze czytac dokladniej co ci piszą.

A to ze nie widzisz tych bledow to nadal niemozliwe. No chyba ze masz jakąś wlasną funkcje do obslugi bledow, ale tego w kodzie nie widac.

Bledow tych mozesz tez nie widziec, bo moze masz zwaloną strukture HTML i one są gdzies czyms zasloniete. Pewnie w kodzie wygenerowanej strony juz je zobaczysz.
Waloch016
19.11.2014, 13:51:36
Mam Noticy. Próbuje tak:

[PHP] pobierz, plaintext 
  1.   <?php
  2.  
  3.      error_reporting(E_ALL);
  4.     ini_set('display_errors','1');
  5. //include database connection
  6. $servername = "localhost";
  7. $username = "root";
  8. $password = "";
  9. $dbname = "system";
  10.  
  11. // Create connection
  12. $conn = new mysqli($servername, $username, $password, $dbname);
  13. // Check connection
  14. if ($conn->connect_error) {
  15.     die("Connection failed: " . $conn->connect_error);
  16. } 
  17.  if(isset($_POST['car']) && isset($_POST['date']) && isset($_POST['time']) && isset($_POST['number']) && isset($_POST['name']) && isset($_POST['type']) && isset($_POST['price']))
  18. {
  19.  $car = $_POST['car'];
  20. $date = $_POST['date'];
  21. $time = $_POST['time'];
  22. $number = $_POST['number'];
  23. $name = $_POST['name'];
  24. $type = $_POST['type'];
  25. $price = $_POST['price'];
  26.    }
  27.    else
  28.    {
  29.     echo 'inny';
  30.    }
  31.  
  32. // if the form was submitted/posted, update the record
  33. if($_POST){
  34.  
  35.     //write query
  36. 	//$stmt == TRUE
  37.     $stmt = $conn->prepare("UPDATE
  38.                 `booking` 
  39.             SET
  40.                 car = ?,
  41.                 date = ?,
  42.                 time = ?,
  43.                 number  = ?,
  44. 				name  = ?,
  45. 				type  = ?,
  46. 				price  = ?
  47.             WHERE
  48.                 id = ?");
  49.  
  50. 				//var_dump($stmt);
  51.  
  52.  
  53.     // you can bind params this way,
  54.     // if you want to see the other way, see our add.php
  55.     $stmt -> bind_param(
  56.         'sssissii',
  57.         $_POST['$car'],
  58.         $_POST['$date'],
  59.         $_POST['$time'],
  60.         $_POST['$number'],
  61. 		$_POST['$name'],
  62. 		$_POST['$type'],
  63. 		$_POST['$price'],
  64. 		$_POST['id']);
  65.  
  66.     // execute the update statement
  67.     if($stmt->execute() === TRUE){
  68.         echo "User was updated.";
  69. 		//header('Location: booking.php');
  70.  
  71.         // close the prepared statement
  72.         $stmt->close();
  73.     }else{
  74.         die("Unable to update.");
  75.     }
  76. }
  77. /*
  78.  * select the record to be edited,
  79.  * you can also use prepared statement here,
  80.  * but my hosting provider seems it does not support the mysqli get_result() function
  81.  * you can use it like this one <a href="http://php.net/manual/fr/mysqli.prepare.php#107568" target="_blank">http://php.net/manual/fr/mysqli.prepare.php#107568</a>
  82.  
  83.  * so it I'm going to use $mysqli->real_escape_string() this time.
  84.  */
  85.  
  86. $sql = "SELECT
  87.             id, car, date, time, number, name, type, price
  88.         FROM
  89.             `booking`
  90.         WHERE
  91.             id = \"" . $conn->real_escape_string($_GET['id']) . "\"
  92.         LIMIT
  93.             0,1";
  94.  
  95.  
  96. // execute the sql query
  97. $result = $conn->query($sql);
  98.  
  99. //get the result
  100. $row = $result->fetch_assoc();
  101.  
  102. // php's extract() makes $row['firstname'] to $firstname automatically
  103. extract($row);
  104.  
  105. //disconnect from database
  106. $result->free();
  107. $conn->close();
  108. ?>
  109.  
  110.  <?php
  111.  if(isset($_POST['car']) && isset($_POST['date']) && isset($_POST['time']) && isset($_POST['number']) && isset($_POST['name']) && isset($_POST['type']) && isset($_POST['price']))
  112.    {
  113.  echo'<section id="main">
  114.   <form action="edit.php?id=<?php echo $id; ?>" method="post">
  115. <fieldset>
  116. <dl>
  117.  
  118. 	<input type="hidden" name="id" value="<?php echo $id; ?>" />
  119. 	<dt><label for="car">Car Make:</label></dt>
  120. 	<dd><input name="car" type="text"></dd>
  121. 	<dt><label for="date">Date:</label></dt>
  122. 	<dd><input name="date"  type="text" id="datepicker" ></dd>
  123. 	<dt><label for="time">Arrive Time:</label></dt>
  124. 	<dd><input name="time"  type="text" placeholder="13:00"></dd>
  125. 	<dt><label for="number">Tel. No.:</label></dt>
  126. 	<dd><input name="number" type="text"></dd>
  127. 	<dt><label for="name">Name:</label></dt>
  128. 	<dd><input name="name" type="text"></dd>
  129. 	<dt><label for="type" style="width:450px;">Type:</label></dt>
  130. 	<dd><select name="type">
  131.  <option value="0">Select</option>
  132.   <option value="Wash + Vac">Wash + Vac</option>
  133.   <option value="Mini Valet">Mini Valet</option>
  134.   <option value="Full Valet">Full Valet</option>
  135.   <option value="Detar">Detar</option>
  136.   <option value="Other">Other</option>
  137.  </select></dd>
  138. 	<dt><label for="price">Price:</label></dt>
  139. 	<dd><select name="price">
  140.  <option value="0">Select</option>
  141.   <option value="10">? 10</option>
  142.   <option value="15">? 15</option>
  143.   <option value="20">? 20</option>
  144.   <option value="25">? 25</option>
  145.   <option value="30">? 30</option>
  146.   <option value="35">? 35</option>
  147.   <option value="40">? 40</option>
  148.   <option value="45">? 45</option>
  149.   <option value="50">? 50</option>
  150.    <option value="55">? 55</option>
  151.   <option value="60">? 60</option>
  152.   <option value="65">? 65</option>
  153.   <option value="70">? 70</option>
  154.   <option value="75">? 75</option>
  155.   <option value="80">? 80</option>
  156.   <option value="85">? 85</option>
  157.   <option value="90">? 90</option>
  158.    <option value="95">? 95</option>
  159.   <option value="100">? 100</option>
  160.   <option value="105">? 105</option>
  161.   <option value="110">? 110</option>
  162.   <option value="115">? 115</option>
  163.   <option value="120">? 120</option>
  164.   <option value="125">? 125</option>
  165.   <option value="130">? 130</option>
  166.  </select></dd>
  167. 	<dt><input type="submit" name="submit" value="Add"></dt></dl>
  168. </fieldset>
  169. </form>
  170.  </section>';
  171.    }
  172.    else
  173.    {
  174.     echo 'Blad';
  175.    }
  176. ?>
  177. </body>
  178. </html>
[PHP] pobierz, plaintext

Nie idzie. Dlaczego??
nospor
19.11.2014, 13:57:46
facepalmxd.gif
$_POST['$car'],
Nadal odwolujesz sie do pol, ktorych nie ma....

kurcze, naprawde nie rozrozniasz
$car
od
car
?

Analogicznie reszta
Waloch016
19.11.2014, 14:23:02
Mój błąd nie zauwazylem tego. Tak jak powiedzialem juz mi leb peka ;p Ale mam następne pytanko wink.gif

Mam taki kod wyswietlania:

[PHP] pobierz, plaintext 
  1. <?php
  2. include_once('db.php');
  3.  
  4. $query  = "SELECT * FROM booking ORDER BY date";
  5. $result = $conn -> query($query)
  6.     or die("Query failed");
  7. ?>
  8. <table rules="rows" frame="below" width="100%">
  9. 		<tr>
  10. 			<td bgcolor="#e6e6e6"> </td>
  11. 			<td bgcolor="#e6e6e6">Car:</td>
  12. 			<td bgcolor="#e6e6e6">Date:</td>
  13. 			<td bgcolor="#e6e6e6">Time:</td>
  14. 			<td bgcolor="#e6e6e6">Number:</td>
  15. 			<td bgcolor="#e6e6e6">Name:</td>
  16. 			<td bgcolor="#e6e6e6">Price:</td>
  17. 		</tr>
  18. 	<?php
  19. 	while ($row = mysqli_fetch_array($result)){
  20. 		echo 	"<tr><td>" . $row['id'] . "</td>" .
  21. 					"<td>" . $row['car'] . "</td>" . 
  22. 					"<td>" . $row['date'] . "</td>" .
  23. 					"<td>" . $row['time'] . "</td>" . 
  24. 					"<td>" . $row['number'] . ".</td>" .
  25. 					"<td>" . $row['name'] . "</td>" . 
  26. 					"<td>" . $row['type'] . "</td>" . 
  27. 					"<td>" . $row['price'] . " ?</td></tr>";
  28.  
  29. 	}
  30. 	?>
  31. 	</table>
[PHP] pobierz, plaintext


Działa to idealnie. Moje pytanie jest takie jak wyswetlic zeby co drugi rekord (linia) mial inny kolor. np. szary-bialy-szary-bialy itd... nigdy w sumie nie stylowalem tabeli i sie z nimi nie bawilem wiec nie do konca wiem...
Turson
19.11.2014, 14:46:46
Załatwisz to w CSS nth-child albo w PHP definiujesz zmienną $i przed pętlą, liczysz modulo w petli i inkrementujesz
Marek607
19.11.2014, 15:08:27 
[PHP] pobierz, plaintext 
  1. if ($kolor == "#cccccc") {
  2.         $kolor = "#ffffff";
  3.       } else {
  4.         $kolor = "#cccccc";
  5.       }
  6.       echo "<tr bgcolor=\"".$kolor."\">.........
[PHP] pobierz, plaintext


Waloch016
19.11.2014, 15:15:29
Rozwiazalem wink.gif Zapomnialem napisac:D

[PHP] pobierz, plaintext 
  1. <?php
  2. 	$color="1";
  3. 	while ($row = mysqli_fetch_array($result)){
  4. 	if ($color%2==0) {
  5. 		echo  '<tr bgcolor="#FFFFFF">';
  6.  
  7.  
  8.  
  9. 	}
  10.  
  11. 		else {
  12. 			echo '<tr bgcolor="#ba788f">';
  13.  
  14. 			}
  15. 			$color++;
  16. 			echo '<td>' . $row['id'] . '</td> .
  17. 					<td>' . $row['car'] . '</td> . 
  18. 					<td>' . $row['date'] . '</td> .
  19. 					<td>' . $row['time'] . '</td> . 
  20. 					<td>' . $row['number'] .' </td> .
  21. 					<td>' . $row['name'] . '</td> . 
  22. 					<td>' . $row['type'] . '</td> . 
  23. 					<td><a href="edit.php?id=' . $row[0] .  '">Edit</a></td> .
  24. 					<td><a href="delete.php?id=' . $row[0] . '">Delete</a></td></tr>';
  25.  
  26. 	}
  27.  
  28. 	?>
  29. 	</table>
[PHP] pobierz, plaintext


Moze komus sie przyda wink.gif
Turson
19.11.2014, 15:28:18
Cytat(Marek607 @ 19.11.2014, 15:08:27 ) *
[PHP] pobierz, plaintext 
  1. if ($kolor == "#cccccc") {
  2.         $kolor = "#ffffff";
  3.       } else {
  4.         $kolor = "#cccccc";
  5.       }
  6.       echo "<tr bgcolor=\"".$kolor."\">.........
[PHP] pobierz, plaintext

A skąd wziales $kolor questionmark.gif
nospor
19.11.2014, 15:59:43
@Turson wystarczy ze przed petla jest
$kolor='';
i juz.
A nawet nie musi byc, wystarczy ze koles ma wyłączone raportowanie... i juz smile.gif
Waloch016
19.11.2014, 18:30:50
Pytanko: Chcę zrobic cos takiego ze:

Bedzie button "new day" i po kliknceciu doda mi do bazy aktualna date i tam bedzie wklejac dodane rekordy i cene np: Wash 7 ? a pozniej na koniec dnia bedzie button end day i wyswietli mi strone do druku z rekodami jeden pod drugim np

wash 7
wash 7
wash 7
mini valet 50

posegregowane wedlug nazwy.
i podliczy sume

sum 71 ?

jak to ugryzc?

chodzi o to glownie zeby to bylo posegregowane wedlug dni.
Turson
19.11.2014, 20:25:06
Cytat(nospor @ 19.11.2014, 15:59:43 ) *
@Turson wystarczy ze przed petla jest
$kolor='';
i juz.
A nawet nie musi byc, wystarczy ze koles ma wyłączone raportowanie... i juz smile.gif

Nie doczytałem, że IFie jest nadpisywana zmienna... facepalmxd.gif
Waloch016
19.11.2014, 20:29:29
Masz moze jakis pomysl na moj post o New day?
To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.
Invision Power Board © 2001-2025 Invision Power Services, Inc.