Bonjour,
Je souhaite limiter à 150 caractères le texte émanant d'un champ (post-excerpt) de ma base de données sql. J'ai essayé différentes "solutions" mais sans succès.
Quelqu'un peut-il m'aider ?
Merci.
Voici mon code.
Je souhaite limiter à 150 caractères le texte émanant d'un champ (post-excerpt) de ma base de données sql. J'ai essayé différentes "solutions" mais sans succès.
Quelqu'un peut-il m'aider ?
Merci.
Voici mon code.
Code:
<?php
/*
Connexion à  la BDD
*/
require "connect.php";
mysql_connect($adresse, $nom, $motdepasse);
mysql_select_db($database);
$sql = "SELECT COUNT(id) as nbArt FROM mary_posts";
$req = mysql_query($sql) or die(mysql_error());
$data = mysql_fetch_assoc($req);
$nbArt = $data['nbArt'];
$perPage = 6;
$nbPage = ceil($nbArt/$perPage);
$cPage = 1;
if(isset($_GET['p']) && $_GET['p']>0 && $_GET['p']<=$nbPage){
$cPage = $_GET['p'];
}
{
$sql = "SELECT * FROM mary_posts ORDER BY id DESC LIMIT ".(($cPage-1)*$perPage).",$perPage";
$req = mysql_query($sql) or die(mysql_error());
while($data = mysql_fetch_assoc($req)){
?>
<article class="post-27 post type-post status-publish format-gallery has-post-thumbnail hentry category-fashion tag-creative tag-nature tag-portrait grid-4" itemscope itemtype="http://schema.org/Article">
<figure class="entry-image">
<a href="#/<?php echo $data['ID'];?>-<?php echo $data['post_hypermalien'];?>.html">
<img width="330" height="221" src="<?php echo $data['post_thumbnail'];?>" class="attachment-masonry-size wp-post-image" alt="<?php echo $data['post_title'];?>" itemprop="image" /><i class="icomoon-camera-retro"></i> </a>
</figure>
<header class="entry-header">
<div class="entry-meta">
<span class="entry-category"><a href="#" title="#" ><?php echo $data['post_category'];?></a></span><time class="entry-date updated" datetime="#" itemprop="datePublished">Le <?php echo date("d/m/Y", strtotime($data['post_date'])); ?></time> </div>
<h2 class="entry-title" itemprop="headline">
<a href="#/<?php echo $data['ID'];?>-<?php echo $data['post_hypermalien'];?>.html"><?php echo $data['post_title'];?></a>
</h2>
</header>
<div class="entry-summary" itemprop="text">
<p> <?php echo $data['post_excerpt'];?></p>
<a class="read-more-link" href="#/<?php echo $data['ID'];?>-<?php echo $data['post_hypermalien'];?>.html">Lire plus</a>
</div>
</article> <?php
}
}
?>
