PHP Helper::text Exemples

Exemple #1

Fichier : demorecensioner.php Projet : rocafuerte/opus

    $songs = new Query("demo_songs");
    $songs->whereQuery("*", "demo_id", $_GET['demo_id'], "demo_id", "ASC", 1);
    if ($songs->getNumRows() > 0) {
        ?>
  
			<embed src="jw_mp3_player/mp3player.swf" width="320" height="140" allowfullscreen="true" allowscriptaccess="always" flashvars="&file=jw_mp3_player/mysql_playlist_demo.php?demo_id=<?php 
        echo $_GET['demo_id'];
        ?>
&height=140&width=320&displaywidth=120" />
		<?php 
    }
    ?>
    
    </div>
    <div class="textContainer"><?php 
    echo Helper::text($query->getResultRow("text"));
    ?>
    <br /><br />
    <a href="<?php 
    echo $query->getResultRow("link_url");
    ?>
"><?php 
    echo $query->getResultRow("link_url");
    ?>
</a>
    <br />
     
   
    </div>

<?php 

Exemple #2

Fichier : admin_vimmel_edit.php Projet : rocafuerte/opus

<?php

include "admin_header.php";
$query = "SELECT * FROM vimmel_images \n\t\tLEFT JOIN bilder\n\t\tON vimmel_images.image_id = bilder.id\n\t\tWHERE vimmel_images.rowid='" . $_GET['id'] . "'";
$result = mysql_query($query) or die(mysql_error());
?>

<form action="admin_vimmel_action.php" method="post">
<?php 
while ($row = mysql_fetch_assoc($result)) {
    echo '<img src="../image_thumb.php?source=' . $uploaded_images . '/' . $row['file'] . '&width=340" border="0" />';
    ?>
  
	<br />
	<textarea name="description" cols="50" rows="5"><?php 
    echo Helper::text($row['description']);
    ?>
</textarea>
    <input type="hidden" name="id" value="<?php 
    echo $_GET['id'];
    ?>
" />
    <input type="hidden" name="category" value="<?php 
    echo $_GET['category'];
    ?>
" />
	<?php 
}
?>
<br/>
<br/>

Exemple #3

Fichier : vimmel.php Projet : rocafuerte/opus_static

        ?>
            
			</td>
		  </tr>
		  <tr>
			<td align="right" class="smallGrey2"><?php 
        if ($query->getResultRow("photo") != "") {
            echo 'Foto: ' . $query->getResultRow("photo") . '</span>';
        }
        ?>
			</td>
		  </tr>
		</table>
	
		<div class="thumbnailDesc"><span class="smallWhite"><?php 
        echo Helper::text($query->getResultRow("description"));
        ?>
</span><br /><br />
		</div>
	  </div>
	  <?php 
    }
    ?>
	  <br />
	  <br />  
		  <div class="thumbnailContainer">
			<?php 
    if (Helper::isInt($_GET['category'])) {
        $query = new Query("vimmel_images");
        $query->whereLeftJoinImageQuery("*", "category", $_GET['category'], "date", "DESC");
        // Dont forget the Javascript (effect.js)!!!

Exemple #4

Fichier : admin_news_edit.php Projet : rocafuerte/opus

  </div>
  <h4>Titel</h4>
  <input name="title" maxlength="50" id="title"  size="50" type="text" value="<?php 
echo htmlspecialchars($title, ENT_QUOTES);
?>
" onKeyUp="setValue('titleShow',this.value,'title')"/>
  <br/>
  <h4>Beskrivning</h4>
  <textarea name="description" cols="50" rows="5" id="description" onKeyUp="setValue('descriptionShow',this.value,'text')"><?php 
echo Helper::text($description);
?>
</textarea>
  <br />
  <h4>Sj&auml;lva texten</h4>
  <textarea name="text" cols="50" rows="15" id="text" onKeyUp="setValue('textShow',this.value,'text')"><?php 
echo Helper::text($text);
?>
</textarea>
  <br/>
    <h4>F&auml;rg</h4>
    Vit
    <input type="radio" <?php 
echo $color == "white" ? "checked" : "";
?>
 value="white"  name="color"/>
    Svart
    <input type="radio" <?php 
echo $color == "black" ? "checked" : "";
?>
 value="black" name="color"/>
<br />

Exemple #5

Fichier : contestWinners.php Projet : rocafuerte/opus_static

<?php

include "header_inc.php";
?>

<div id="centerDiv">
<div class="newsBg">
<span class="newsHeaderSmaller">T&auml;vlingsvinnare</span><br><br>
<?php 
setlocale(LC_ALL, 'sv_SE');
$query = "SELECT * FROM competition_answers \n\t\tLEFT JOIN competitions\n\t\tON competition_answers.answerComp_id = competitions.rowid\n\t\tWHERE competition_answers.answerWinner='1'\n\t\tGROUP BY competitions.title\n\t\tORDER BY competitions.date DESC\n\t\tLIMIT 0,25";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_object($result)) {
    echo '<span class="boldPink">' . strtoupper($row->title) . '</span><br/>';
    if (trim($row->answer) != "") {
        echo '<span class="boldGrey">Svar: </span>' . Helper::text($row->answer) . '<br />';
    }
    echo '<span class="boldGrey">Vinnare </span><br/>';
    $query2 = "SELECT * FROM competition_answers WHERE answerWinner=1 AND answerComp_id='" . $row->rowid . "'";
    $result2 = mysql_query($query2) or die(mysql_error());
    while ($row2 = mysql_fetch_object($result2)) {
        echo '<span class="">' . $row2->answerName . ' - ' . $row2->answerCity . '</span><br/>';
    }
    echo '<br/>';
}
?>
</div>
</div>
o

