par
mika56 » 09 mai 2007, 16:58
Merci NoNos, c'est effectivement tres utilise. Maintenant j'ai modifié mon code, j'ai rajouté des
un peu partout, et ma page s'affiche, mais tout ce qui est
par exemple
$donnees['titre']
ne s'affiche pas, c'est comme si MySQL ne retournait aucune données !! Voici donc mon fichier, tel qu'il est maintenant:
<?php
include('config.inc.php');
connexionbdd(); // ouverture de la connexion
if (isset($_GET['v'])) {
$id = '$_GET[\'v\']';
$sql = 'SELECT * FROM video WHERE id="$id" LIMIT 1';
$requete = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
while ($donnees = mysql_fetch_assoc($requete));
{
echo $donnees['titre'] ;
?>
<table align="center" cellpadding="0" cellspacing="0">
<tbody>
<tr valign="top">
<td width="451">
<object id='player' name='player' width='352' height='314' classid='CLSID:22D6F312-B0F6-11D0-94AB-0080C74C7E95' codebase='http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=5,1,52,701'>
<param name='FileName' value='<?php echo $donnees['urlvideo']; ?>'>
<param name='ShowControls' value='TRUE'>
<param name='AutoStart' value='FALSE'>
<param name='AnimationAtStart' value='TRUE'>
<param name='ShowDisplay' value='FALSE'>
<param name='TransparentAtStart' value='FALSE'>
<param name='ShowStatusbar' value='TRUE'>
<param name='enableContextMenu' value='FALSE'>
<param name='AllowChangeDisplaySize' value='TRUE'>
<param name='AutoSize' value='TRUE'>
<param name='EnableFullScreenControls' value='FALSE'>
<embed type='video/x-ms-asf-plugin'
pluginspage='http://www.microsoft.com/Windows/Downloads/Contents/Products/MediaPlayer/'
src='<?php echo $donnees['urlvideo'] ; ?>'
name='player'
autostart='0'
showcontrols='1'
showdisplay='0'
showstatusbar='1'
animationatstart='1'
transparentatstart='0'
allowchangedisplaysize='1'
autosize='1'
displaysize='0'
enablecontextmenu='0'
windowless='1'
width='352'
height='314'
enablefullscreencontrols='0'>
</embed>
</object>
<br>
<br>
</td>
<td width="557">
<?php echo $donnees['desclongue']; ?></div>
<form name="urlForm" id="urlForm">
<table id="vidFacetsTable" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td width="95">URL</td>
<td width="461"><input name="video_link" type="text" value="http://<?php echo "$url" ?>video.php?v=<?php echo $donnees['id']; ?>" size="80" readonly="true"> </td>
</tr>
<tr>
<td>Integré</td>
<td><input name="ingre" type="text" value="
<object id='player' name='player' width='352' height='314' classid='CLSID:22D6F312-B0F6-11D0-94AB-0080C74C7E95' codebase='http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=5,1,52,701'>
<param name='FileName' value='<?php echo $donnees['urlvideo']; ?>'>
<param name='ShowControls' value='TRUE'>
<param name='AutoStart' value='FALSE'>
<param name='AnimationAtStart' value='TRUE'>
<param name='ShowDisplay' value='FALSE'>
<param name='TransparentAtStart' value='FALSE'>
<param name='ShowStatusbar' value='TRUE'>
<param name='enableContextMenu' value='FALSE'>
<param name='AllowChangeDisplaySize' value='TRUE'>
<param name='AutoSize' value='TRUE'>
<param name='EnableFullScreenControls' value='FALSE'>
<embed type='video/x-ms-asf-plugin'
pluginspage='http://www.microsoft.com/Windows/Downloads/Contents/Products/MediaPlayer/'
src='<?php echo $donnees['urlvideo']; ?>'
name='player'
autostart='0'
showcontrols='1'
showdisplay='0'
showstatusbar='1'
animationatstart='1'
transparentatstart='0'
allowchangedisplaysize='1'
autosize='1'
displaysize='0'
enablecontextmenu='0'
windowless='1'
width='352'
height='314'
enablefullscreencontrols='0'>
</embed>
</object>" size="80"readonly="true"> </td>
</tr>
</tbody>
</table>
</form>
</td>
</tr>
</tbody>
</table>
<?php
}
mysql_close(); // fermeture de la connexion
}
else
echo 'Merci de choisir une video'
?>
et la structure de ma base :
CREATE TABLE `video` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`nom` text NOT NULL ,
`image` text NOT NULL ,
`desccourte` text NOT NULL ,
`desclongue` text NOT NULL ,
`urlvideo` text NOT NULL ,
KEY `id` ( `id` )
) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;
INSERT INTO `video` ( `id` , `nom` , `image` , `desccourte` , `desclongue` , `urlvideo` )
VALUES ( 1, 'Video de test1', '
http://www.ptitlu.org/blog/uploads/imag ... s9ythb.png', 'Une video de test, on essayera de pas depassser les 100 caracteres', 'Et la une description longueeeeeeeeeeeeee, on a le droitttttt de metreeeeee onn va dirrrrr jusqu''a 255 caracteressss', 'urldunevideoenlevepourgarderlanonyma:D' ) ;
J'espere qu'il y a asé de details pour que vous puissiez m'aider

Merci NoNos, c'est effectivement tres utilise. Maintenant j'ai modifié mon code, j'ai rajouté des [code];[/code] un peu partout, et ma page s'affiche, mais tout ce qui est [quote]par exemple [php]$donnees['titre'][/php][/quote] ne s'affiche pas, c'est comme si MySQL ne retournait aucune données !! Voici donc mon fichier, tel qu'il est maintenant: [php]<?php
include('config.inc.php');
connexionbdd(); // ouverture de la connexion
if (isset($_GET['v'])) {
$id = '$_GET[\'v\']';
$sql = 'SELECT * FROM video WHERE id="$id" LIMIT 1';
$requete = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
while ($donnees = mysql_fetch_assoc($requete));
{
echo $donnees['titre'] ;
?>
<table align="center" cellpadding="0" cellspacing="0">
<tbody>
<tr valign="top">
<td width="451">
<object id='player' name='player' width='352' height='314' classid='CLSID:22D6F312-B0F6-11D0-94AB-0080C74C7E95' codebase='http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=5,1,52,701'>
<param name='FileName' value='<?php echo $donnees['urlvideo']; ?>'>
<param name='ShowControls' value='TRUE'>
<param name='AutoStart' value='FALSE'>
<param name='AnimationAtStart' value='TRUE'>
<param name='ShowDisplay' value='FALSE'>
<param name='TransparentAtStart' value='FALSE'>
<param name='ShowStatusbar' value='TRUE'>
<param name='enableContextMenu' value='FALSE'>
<param name='AllowChangeDisplaySize' value='TRUE'>
<param name='AutoSize' value='TRUE'>
<param name='EnableFullScreenControls' value='FALSE'>
<embed type='video/x-ms-asf-plugin'
pluginspage='http://www.microsoft.com/Windows/Downloads/Contents/Products/MediaPlayer/'
src='<?php echo $donnees['urlvideo'] ; ?>'
name='player'
autostart='0'
showcontrols='1'
showdisplay='0'
showstatusbar='1'
animationatstart='1'
transparentatstart='0'
allowchangedisplaysize='1'
autosize='1'
displaysize='0'
enablecontextmenu='0'
windowless='1'
width='352'
height='314'
enablefullscreencontrols='0'>
</embed>
</object>
<br>
<br>
</td>
<td width="557">
<?php echo $donnees['desclongue']; ?></div>
<form name="urlForm" id="urlForm">
<table id="vidFacetsTable" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td width="95">URL</td>
<td width="461"><input name="video_link" type="text" value="http://<?php echo "$url" ?>video.php?v=<?php echo $donnees['id']; ?>" size="80" readonly="true"> </td>
</tr>
<tr>
<td>Integré</td>
<td><input name="ingre" type="text" value="
<object id='player' name='player' width='352' height='314' classid='CLSID:22D6F312-B0F6-11D0-94AB-0080C74C7E95' codebase='http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=5,1,52,701'>
<param name='FileName' value='<?php echo $donnees['urlvideo']; ?>'>
<param name='ShowControls' value='TRUE'>
<param name='AutoStart' value='FALSE'>
<param name='AnimationAtStart' value='TRUE'>
<param name='ShowDisplay' value='FALSE'>
<param name='TransparentAtStart' value='FALSE'>
<param name='ShowStatusbar' value='TRUE'>
<param name='enableContextMenu' value='FALSE'>
<param name='AllowChangeDisplaySize' value='TRUE'>
<param name='AutoSize' value='TRUE'>
<param name='EnableFullScreenControls' value='FALSE'>
<embed type='video/x-ms-asf-plugin'
pluginspage='http://www.microsoft.com/Windows/Downloads/Contents/Products/MediaPlayer/'
src='<?php echo $donnees['urlvideo']; ?>'
name='player'
autostart='0'
showcontrols='1'
showdisplay='0'
showstatusbar='1'
animationatstart='1'
transparentatstart='0'
allowchangedisplaysize='1'
autosize='1'
displaysize='0'
enablecontextmenu='0'
windowless='1'
width='352'
height='314'
enablefullscreencontrols='0'>
</embed>
</object>" size="80"readonly="true"> </td>
</tr>
</tbody>
</table>
</form>
</td>
</tr>
</tbody>
</table>
<?php
}
mysql_close(); // fermeture de la connexion
}
else
echo 'Merci de choisir une video'
?>[/php]
et la structure de ma base :
[quote]CREATE TABLE `video` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`nom` text NOT NULL ,
`image` text NOT NULL ,
`desccourte` text NOT NULL ,
`desclongue` text NOT NULL ,
`urlvideo` text NOT NULL ,
KEY `id` ( `id` )
) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;
INSERT INTO `video` ( `id` , `nom` , `image` , `desccourte` , `desclongue` , `urlvideo` )
VALUES ( 1, 'Video de test1', 'http://www.ptitlu.org/blog/uploads/images/icones/info.s9ythb.png', 'Une video de test, on essayera de pas depassser les 100 caracteres', 'Et la une description longueeeeeeeeeeeeee, on a le droitttttt de metreeeeee onn va dirrrrr jusqu''a 255 caracteressss', 'urldunevideoenlevepourgarderlanonyma:D' ) ;[/quote]
J'espere qu'il y a asé de details pour que vous puissiez m'aider ;)