HanuAncutei.com - ARTA de a conversa!
Haine Dama designer roman

Bine ati venit ca musafir! ( Logare | Inregistrare )

> Am Nevoie De Un, PHP-ist
rady
mesaj 6 Oct 2003, 11:10 AM
Mesaj #1


Haiduc
**

Grup: Musterii
Mesaje: 51
Inscris: 24 June 03
Forumist Nr.: 408



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>";
?>

as avea nevoie de un form prin care sa pot modifica in tabel, si sa adaug result, record, plus un articol

targetul acestui form va fi postrecap.php
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");
?>


se pricepe cineva ? huh.gif


--------------------
X

KNICKSONLINE.COM
Go to the top of the page
 
+Quote Post

Mesaje in acest topic
rady   Am Nevoie De Un   6 Oct 2003, 11:10 AM
avataru   te-as ajuta cu mare placere dear nu prea inteleg d...   7 Oct 2003, 08:20 PM
cretze   ... o sa incerc maine sau poimaine sa ai un exempl...   8 Oct 2003, 08:06 AM
cretze   ... scuze de intarziere ... am fost foarte ocupat ...   13 Oct 2003, 09:18 AM
rady   Am uitat de subiect. Cretze, codul nu merge... Vre...   5 Nov 2003, 08:52 PM
TNT   Salut . Eu ma pricepo la programare PHP si MySQL ...   13 Jan 2004, 03:59 PM
axel   Bine ai venit TNT   15 Jan 2004, 10:01 AM


Reply to this topicStart new topic

 



RSS Versiune Text-Only Data este acum: 12 May 2024 - 09:34 AM
Ceaiuri Medicinale Haine Dama Designer Roman