include "footer.php" ?>

Exemple #6

Fichier : admin_personal.php Projet : rocafuerte/standard2

    $query = "UPDATE personal SET first_name='" . $_POST['first_name'] . "', last_name='" . $_POST['last_name'] . "', \n\t\t\tdescription='" . $_POST['description'] . "', email='" . $_POST['email'] . "', personalImage='{$imageFilename}'\n\t\t\tWHERE username='******'admin_logged'] . "'";
    $result = mysql_query($query) or die(mysql_error());
}
echo "<h2>" . $_SESSION['admin_logged'] . "</h2>";
?>

<div id="personalForm">

<?php 
$query = "SELECT * \n\t\tFROM personal\n\t\tWHERE personal.username='******'admin_logged'] . "'";
$result = mysql_query($query) or die(mysql_error());
$imageFilename = mysql_result($result, 0, 'personalImage');
$first_name = mysql_result($result, 0, 'first_name');
$last_name = mysql_result($result, 0, 'last_name');
$email = mysql_result($result, 0, 'email');
$description = Helper::text(mysql_result($result, 0, 'description'));
?>

<div id="personalForm">

<form action="<?php 
echo $_SERVER['PHP_SELF'];
?>
" method="POST" name="personal">


<div id="imageShow" limit="1" maxWidth="100">
<?php 
/*
	
	 if($imageFilename!=""){ 

Exemple #7

Fichier : admin_shop.php Projet : rocafuerte/opus

         echo '<span id="' . $obj->s_imageID . '">' . "\n";
         echo '<img src="image_thumb.php?source=../' . $uploaded_images . '/' . $obj->file . '&width=340" />' . "\n";
         echo '<a href="#" removeImageId="' . $obj->s_imageID . '" >' . "\n";
         echo '<img src="graphics/minus.jpg" width="10" border="0" alt="Ta bort"/>' . "\n";
         echo '</a>' . "\n";
         echo '<input type="hidden" name="imageArray[]" id="' . $obj->s_imageID . '" value="' . $obj->s_imageID . '" />' . "\n";
         echo '</span>' . "\n";
     }
     echo '</span>' . "\n";
     echo '<span id="imageShow" limit="1" maxWidth="340" maxHeight="200"></span> <br/><br />';
     echo '<h3>Artikel</h3>';
     echo '<input size="60"  type="field" name="title" value="' . htmlspecialchars($obj->s_title, ENT_QUOTES) . '"/>';
     echo '<h3>Pris</h3>';
     echo '<input size="60" type="field" name="price" value="' . $obj->s_price . '"/>';
     echo '<h3>Text</h3>';
     echo '<textarea cols="60" name="text">' . Helper::text(htmlspecialchars($obj->s_text, ENT_QUOTES)) . '</textarea>';
     echo '<br/>';
     echo '<h3>Ordnigsnummer</h3>';
     echo '<input size="60" type="field" name="orderNo" value="' . $obj->s_orderNo . '"/>';
     echo '<input type="hidden" name="ID" value="' . $obj->s_rowID . '"/>';
     echo '<br/>';
     echo '<br/>';
     if ($_GET['parent'] != "") {
         echo '<input type="hidden" name="parent" value="' . $_GET['parent'] . '" />';
         echo '<input type="submit" name="action" value="Skapa" />';
     } else {
         echo '<input type="submit" name="action" value="Uppdatera" />';
     }
     echo '<br/>';
     break;
 case 3:

Exemple #8

Fichier : admin_recensioner_edit.php Projet : rocafuerte/opus

$query = "SELECT * FROM recensioner \n\t\tLEFT JOIN bilder\n\t\tON recensioner.image_id = bilder.id\n\t\tWHERE rowid='" . $_GET['id'] . "'\n\t\tORDER BY recensioner.date ASC";
$result = mysql_query($query) or die(mysql_error());
$id = mysql_result($result, 0, "rowid");
$title = mysql_result($result, 0, "title");
$description = Helper::text(mysql_result($result, 0, "description"));
$text = Helper::text(mysql_result($result, 0, "text"));
$dirigent = Helper::text(mysql_result($result, 0, "dirigent"));
$info = Helper::text(mysql_result($result, 0, "info"));
$solist = Helper::text(mysql_result($result, 0, "solist"));
$sacd = Helper::text(mysql_result($result, 0, "sacd"));
$betyg = Helper::text(mysql_result($result, 0, "betyg"));
$ljud = Helper::text(mysql_result($result, 0, "ljud"));
$writer = Helper::text(mysql_result($result, 0, "writer"));
$forlag = Helper::text(mysql_result($result, 0, "forlag"));
$title2 = Helper::text(mysql_result($result, 0, "title2"));
$cd = Helper::text(mysql_result($result, 0, "cd"));
$image_file = mysql_result($result, 0, "bilder.file");
$image_id = mysql_result($result, 0, "image_id");
$image_width = mysql_result($result, 0, "width");
$active = mysql_result($result, 0, "active");
$date = mysql_result($result, 0, "date");
?>

<h2>Recensioner</h2>
<form action="admin_recensioner_action.php" method="POST" name="recensioner" >
<div id="recensionerShow">   

    <span id="imageShow" limit="1" maxWidth="340" maxHeight="200">
	 <?php 
if ($image_id != "" && $image_id != 0) {
    ?>

Exemple #9

Fichier : Review.class.php Projet : rocafuerte/opus

 public function showReview()
 {
     if (Helper::hasValue($_GET['id'])) {
         $query = new Query($this->q->getTable());
         $query->whereLeftJoinImageQuery("*", "rowid", $_GET['id'], "date", "ASC");
         echo '<div class="reviewActual">';
         echo '<div class="title">';
         echo Helper::text($query->getResultRow("title"));
         echo '</div>';
         echo '<div class="title2">';
         echo Helper::text($query->getResultRow("title2"));
         echo '</div>';
         if (Helper::hasValue($query->getResultRow("image_id"))) {
             echo Image::displayImage($query->getResultRow("file"), 311, "", $query->getResultRow("name"));
         }
         echo '<div class="description">';
         echo '<br/>';
         echo Helper::text($query->getResultRow("text"));
         echo '</div>';
         echo '<div class="info">';
         echo '<span class="custom">';
         echo '<span class="infoTitle">';
         echo '</span>';
         echo Helper::text($query->getResultRow("info"));
         echo '<br />';
         if ($query->getResultRow("solist")) {
             echo '<span class="infoTitle">';
             echo 'SOLIST ';
             echo '</span>';
             echo Helper::text($query->getResultRow("solist"));
             echo '<br />';
         }
         if ($query->getResultRow("dirigent")) {
             echo '<span class="infoTitle">';
             echo 'DIRIGENT ';
             echo '</span>';
             echo Helper::text($query->getResultRow("dirigent"));
             echo '<br />';
         }
         if ($query->getResultRow("sacd")) {
             echo '<span class="infoTitle">';
             echo 'SACD ';
             echo '</span>';
             echo Helper::text($query->getResultRow("sacd"));
             echo '<br />';
         }
         if ($query->getResultRow("cd")) {
             echo '<span class="infoTitle">';
             echo 'CD ';
             echo '</span>';
             echo Helper::text($query->getResultRow("cd"));
             echo '<br />';
         }
         if ($query->getResultRow("writer")) {
             echo '<span class="infoTitle">';
             echo 'F&Ouml;RFATTARE ';
             echo '</span>';
             echo Helper::text($query->getResultRow("writer"));
             echo '<br />';
         }
         if ($query->getResultRow("forlag")) {
             echo '<span class="infoTitle">';
             echo 'F&Ouml;RLAG ';
             echo '</span>';
             echo Helper::text($query->getResultRow("forlag"));
             echo '<br />';
         }
         echo '<span class="infoTitle">';
         echo 'BETYG';
         echo '</span>';
         echo '&nbsp;';
         if ($query->getResultRow("betyg") == 6) {
             for ($i = 0; $i < $query->getResultRow("betyg"); $i++) {
                 echo '<img src="graphics/filled_star_lila.gif" width="10" height="10" />';
             }
         } else {
             for ($i = 0; $i < $query->getResultRow("betyg"); $i++) {
                 echo '<img src="graphics/filled_star.gif" width="10" height="10" />';
             }
         }
         echo '<br />';
         if ($query->getResultRow("ljud")) {
             echo '<span class="infoTitle">';
             echo 'LJUDKVALITET';
             echo '</span>';
             echo '&nbsp;';
             for ($i = 0; $i < $query->getResultRow("ljud"); $i++) {
                 echo '<img src="graphics/filled_star.gif" width="10" height="10" />';
             }
             echo '</span>';
         }
         echo '<div class="author">';
         echo $query->getResultRow("published_by");
         echo '</div>';
         echo '</div>';
         echo '</div>';
     }
 }

Exemple #10

Fichier : admin_events_edit.php Projet : rocafuerte/opus

  {
  
  	$rowID=$_GET['spelning'];
  	$query="SELECT * FROM spelningar
			LEFT JOIN bilder
			ON spelningar.image_id = bilder.id
			WHERE spelningar.rowid='$rowID'";
	$result=mysql_query($query);
	
	$image_file=mysql_result($result,0,"bilder.file");
	$image_id=mysql_result($result,0,"image_id");
	$date=mysql_result($result,0,"datum");
	$place=htmlspecialchars(mysql_result($result,0,"lokal"),ENT_QUOTES);
	$artist=htmlspecialchars(mysql_result($result,0,"artist"),ENT_QUOTES);
	$city=htmlspecialchars(mysql_result($result,0,"stad"),ENT_QUOTES);
	$description=Helper::text(htmlspecialchars(mysql_result($result,0,"description"),ENT_QUOTES));

	?>

	<form action="admin_events_action.php" name="spelningar" method="post">
    <div id="eventShow"> 
	
    <span id="imageShow" limit="1" maxWidth="200" >
	 <?php 
	
	 if($image_id!="" && $image_id!=0){ 
	
		?>
     	<span id="<?php echo $image_id ?>">
        
        <img src="../image_thumb.php?source=<?php echo $uploaded_images."/".$image_file ?>&width=200" />

Exemple #11

Fichier : admin_articles_edit.php Projet : rocafuerte/opus

<?php

include "admin_header.php";
$query = "SELECT * FROM articles \n\t\tLEFT JOIN bilder\n\t\tON articles.image_id = bilder.id\n\t\tWHERE rowid='" . $_GET['id'] . "'\n\t\tORDER BY articles.date ASC";
$result = mysql_query($query) or die(mysql_error());
$id = mysql_result($result, 0, "rowid");
$title = mysql_result($result, 0, "title");
$description = Helper::text(mysql_result($result, 0, "description"));
$text = Helper::text(mysql_result($result, 0, "text"));
$image_file = mysql_result($result, 0, "bilder.file");
$image_id = mysql_result($result, 0, "image_id");
$image_width = mysql_result($result, 0, "width");
$active = mysql_result($result, 0, "active");
$date = mysql_result($result, 0, "date");
?>

<h2>Artiklar</h2>


<form action="admin_articles_action.php" method="POST" name="articles" >

<div id="articlesShow">   
 
    <span id="imageShow" limit="1" maxWidth="340" >
	 <?php 
if ($image_id != "" && $image_id != 0) {
    ?>
     	<span id="<?php 
    echo $image_id;
    ?>
">