Jump to content

canabatz

Members
 View Profile  See their activity

  • Posts

    116

  • Joined

  • Last visited

 Content Type 

Posts posted by canabatz

    change date after midnight

    in PHP Coding Help

    Posted · Edited by canabatz

    hi all

     

    i have an array that hold times as follow(i define the date):

    2016-02-24 16:55
    2016-02-24 17:55
    2016-02-24 19:55
    2016-02-24 23:55
    2016-02-24 01:34 -<----here is my problem , i want the date to change if it's after midnight.


    it shuold be like that automaticly:
    2016-02-25 01:34

     

    somthing like that:

    $day="2016-02-26";

if(strtotime(01:34) > strtotime("23:59"))
	{
	$day =  date('Y-m-d',strtotime($day."+1 days"));
	}
	else
	{
		//KEEP CURRENT DATE
	}

    the time im geting from a web site with file_get_contents and there the date do not change if after midnight so i got to do it my self :)

     

    any help ?

     

    thanks

    best results

    in MySQL Help

    Posted

    i changed it to:

     

     

    $results =  array(
                array('name'=>'carl',  'good'=>4, 'time'=>14),
                array('name'=>'john',  'good'=>4, 'time'=>25),
                array('name'=>'benny', 'good'=>5, 'time'=>21)
            );
usort($results, 'resultSort');
echo $results[0]['name'];    // benny

    best results

    in MySQL Help

    Posted

    hi all,

     

    im trying to get best results from this list

     

    name--------good---------best time

    carl------------1    ---------14

    john------------2    ---------25

    benny----------2    ---------21

     

     

    good represent right answer and bet time represent speed.

     

    i need to find who answer most and the least time.

     

    so the best from the example is 2-21

     

    i have put the results in array and found the max(good) and the min(best time) 

     

    how can i found that benny won in table example, he had 2 good and is best time is better then john, carl is out because he have only 1 good.

     

    thanks

     

    Problem In Foreach Loop With Unserialized Content

    in PHP Coding Help

    Posted

    Hi,

     

    i got problem in foreach loop, the code is stuck on first loop.

     

     

    any one see any problem in the code?

    im stuck on it for a day now.

     

    thanks ! 

    

function get_rss()
{
global $catArray, $yesterday, $date;

$rss = mysql_query("SELECT id, cat, tcat, title, pic FROM portal_coverages WHERE v = 1 AND date BETWEEN ('" . $yesterday . "') AND ('" . $date . "')ORDER BY id DESC");
$resultp = array();


while($row = mysql_fetch_object($rss))
{
$resultp[$row -> cat][$row -> tcat] = $resultp[$row -> cat][$row -> tcat] . "
<tr>
<td><p style='color:#F91010;'>" . $catArray[$row -> cat . "," . $row -> tcat] . "</p></td>
<td><img src='http://dossinet.me/" . $row -> pic . "' width='50' height='50' /></td>
<td>" . $row -> title . "</td>
<td><a href='http://dossinet.me/view," . $row -> id . ".html'>קישור </a></td>
</tr>
";
}

return $resultp;
}



include("rss/mail_class.php");


$kk=1;
$query = mysql_query("SELECT rss_id, user_id FROM `portal_rss`")or die(mysql_error());
$get_rss = get_rss();


