sa incep cu exact ce as avea nevoie:
la www.knicksonline.as.ro/0304/schedule.php am creat programul meciurilor din sezon 2003-04
am folosit urmatorul cod:
CODE |
<?echo ' <div align=center><span class=headline>2003-04 Schedule</span></div><p>'; echo ' <center><table width=100% border=0 cellpading=1 cellspacing=0><tr><td bgcolor=003399 colspan=7><font color=ffffff><b>Knicks Schedule 2003-04</b></font></td></tr><tr> <td bgcolor=ff8800 width=9%><font color=003399><b>Game</b></font></td> <td bgcolor=ff8800 width=25%><font color=003399><div align=center><b>Date</b></div></font></td> <td bgcolor=ff8800 width=27%><font color=003399><b>Opponent</b></font></td> <td bgcolor=ff8800 width=16%><font color=003399><b>Result</b></font></td> <td bgcolor=ff8800 width=15%><font color=003399><b>Record</b></font></td> <td bgcolor=ff8800 width=8%><font color=003399></font></td> </tr>'; $sql = 'SELECT * FROM kol_recaps WHERE val=1 ORDER BY date'; $query = mysql_query($sql); while($row = mysql_fetch_array($query)) { echo " <tr> <td>".$row['id']."</td> <td><div align=center>".$row['date']."</div></td> <td>".$row['opponent']."</td> <td>".$row['result']."</td> <td>".$row['record']."</td> <td><a href=recap.php?date=".$row['date'].">Recap</a></td> </tr>"; } $sql = 'SELECT * FROM kol_recaps WHERE val=0 ORDER BY date'; $query = mysql_query($sql); while($row = mysql_fetch_array($query)) { echo " <tr><td>".$row['id']."</td><td><div align=center>".$row['date']."</div></td><td>".$row['opponent']."</td><td>".$row['result']."</td><td>".$row['record']."</td><td></td></tr>"; } echo"</table></center>"; ?> |
CODE |
<?php include "db.php"; $date=$_POST['date']; $opponent=$_POST['opponent']; $query="INSERT INTO $kol_recaps (date, opponent, result, record, name_recap, recap, val) VALUES ('$date', '$opponent', '$result', '$record', '$name_recap', '$recap', '$val')"; $result=mysql_query($query) or die (mysql_error()); mysql_close(); header("Location: addrecap.php"); ?> |
CODE |
<html><body> <? $foo="bar"; if ($foo) { ?> variable foo exists <? } else { ?> variable foo does not exist <? } ?> </body></html> |
CODE |
// start add user table echo "\n\t\t<TABLE WIDTH=100% CELLPADDING=0 CELLSPACING=0>"; echo "\n\t\t\t<FORM NAME=AddRecords ACTION=\".\\postrecap.php\" METHOD=POST>"; // add title echo "\n\t\t\t<TR>"; echo "\n\t\t\t\t<TD COLSPAN=2 ALIGN=\"center\">Add New Record</TD>"; echo "\n\t\t\t</TR>"; // add opponent echo "\n\t\t\t<TR>"; echo "\n\t\t\t\t<TD WIDTH=50% ALIGN=\"right\">Opponent</TD>"; echo "\n\t\t\t\t<TD WIDTH=50% ALIGN=\"left\">"; echo "\n\t\t\t\t\t<INPUT TYPE=\"text\" NAME=\"Opponent\" MAXLENGTH=255 SIZE=30>"; echo "\n\t\t\t\t</TD>"; echo "\n\t\t\t</TR>"; // add record echo "\n\t\t\t<TR>"; echo "\n\t\t\t\t<TD WIDTH=50% ALIGN=\"right\">Record</TD>"; echo "\n\t\t\t\t<TD WIDTH=50% ALIGN=\"left\">"; echo "\n\t\t\t\t\t<INPUT NAME=\"Record\" MAXLENGTH=255 SIZE=30>"; echo "\n\t\t\t\t</TD>"; echo "\n\t\t\t</TR>"; // si in genu' asta si celelalte // ........ // ........ // end add user table echo "\n\t\t\t</FORM>\n"; echo "\n\t\t</TABLE>" |