Pomoc - Szukaj - Użytkownicy - Kalendarz
Pełna wersja: [MySQL][PHP]nie wyświetla rekordów z mysql
Forum PHP.pl > Forum > Przedszkole
cheep
6.09.2011, 09:21:18
witam. mam tai mały problem i potrzebuje pomocy. stronka ktora stworzylem dziala i wszystko bylo ok do momentu kiedy wrzucilem do niej opcej logowania. nie wiem dlaczego ale nie wyswietla rekordow z mysql'a. prosze o pomoc.
[PHP] pobierz, plaintext 
  1. <?
  2. require('conn.php');
  3.  
  4. $czasyear = date("Y");
  5. $czasmonth = date("m");
  6. $czasday = date("d");
  7.  
  8. $month = '08'; /*miesiąc który oglądamy*/
  9. ?>
  10.  
  11. <?
  12.  
  13. session_start();
  14.  
  15. if (isset($_SESSION['user_id']) and isset($_SESSION['login']))
  16.  
  17. {
  18.  
  19. echo '
  20. 	<center>
  21.  
  22. 	<div id="indexlogo" style="margin-top:50px">TANK-ROZ</div>
  23.     <div id="rap_home">
  24.  
  25.     	<table cellpadding="0" cellspacing="0" style="margin:0; padding:0;"><tr>
  26.  
  27.             <td valign="top">
  28.             <table id="table_raport">
  29.             <thead><tr><td colspan="3">TRANS-HAND</td></tr>
  30.             <tr><td width="33%">Data</td><td width="33%">Kwota</td><td width="33%">Do zapł.</td></tr></thead>
  31.             	 <?
  32. 				$zapytanie = "SELECT * FROM `partners` WHERE `id_mark_par`=1 AND `month_par` = '.$month.' ";
  33. 		   $result = mysql_query($zapytanie);
  34. 				while ($wiersz = mysql_fetch_array($result)) {
  35.     				echo "
  36. 					<tbody><tr>
  37.                     <td>'.{$wiersz['year_par']}.'-'.{$wiersz['month_par']}.'-'.{$wiersz['day_par']}.'</td>
  38.                     <td>'.($wiersz['cash_par']).' zł</td><td style="background-color:#F8F489">'.($wiersz['topay_par']).' zł</td>
  39.                     </tr>
  40.  
  41.  
  42.             </table>
  43.             </td>
  44.  
  45.      	</div>
  46.  
  47.  
  48.             <td valign="top">
  49.             <table id="table_raport">
  50.             <thead><tr><td colspan="3">KRISTINE</td></tr>
  51.             <tr><td width="33%">Data</td><td width="33%">Kwota</td><td width="33%">Do zapł.</td></tr></thead>
  52.             	 ?>
  53. 				<?
  54. 				$zapytanie = "SELECT * FROM `partners` WHERE `id_mark_par`=2 AND `month_par` = $month ";
  55. 		   $result = mysql_query($zapytanie);
  56. 				while ($wiersz = mysql_fetch_array($result)) {
  57.     				echo "
  58. 					<tbody><tr>
  59.                     <td>'.($wiersz['year_par']).'-'.($wiersz['month_par']).'-'.($wiersz['day_par']).'</td>
  60.                     <td>'.($wiersz['cash_par']).' zł</td><td style="background-color:#F8F489">'.($wiersz['topay_par']).' zł</td>
  61.                     </tr>
  62.  
  63.             </table>
  64.             </td>
  65.  
  66.  
  67.             <td valign="top">
  68.             <table id="table_raport">
  69.             <thead><tr><td colspan="3">METRA-DREW</td></tr>
  70.             <tr><td width="33%">Data</td><td width="33%">Kwota</td><td width="33%">Do zapł.</td></tr></thead>
  71.             	 ?>
  72. 				<?
  73. 				$zapytanie = "SELECT * FROM `partners` WHERE `id_mark_par`=3 AND `month_par` = $month ";
  74. 		   $result = mysql_query($zapytanie);
  75. 				while ($wiersz = mysql_fetch_array($result)) {
  76.     				echo "
  77. 					<tbody><tr>
  78.                     <td>{'.$wiersz['year_par'].'}-{'.$wiersz['month_par'].'}-{'.$wiersz['day_par'].'}</td>
  79.                     <td>{'.$wiersz['cash_par'].'} zł</td><td style="background-color:#F8F489">{'.$wiersz['topay_par'].'} zł</td>
  80.                     </tr>
  81.  
  82.  
  83.             </table>
  84.             </td>
  85.  
  86.  
  87.             <td valign="top">
  88.             <table id="table_raport">
  89.             <thead><tr><td colspan="3">UT SUPEL JAN</td></tr>
  90.             <tr><td width="33%">Data</td><td width="33%">Kwota</td><td width="33%">Do zapł.</td></tr></thead>
  91.             	 ?>
  92. 				<?
  93. 				$zapytanie = "SELECT * FROM `partners` WHERE `id_mark_par`=4 AND `month_par` = $month ";
  94. 		   $result = mysql_query($zapytanie);
  95. 				while ($wiersz = mysql_fetch_array($result)) {
  96.     				echo "
  97. 					<tbody><tr>
  98.                     <td>{'.$wiersz['year_par'].'}-{'.$wiersz['month_par'].'}-{'.$wiersz['day_par'].'}</td>
  99.                     <td>{'.$wiersz['cash_par'].'} zł</td><td style="background-color:#F8F489">{'.$wiersz['topay_par'].'} zł</td>
  100.                     </tr>
  101.  
  102.  
  103.             </table>
  104.             </td>
  105.  
  106.  
  107.             <td valign="top">
  108.             <table id="table_raport">
  109.             <thead><tr><td colspan="3">INNI</td></tr>
  110.             <tr><td width="33%">Data</td><td width="33%">Kwota</td><td width="33%">Do zapł.</td></tr></thead>
  111.             	 ?>
  112. 				<?
  113. 				$zapytanie = "SELECT * FROM `partners` WHERE `id_mark_par`=5 AND `month_par` = $month ";
  114. 		   $result = mysql_query($zapytanie);
  115. 				while ($wiersz = mysql_fetch_array($result)) {
  116.     				echo "
  117. 					<tbody><tr>
  118.                     <td>{'.$wiersz['year_par'].'}-{'.$wiersz['month_par'].'}-{'.$wiersz['day_par'].'}</td>
  119.                     <td>{'.$wiersz['cash_par'].'} zł</td><td style="background-color:#F8F489">{'.$wiersz['topay_par'].'} zł</td>
  120.                     </tr>
  121.  
  122.  
  123.             </table>
  124.             </td>
  125.  
  126. </tr></table> 
  127.  
  128.             <div style="height:50px; width:1090px; background-color:#6D8AA8">
  129.             <table cellpadding="0" cellspacing="0" style="margin:0; padding:0;">
  130.             <tr>
  131.             <td>
  132.             	<table id="table_raport" style="margin-left:0px;">
  133.  
  134. 					<?
  135. 					$q = mysql_query("SELECT SUM(topay_par) AS `trans` FROM `partners` WHERE `id_mark_par`=1 AND `month_par` = $month  ");
  136. 					$a = mysql_fetch_array($q);
  137.     					echo "
  138. 						<tr>
  139. 						<td>SUMA:</td>
  140. 						<td style="background-color:#F8F489" width="33%">{'.$a['trans'].'} zł</td>
  141. 						</tr>
  142.                 </table>
  143.             </td>
  144.             <td>
  145.             	<table id="table_raport">
  146.                 	?>
  147. 					<?
  148. 					$q = mysql_query("SELECT SUM(topay_par) AS `trans` FROM `partners` WHERE `id_mark_par`=2 AND `month_par` = $month  ");
  149. 					$a = mysql_fetch_array($q);
  150.     					echo "
  151. 						<tr>
  152. 						<td>SUMA:</td>
  153. 						<td style="background-color:#F8F489" width="33%">{'.$a['trans'].'} zł</td>
  154. 						</tr>
  155.                 </table>
  156.          	</td>
  157.             <td>
  158.             	<table id="table_raport">
  159.                 	?>
  160. 					<?
  161. 					$q = mysql_query("SELECT SUM(topay_par) AS `trans` FROM `partners` WHERE `id_mark_par`=3 AND `month_par` = $month  ");
  162. 					$a = mysql_fetch_array($q);
  163.     					echo "
  164. 						<tr>
  165. 						<td>SUMA:</td>
  166. 						<td style="background-color:#F8F489" width="33%">{'.$a['trans'].'} zł</td>
  167. 						</tr>
  168.                 </table>
  169.             </td>
  170.             <td>
  171.             	<table id="table_raport">
  172.                 	?>
  173. 					<?
  174. 					$q = mysql_query("SELECT SUM(topay_par) AS `trans` FROM `partners` WHERE `id_mark_par`=4 AND `month_par` = $month  ");
  175. 					$a = mysql_fetch_array($q);
  176.     					echo "
  177. 						<tr>
  178. 						<td>SUMA:</td>
  179. 						<td style="background-color:#F8F489" width="33%">{'.$a['trans'].'} zł</td>
  180. 						</tr>
  181.                 </table>
  182.             </td>
  183.             <td>
  184.             	<table id="table_raport">
  185.                 	?>
  186. 					<?
  187. 					$q = mysql_query("SELECT SUM(topay_par) AS `trans` FROM `partners` WHERE `id_mark_par`=5 AND `month_par` = $month  ");
  188. 					$a = mysql_fetch_array($q);
  189.     					echo "
  190. 						<tr>
  191. 						<td>SUMA:</td>
  192. 						<td style="background-color:#F8F489" width="33%">{'.$a['trans'].'} zł</td>
  193. 						</tr>
  194.                 </table>
  195.             </td>
  196.             </tr>
  197.             </table>
  198.             		?>
  199.             </div>
  200.  
  201.     </div>
  202.  
  203.     	<div id="dodaj"><a href="dodaj.php">Dodaj</a></div>
  204.  
  205.  
  206. </center>';
  207.  
  208. }
  209.  
  210. else
  211.  
  212. {
  213.  
  214. echo "Nie jestes zalogowany";
  215.  
  216.  
  217.  
  218. }
  219. ?>
[PHP] pobierz, plaintext
nospor
6.09.2011, 09:24:14
Temat: Jak poprawnie zada pytanie
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.