while($row = mysql_fetch_object($query))
{
$rss_id = unserialize($row -> rss_id);


foreach($rss_id as $key)
{
$x = explode(',', $key);

if(!empty($get_rss[$x[0]][$x[1]]))
{
$title .= $catArray[$key] . ', ';
$result .= $get_rss[$x[0]][$x[1]];
}
}

if(!empty($result))
{
$query = mysql_query("SELECT * FROM `user` WHERE `userid` ='" . $row -> user_id . "'")or die(mysql_error());
$rowz = mysql_fetch_array($query);

$user['name'] = $rowz['username'];
$user['email'] = $rowz['email'];

$params = array(
'file' => 'rss',
'subject' => "עדכוני קטגוריה - " . $title,
'from_name' => "עדכוני קטגוריה ",
'vars' => array('cat' => $title, 'post' => $result, 'name' => $user['name']),
);

Mail::To($user['email']);
Mail::set_mail($params, true);
Mail::send_mail($params);
}
}

    rewrite url

    in Apache HTTP Server

    Posted

    hi,

     

    i got this url:

     

    www.world-status.com/&page=2

     

     

    how can i make it like that:

     

    www.world-status.com/page/2

     

    i got this at the moment:

     

    RewriteRule ^([^/.]+)/?$ /index.php?cat_id=$1

     

    RewriteCond %{HTTP_HOST} ^world-status.com

    RewriteRule (.*) [world-status.com...] [R=301,L]

     

    RewriteCond %{THE_REQUEST} \/index.php\ HTTP [NC]

    RewriteRule (.*)index.php$ /$1 [R=301,L]

     

    thanks

    Geting min id and max id in loop

    in PHP Coding Help

    Posted

    i need to get two  or more of id ranges :

     

    for example

     

    id  value

     

    1      1

    2      1

    3      0 -

    4      0 -

    5      0 -

    6      1

    7      1

    8      0 -

    9      0 -

    10    0 -

    11    1

    12    1

    13    1

     

     

     

    i want to get the starting id 0f the value 0 to the Third value 0 so the result will be 3-5 and i need to get the second one also

    8-9.

     

    what is the easiest way to do that? or where to start?

     

    thanks

    get the right number in loop

    in PHP Coding Help

    Posted

    Hi mjdamato , i dont know how to thank you for taking the time to write and test this code.

     

    your code is perffect! but i got small problem.

     

    im trying to get the results from the database while doing what i need .

     

    $sql=mysql_query("SELECT *   FROM `my_table` ")or die(mysql_error());
while ($row=mysql_fetch_assoc($sql))
{



$testArray=     

array(

array ('res' =>$row['something'], 'number' =>$row['something else']),


);

}

$lastRes = 1;




