?>
" class="btn btn-primary">Section Photo</a></div>
<h2>Liste des Vidéos :</h2>
<ul class="thumbnails sortable">
<?php
foreach ($videos as $video) {
?>
<li id="<?php
echo $video->id;
?>
" class="span4 video">
<div class="thumbnail" style="background-color: <?php
echo 'rgb(' . $video->r . ',' . $video->g . ',' . $video->b . ')';
?>
; color: <?php
echo text_color($video->r, $video->g, $video->b);
?>
">
<img src="<?php
echo site_url('uploads/thumbs/' . $video->thumbnail) . '?' . now();
?>
" alt="<?php
echo $video->title;
?>
">
<p>
<h3><?php
echo $video->title;
?>
</h3>
</p>
* Time: 10:18
* To change this template use File | Settings | File Templates.
*/
?>
<section id="page" class="container">
<h2>Liste des Photos :</h2>
<ul class="thumbnails">
<?php
foreach ($photos as $photo) {
?>
<li class="span4">
<div class="thumbnail" style="background-color: <?php
echo 'rgb(' . $photo->r . ',' . $photo->g . ',' . $photo->b . ')';
?>
; color: <?php
echo text_color($photo->r, $photo->g, $photo->b);
?>
">
<img src="<?php
echo site_url('uploads/thumbs/' . $photo->filename) . '?' . now();
?>
" alt="<?php
echo $photo->filename;
?>
">
<p>
<h3><?php
echo $photo->title;
?>
</h3>
<div class="btn-group text-center">
}
?>
</ol>
<div class="carousel-inner">
<?php
foreach ($headers as $header) {
?>
<div class="item <?php
echo $j == 0 ? 'active' : '';
?>
">
<div class="item-container" style="background-color: <?php
echo 'rgb(' . $header->r . ',' . $header->g . ',' . $header->b . ')';
?>
; color: <?php
echo text_color($header->r, $header->g, $header->b);
?>
">
<div class="picture">
<img src="<?php
echo site_url('uploads/header/' . $header->thumbnail) . '?' . now();
?>
" alt="<?php
echo $header->title;
?>
" width="100%"/>
<a href="<?php
echo site_url('videos/view/' . $header->id);
?>
" class="btn btn-primary watch-now show-small">Watch now</a>
define("pass", "Z7A8JqUh");
/**
* database name
*/
//define ("db", "mebli");
define("db", "uh333660_mebli");
function text_color($factory_id)
{
//echo "Y!";
$db_connect = mysqli_connect(host, user, pass, db);
$query = "SELECT goods_id, goods_content FROM goods WHERE factory_id={$factory_id}";
if ($res = mysqli_query($db_connect, $query)) {
while ($row = mysqli_fetch_assoc($res)) {
$arr[] = $row;
}
//print_r($arr);
foreach ($arr as $matr) {
$id = $matr['goods_id'];
$cont = $matr['goods_content'];
$new_cont = str_replace("rgb(51, 51, 51)", "rgb(0, 0, 0)", $cont);
$new_cont = str_replace("rgb(136, 136, 136)", "rgb(0, 0, 0)", $new_cont);
echo "NEW: {$new_cont}<br>";
$query = "UPDATE goods SET goods_content='{$new_cont}' WHERE goods_id={$id}";
mysqli_query($db_connect, $query);
echo "{$query}<br>";
}
}
mysqli_close($db_connect);
}
text_color(139);