foreach($testArray as $row)
{
    if($row['res'] == 0 && $lastRes !== 0)
    {
        //This line is only executed if 'res'=0 and the last 'res' was not 0
        $res11 = $row['number'];
        echo "A New '0' was encountered. res11 now equals {$res11}<br>\n";
    }
    $lastRes = $row['res'];
}

     

    im not geting anny result back , if i put your test code it's working!!

     

    can it be a problem to add returned results from the database in the while loop!!

     

    thanks a Billion!

    get the right number in loop

    in PHP Coding Help

    Posted

    Hi all,

     

    i have this records that coming from the database:

     

    0

    0

    0

    1

    1

    1

    1

    1

    0

    0

    1

    1

    1

    1

    1

    1

     

     

    i want to build a loop that will do like that:

     

    if ($res==0) {$res11==number}

     

    if ($res was allready 0 ignore it)

     

    if ($res==1 ignore it and all other $res=1 and wait till it's $res=0 again

     

    if ($res==0 again) { $res11==newnumber }

     

    please guide me to doing that, im stuck!

     

    thanks

    Please help with echoing results

    in PHP Coding Help

    Posted

    try now

    <?php
/* Get the letter user clicked on and assign it a variable called $sort */
$sort = $_REQUEST['letter'];
/* Let's check if variable $sort is empty. If it is we will create a query to display all customers alphabetically ordered by last name. */
if($sort == ""){
$qry= "SELECT * FROM myDatabase.t_clientes ORDER BY company_name ASC " ;
}else{
/* if varible $sort is not empty we will create a query that sorts out the customers by their last name, and order the selected records ascendingly. */
$qry = "SELECT * FROM myDatabase.t_clientes WHERE company_name LIKE '$sort%' ORDER BY company_name ASC" ;
}
/* Notice the use of '%' wilde card in the above query "LIKE '$sort%'". */
//next step is to execute the query.
$execute = mysql_query($qry) or die(mysql_error());
?>
<td width="551" align="left" nowrap="nowrap" class="UsuarioNombreHeader">
<?php for ($i = 65; $i < 91; $i++) {
printf('<a href="%s?letter=%s">%s</a> | ',
$PHP_SELF, chr($i), chr($i));
}
echo "
" ; //print t alphabet */?>
</td>
<table width="850"  align="center" border="0" cellpadding="5" cellspacing="0" class="BottomLine">
         <?php if(mysql_num_rows($execute)>0){
do{?> <tr>
    <td>
          <td width="27%" align="left" nowrap="nowrap" class="AddressTXT"><strong><?php echo $result['company_name']; ?></strong></td>
          <td width="20%" align="left" nowrap="nowrap" class="AddressTXT"><strong>tel.<?php echo $result['cliente_tel']; ?></strong></td>
          <td width="27%" align="left" nowrap="nowrap" class="AddressTXT"><?php echo $result['cliente_email'];?></td>
          <td width="2%" align="center" class="CP_errorLoginTxt"><a href="PC_contactos_sendmail.php?id_cliente=<?php echo $result['id_cliente']; ?>"><img src="CP_img/icono_email_reducido.png" alt="" width="15" height="10" border="0" /></a></td>
          <td width="2%" align="center" class="CP_errorLoginTxt"><a href="PC_contactos_update.php?id_cliente=<?php echo $result['id_cliente']; ?> "onclick="return confirm('¿Seguro que desea \n ELIMINAR PERMANENTEMENTE \n <?php echo $result['company_name']; ?>?');"><img src="CP_img/icono_editar_reducido.png" width="20" height="13" border="0" /></a></td>
          <td width="2%" align="center" class="CP_errorLoginTxt"><a href="PC_contactos_delete.php?id_cliente=<?php echo $result['id_cliente']; ?> "onClick="return confirm('¿Seguro que desea \n ELIMINAR PERMANENTEMENTE \n <?php echo $result['company_name']; ?>?');"><img src="CP_img/icono_borrar_reducido.png" width="15" height="10" border="0" /></a></td>
        </tr>


<?php
}while($result = mysql_fetch_assoc($execute));
}else{
echo "
No contacts found
" ;
}
?> 
</table>

    Please help with echoing results

    in PHP Coding Help

    Posted

    try that:

     

    <?php

/* Get the letter user clicked on and assign it a variable called $sort */
$sort = $_REQUEST['letter'];
/* Let's check if variable $sort is empty. If it is we will create a query to display all customers alphabetically ordered by last name. */
if($sort == ""){
$qry= "SELECT * FROM myDatabase.t_clientes ORDER BY company_name ASC " ;
}else{
/* if varible $sort is not empty we will create a query that sorts out the customers by their last name, and order the selected records ascendingly. */
$qry = "SELECT * FROM myDatabase.t_clientes WHERE company_name LIKE '$sort%' ORDER BY company_name ASC" ;
}
/* Notice the use of '%' wilde card in the above query "LIKE '$sort%'". */
//next step is to execute the query.
$execute = mysql_query($qry) or die(mysql_error());
/* Before we display results let's create our alphabetical navigation. 
for ($i = 65; $i < 91; $i++) {
printf('<a href="%s?letter=%s">%s</a> | ',
$PHP_SELF, chr($i), chr($i));
}
echo "
" ;
/* now we are ready to display the results. */
?>
<table width="400" border="1">
  <tr>
    <td>client</td>
    <td>company name</td>
    <td>Phone</td>
  </tr>

<?php if(mysql_num_rows($execute)>0){
do{
?>

<tr>
    <td><?php echo $result['id_cliente']; ?></td>
    <td><?php echo $result['company_name']; ?></td>
    <td><?php echo $result['cliente_tel'];?></td>
  </tr>

<?php
}while($result = mysql_fetch_assoc($execute));
}else{
echo "
No customer found.
" ;
}
?>

</table>

    Please help with echoing results

    in PHP Coding Help

    Posted

    from your first code:

    <?php if(mysql_num_rows($execute)>0){
do{
echo "
" .$result['id_cliente']. " " .$result['company_name']. " " .$result['cliente_tel']. "
" ;
}while($result = mysql_fetch_assoc($execute));
}else{
echo "
No customer found.
" ;
}
?>

     

    does it display all records? or just one?

     

    how many records there is?

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.