Learn VBA & Macros in 1 Week!

PHP - Condition For If To Create Div's With 2 Different Class In Css.

Full Excel VBA Course - Beginner to Expert

Condition For If To Create Div's With 2 Different Class In Css.	View Content

Hello all i have this code

<?php
$sql = "SELECT DISTINCT phonemodel FROM iphone ORDER BY phonemodel DESC LIMIT 4";
$rows = $conn->sqlExec($sql);

$nr_row = $conn->num_rows;
if($nr_row>=0) {
  $div_cls = (($nr_row % 2) == 0) ? 'linksmen' : 'linksmen_s';
  foreach($rows as $row) {
    echo '<div class="'.$div_cls.'" title="'.$row['phonemodel'].'"><a href="iphone.php?phonemodel='.$row['phonemodel'].'"><img src="images/mark.png" alt="" />&nbsp;'.$row['phonemodel'].'</a></div>';
	 }
}
  ?>

And looks like,the code take only firs class (linksmen) ,the condition else not working.did someone what is wrong. Thx

Full Excel VBA Course - Beginner to Expert

Why Should Using $_post[] In A Class Create An Error ?

Similar Tutorials

View Content

I'm new to OOP and straight out the gate Dreamweaver keeps giving me an error which I do not understand. I get that $_POST creates an array, however, in the procedural world I have always been able to assign a $variable to a $_POST. In fact if I remove the Class declaration the error goes away. What am am I missing ? - Many Thanks VJ :

Code: [Select]
<?php

class LookUp {
$first_name = $_POST["f_name"];
$last_name = $_POST ["l_name"];
$company = $_POST["company"];

}

?>

Beginning Oo Php..create User Class Query

Similar Tutorials

View Content

Hi,

I've always used PHP code in my websites in a procedural manner as I come from a html/css background. Now that I want to do projects with more complexity I'm thinking I need to approach development in a more Object Oriented fashion.

My question is more a theoretical one. I'm creating a User class and I'm not sure on what is the best practise for putting my functions etc. and where to call them.

My project will have 2 different users (Admin & End User) so is it correct to say that the User class should encapsulate all the functions of both of these users ? By that I mean create/delete/modify user, login & change password/forgotten password functionality rather than having a seperate Login class

Should I only call the database functions within these methods of the user class as opposed to calling them on the php page where the form data is posted ?

For example, if a user logins in and when the form data is posted I currently open a connection, validate data, run the query.
In an OO approach would I have just one User class method thats relevant to a particular page functionality ?
Say, in pseudo code, for handling a login request

loginRequest.php
Code: [Select]
include User class

try {
create new user User();
User::login();
}
catch Exception()

and should my User class look something like this

class.User.php
Code: [Select]
include DBase class

class User {
var name,
var email,
var password,

function validateInput (email, password) {
if (!valid input)
throw Exception
else
return true
}

function login (email, password){
try {
database connection
validateInput();
sql to see if user exists and login

}
catch Exception
}

}

Apologies for this being a bit long winded!

thanks

tmfl

Trying To Create A Tabs Class, But It Wont Work. Anyone Knows Why?

Similar Tutorials

View Content

Well I have a user profile page with codes written like this:

Code: [Select]
<?php
$filename = "profile";
include("functions/functions.php");
include("functions/functions_users.php");
include("functions/functions_adopts.php");
include("functions/functions_friends.php");
include("inc/lang.php");
include("inc/bbcode.php");

//***************//
//  START SCRIPT //
//***************//

// This page handles user profiles and shows the site members...

$user = $_GET["user"];
$page = $_GET["page"];

if($user != ""){

  // We have specified a specific user who we are showing a profile for...
  // See if the user exists...
  $article_title = "{$user}'s Profile";
  $query = "SELECT * FROM {$prefix}users, {$prefix}users_contacts, {$prefix}users_options, {$prefix}users_profile, {$prefix}users_status
                                           WHERE {$prefix}users.username = '{$user}'
   AND {$prefix}users_contacts.uid = {$prefix}users.uid
   AND {$prefix}users_options.uid = {$prefix}users.uid
   AND {$prefix}users_profile.uid = {$prefix}users.uid
   AND {$prefix}users_status.uid = {$prefix}users.uid
   AND {$prefix}users_contacts.username = {$prefix}users.username
   AND {$prefix}users_options.username = {$prefix}users.username
   AND {$prefix}users_profile.username = {$prefix}users.username
   AND {$prefix}users_status.username = {$prefix}users.username";
  $result = runquery($query);
  $row = mysql_fetch_array($result);

  if($row['username'] == $user){
    // First let's initiate tab system!
    include("inc/tabs.php");
    include("css/tabs.css");
    $article_content = "<div id='page-wrap'><div id='profile'>
            <ul class='nav'>
            <li class='nav0'><a href='#visitormessage'>Visitor Message</a></li>
            <li class='nav1'><a href='#aboutme' class='current'>About Me</a></li>
            <li class='nav2'><a href='#adopts'>Adoptables</a></li>
            <li class='nav3'><a href='#friends'>Friends</a></li>
            <li class='nav4 last'><a href='#contactinfo' class='last'>Contact Info</a></li>
            </ul><div class='list-wrap'>";

    // Format user profile information...
$id = $row['uid'];
    $ccstat = cancp($row['usergroup']);
    $website = (empty($row['website']))?"No Website Information Given":"<a href='{$row['website']}' target='_blank'>{$row['website']}</a>";
    $facebook = (empty($row['facebook']))?"No Facebook Information Given":"<a href='{$row['facebook']}' target='_blank'>{$row['facebook']}</a>";
    $twitter = (empty($row['twitter']))?"No Twitter Information Given":"<a href='{$row['twitter']}' target='_blank'>{$row['twitter']}</a>";
$msn = (empty($row['msn']))?"No MSN Information Given":$row['msn'];
    $aim = (empty($row['aim']))?"No AIM Information Given":$row['aim'];
    $yahoo = (empty($row['yahoo']))?"No YIM Information Given":$row['yahoo'];
$skype = (empty($row['skype']))?"No YIM Information Given":$row['skype'];
    $row['username'] = ($ccstat == "yes")?"<img src='templates/icons/star.gif' /> {$row['username']}":$row['username'];
    $row['favpet'] = ($row['favpet'] == 0)?"None Selected":"<a href='http://www.{$domain}{$scriptpath}/levelup.php?id={$row['favpet']}' target='_blank'><img src='http://www.{$domain}{$scriptpath}/siggy.php?id={$row['favpet']}' border=0></a>";

    // Here we go with the first tab content: Visitor Message
    $article_content .= "<ul id='visitormessage' class='hide'><strong><u>{$user}'s Profile Comments:</u></strong><br /><br /><table>";
    $result = runquery("SELECT * FROM {$prefix}visitor_messages WHERE touser = '{$user}' ORDER BY vid DESC LIMIT 0, 10");
    while($vmessage = mysql_fetch_array($result)){
      $date = substr_replace($vmessage['datesent']," at ",10,1);
      $query2 = "SELECT * FROM {$prefix}users, {$prefix}users_profile
                                                WHERE {$prefix}users.username = '{$vmessage['fromuser']}'
                                                AND {$prefix}users_profile.uid = {$prefix}users.uid
        AND {$prefix}users_profile.username = {$prefix}users.username";
      $result2 = runquery($query2);
      $sender = mysql_fetch_array($result2);
      $article_content .= "<tr>
           <td><img src='{$sender['avatar']}' width='40' height='40'></br></td>
           <td><a href='profile.php?user={$sender['username']}'>{$vmessage['fromuser']}</a> ({$date}) <a href='vmessage.php?act=view&user1={$user}&user2={$vmessage['fromuser']}'> <img src='templates/icons/status.gif'> </a>
           </br>{$vmessage['vmtext']} </br></td>
           <td><a href='vmessage.php?act=edit&vid={$vmessage['vid']}'> <img src='templates/icons/cog.gif'> </a>
           <a href='vmessage.php?act=delete&vid={$vmessage['vid']}'> <img src='templates/icons/delete.gif'> </a></br></td></tr>";
      }
    if($isloggedin == "yes"){
      if(isbanned($loggedinname) == 1){
        $article_content .= "</table>It seems that you have been banned from this site and thus cannot send profile comment.";
      }
      else{
        $article_content .= "</table> To Post a profile comment, please write your message in the text area below:
        <form action='profile.php?user={$user}' method='post'>
        <textarea rows='10' cols='50' name='vmtext' wrap='physical' ></textarea><br>
        <input type='submit' name='Submit' value='Submit'></form>";
        $vmcontent = $_POST["vmtext"];
        // Now check if the two users are friends...
        if($vmcontent != ""){
          $datesent = date("Y-m-d H:i:s");
          // $date = "2010-23-03 21:02:35";
          $fromuser = $loggedinname;
          $touser = $user;
          runquery("INSERT INTO {$prefix}visitor_messages (vid, fromuser, touser, datesent, vmtext)
  VALUES ('', '$fromuser', '$touser' , '$datesent', '$vmcontent')");
          $article_content .= "<p>Your comment for user has been posted. You may now view your conversation with {$user} from <a href='vmessage.php?act=view&user1={$fromuser}&user2={$touser}'>here</a>.</p>";
        }
      }
}
    else{
        $article_content .= "</table>Guests cannot post profile comment, sorry...";
    }

    // Now the second tab: About me...

    $article_content .= "</ul><ul id='aboutme'><li><strong><u>{$lang_basic_info} {$user}</u></strong><br /><br />
<img src='{$row['avatar']}' border=0 width='100' height=100 /><br />
<strong>Member Since:</strong> {$row['membersince']}<br /><br />
Gender: {$row['gender']}<br />
Favorite Color: {$row['color']}<br />
Nickname: {$row['nickname']}<br />
Bio: <br />
{$row['bio']}<br /></li>";


// The third tab: Adopts...
$article_content .= "</ul><ul id='adopts' class='hide'><h2>.:AdoptSpotlight:.</h2><br />
{$row['favpet']}<br />{$row['about']}<br /><br />
<strong><u>{$user}'s Pets:</u></strong><br /><br />";

$query = "SELECT COUNT(*) AS pets FROM {$prefix}owned_adoptables WHERE owner = '{$user}'";
$result = runquery($query);
$total = mysql_fetch_array($result);

if($total['pets'] > 0){
$rowsperpage = 15;
$totalpages = ceil($total['pets'] / $rowsperpage);
if(is_numeric($page)) $currentpage = $page;
else $currentpage = 1;

if($currentpage > $totalpages) $currentpage = $totalpages;
if($currentpage < 1) $currentpage = 1;
$offset = ($currentpage - 1) * $rowsperpage;
        $query = "SELECT * FROM {$prefix}owned_adoptables WHERE owner = '{$user}' LIMIT {$offset}, {$rowsperpage}";
$result = runquery($query);
        while($row = mysql_fetch_array($result)){
$image = getcurrentimage($row['aid']);
$article_content .= "<a href='levelup.php?id={$row['aid']}'><img src='{$image}' border='0' /></a>";

}
$article_content .= "<br />";

if($currentpage > 1){
$newpage = $currentpage - 1;
$article_content .= "<strong><a href='profile.php?user={$user}&page={$newpage}'><img src='templates/icons/prev.gif' border=0> Previous Page</a></strong> ";
}
else $article_content .= "<strong><img src='templates/icons/prev.gif' border=0> Previous Page</strong> ";

if($currentpage < $totalpages){
$newpage = $currentpage + 1;
$article_content .= " ::  <strong><a href='profile.php?user={$user}&page={$newpage}'>Next Page <img src='templates/icons/next.gif' border=0></a></strong> ";
}
else $article_content .= " ::  <strong>Next Page <img src='templates/icons/next.gif' border=0></strong>";
}
else{
$article_content .= "This user currently does not have any pets.";
}

    // The fourth tab: Friends...

$friendlist = getfriendid($user);
    $friendnum = getfriendnum($user);
    $article_content .= "</ul><ul id='friends' class='hide'>{$user} currently have {$friendnum} friends.<br /><table>";

if($friendnum != 0){
  foreach($friendlist as $friendid){
        $query = "SELECT * FROM {$prefix}users, {$prefix}users_profile
                                                WHERE {$prefix}users.uid = '{$friendid}'
                                                  AND {$prefix}users_profile.uid = {$prefix}users.uid
          AND {$prefix}users_profile.username = {$prefix}users.username";
        $result = runquery($query) ;
        $friendinfo = mysql_fetch_array($result);
        $uid = $friendinfo['uid'];
        $username = $friendinfo['username'];
        $friendgender = getfriendgender($username);
        $onlinestatus = getonlinestatus($username);
        $article_content .= "<tr><td style='text-align: left'><img src='{$friendinfo['avatar']}' border=0 width='60' height =60></td>
        <td><strong><a href='profile.php?user={$username}'>{$username}</a></strong>  {$friendgender}<br />{$friendinfo['nickname']}<br />{$onlinestatus}
        <a href='{$friendinfo['website']}' target='_blank'><img src='templates/icons/web.gif'></a>
        <a href='messages.php?act=newpm&user={$username}'><img src='templates/icons/title.gif'></a></td>";
        $article_content .= ($user == $loggedinname)?"<td style='text-align: right'><br /><br /><br /><a href='friends.php?act=delete&uid={$uid}'>Break Friendship </td></tr>":"</tr>";
      }
}

$article_content .= "</table>";

// The last tab: Contact Info!

    $article_content .= "</ul><ul id='contactinfo' class='hide'><img src='templates/icons/web.gif' /> {$website}<br />
                    <img src='templates/icons/facebook.gif' /> {$facebook}<br />
<img src='templates/icons/twitter.gif' /> {$twitter}<br />
                     <img src='templates/icons/aim.gif' /> {$aim}<br />
<img src='templates/icons/msn.gif' /> {$msn}<br />
<img src='templates/icons/yahoo.gif' /> {$yahoo}<br />
<img src='templates/icons/skype.gif' /> {$skype}<br />
<img src='templates/icons/title.gif' /> <a href='messages.php?act=newpm&user={$user}'>Send {$user} a Private Message</a><br />
<img src='templates/icons/fr.gif' /><a href='friends.php?act=request&uid={$id}'>Send {$user} a Friend Request</a><br />
<br /></div></div>";
  }

   else{
     $article_content .= "Sorry, but we could not find a user in the system with the name {$user}.
Please make sure you have the username right.  The user's account may also have been deleted by the system admin.";
  }

}
else{

// We did not specify a user, so show the memberlist
$article_title = "Memberlist";
$article_content = "Here are all of the members of this site, sorted by registration date.<br /><br />";
    include("classes/class_pagination.php");
    include("css/pagination.css");
$query = "SELECT * FROM {$prefix}users ORDER BY uid ASC";
$result = runquery($query);
$rowsperpage = 15;
    $pagination = new Pagination($query, $rowsperpage, "http://www.{$domain}{$scriptpath}/profile.php");
    $pagination->setPage($_GET[page]);

$query = "SELECT * FROM {$prefix}users ORDER BY uid ASC LIMIT {$pagination->getLimit()},{$rowsperpage}";
$result = runquery($query);

while ($row = mysql_fetch_array($result)){
$status = cancp($row['usergroup']);
        $star = ($status == "yes")?"<img src='templates/icons/star.gif' border=0' /> ":"";
$article_content .= "<strong><a href='profile.php?user={$row['username']}'>{$star}{$row['username']}</a></strong><br />";

}

$article_content .= "<br />{$pagination->showPage()}";

}

//***************//
//  OUTPUT PAGE  //
//***************//

echo showpage($article_title, $article_content, $date);

?>

In order to improve re-usability of the tabs, I attempted to create a file called class_tabs.php to make it object oriented. It did not work however, as the css is seriously messed up, and I have absolutely no idea why it did not.

Here is the class file:
Code: [Select]
<?php

class Tab{
  private $t_num;
  private $t_name = array();
  private $t_alias = array();
  private $t_content;
  private $t_default;
  private $t_hide;
  private $t_index = array();
  private $t_last = array();

  public function __construct($num, $tabs, $default=1){
$this->t_num = $num;
$this->t_default = $default;
$i = 0;
    foreach ($tabs as $key => $val){
  $this->t_name[$i] = $key;
      $this->t_alias[$i] = $val;
  $this->t_index[$i] = ($i == $default-1)?" class='current":"";
  $this->t_index[$i] = ($i == $num-1)?" class='last":$this->t_index[$i];
     $this->t_last[$i] = ($i == $num-1)?" last":"";
  $i++;
    }
  }

  public function createtab(){
    if($this->t_num < 2 or $this->t_num > 5) throw new Exception("The number of tabs must be restricted between 2 to 5!",272);
    $this->t_content = "<div id='page-wrap'><div id='tab'><ul class='nav'>";
    for($i=0; $i<$this->t_num; $i++){
      $this->t_content .= " <li class='nav{$i}{$this->t_last[$i]}'><a href='#{$this->t_alias[$i]}{$this->t_index[$i]}'>{$this->t_name[$i]}</a></li>";
    }
    $this->t_content .= "</ul><div class='list-wrap'>";
    return $this->t_content;
  }

  public function starttab($index){
    $this->t_hide = ($index == $this->t_default)?"":" class='hide'";
    $this->t_content .= "<ul id='{$this->t_alias}'{$this->t_hide}>";
return $this->t_content;
  }

  public function endtab($index){
    $this->t_content .= "</ul>";
if($index == $this->t_num) $this->t_content .= "</div></div>";
return $this->t_content;
  }
}
?>

And this is the modified profile codes with OOP:
Code: [Select]
<?php
$filename = "profile";
include("functions/functions.php");
include("functions/functions_users.php");
include("functions/functions_adopts.php");
include("functions/functions_friends.php");
include("inc/lang.php");
include("inc/bbcode.php");

//***************//
//  START SCRIPT //
//***************//

// This page handles user profiles and shows the site members...

$user = $_GET["user"];
$page = $_GET["page"];

if($user != ""){

  // We have specified a specific user who we are showing a profile for...
  // See if the user exists...
  $article_title = "{$user}'s Profile";
  $query = "SELECT * FROM {$prefix}users, {$prefix}users_contacts, {$prefix}users_options, {$prefix}users_profile, {$prefix}users_status
                                           WHERE {$prefix}users.username = '{$user}'
   AND {$prefix}users_contacts.uid = {$prefix}users.uid
   AND {$prefix}users_options.uid = {$prefix}users.uid
   AND {$prefix}users_profile.uid = {$prefix}users.uid
   AND {$prefix}users_status.uid = {$prefix}users.uid
   AND {$prefix}users_contacts.username = {$prefix}users.username
   AND {$prefix}users_options.username = {$prefix}users.username
   AND {$prefix}users_profile.username = {$prefix}users.username
   AND {$prefix}users_status.username = {$prefix}users.username";
  $result = runquery($query);
  $row = mysql_fetch_array($result);

  if($row['username'] == $user){
    // First let's initiate tab system!
    include("inc/tabs.php");
    include("css/tabs.css");
    include("classes/class_tabs.css");
    $profile_tabs = new Tabs(5, array("Visitor Message" => "visitormessage", "About Me" => "aboutme", "Adoptables" => "adopts", "Friends" => "friends", "Contact Info" => "contactinfo"),  2);
    $article_content = $profile_tabs -> createtab();

    // Format user profile information...
$id = $row['uid'];
    $ccstat = cancp($row['usergroup']);
    $website = (empty($row['website']))?"No Website Information Given":"<a href='{$row['website']}' target='_blank'>{$row['website']}</a>";
    $facebook = (empty($row['facebook']))?"No Facebook Information Given":"<a href='{$row['facebook']}' target='_blank'>{$row['facebook']}</a>";
    $twitter = (empty($row['twitter']))?"No Twitter Information Given":"<a href='{$row['twitter']}' target='_blank'>{$row['twitter']}</a>";
$msn = (empty($row['msn']))?"No MSN Information Given":$row['msn'];
    $aim = (empty($row['aim']))?"No AIM Information Given":$row['aim'];
    $yahoo = (empty($row['yahoo']))?"No YIM Information Given":$row['yahoo'];
$skype = (empty($row['skype']))?"No YIM Information Given":$row['skype'];
    $row['username'] = ($ccstat == "yes")?"<img src='templates/icons/star.gif' /> {$row['username']}":$row['username'];
    $row['favpet'] = ($row['favpet'] == 0)?"None Selected":"<a href='http://www.{$domain}{$scriptpath}/levelup.php?id={$row['favpet']}' target='_blank'><img src='http://www.{$domain}{$scriptpath}/siggy.php?id={$row['favpet']}' border=0></a>";

    // Here we go with the first tab content: Visitor Message
    $article_content .= "{$profile_tabs -> starttab(0)}<strong><u>{$user}'s Profile Comments:</u></strong><br /><br /><table>";
    $result = runquery("SELECT * FROM {$prefix}visitor_messages WHERE touser = '{$user}' ORDER BY vid DESC LIMIT 0, 10");
    while($vmessage = mysql_fetch_array($result)){
      $date = substr_replace($vmessage['datesent']," at ",10,1);
      $query2 = "SELECT * FROM {$prefix}users, {$prefix}users_profile
                                                WHERE {$prefix}users.username = '{$vmessage['fromuser']}'
                                                AND {$prefix}users_profile.uid = {$prefix}users.uid
        AND {$prefix}users_profile.username = {$prefix}users.username";
      $result2 = runquery($query2);
      $sender = mysql_fetch_array($result2);
      $article_content .= "<tr>
           <td><img src='{$sender['avatar']}' width='40' height='40'></br></td>
           <td><a href='profile.php?user={$sender['username']}'>{$vmessage['fromuser']}</a> ({$date}) <a href='vmessage.php?act=view&user1={$user}&user2={$vmessage['fromuser']}'> <img src='templates/icons/status.gif'> </a>
           </br>{$vmessage['vmtext']} </br></td>
           <td><a href='vmessage.php?act=edit&vid={$vmessage['vid']}'> <img src='templates/icons/cog.gif'> </a>
           <a href='vmessage.php?act=delete&vid={$vmessage['vid']}'> <img src='templates/icons/delete.gif'> </a></br></td></tr>";
      }
    if($isloggedin == "yes"){
      if(isbanned($loggedinname) == 1){
        $article_content .= "</table>It seems that you have been banned from this site and thus cannot send profile comment.";
      }
      else{
        $article_content .= "</table> To Post a profile comment, please write your message in the text area below:
        <form action='profile.php?user={$user}' method='post'>
        <textarea rows='10' cols='50' name='vmtext' wrap='physical' ></textarea><br>
        <input type='submit' name='Submit' value='Submit'></form>";
        $vmcontent = $_POST["vmtext"];
        // Now check if the two users are friends...
        if($vmcontent != ""){
          $datesent = date("Y-m-d H:i:s");
          // $date = "2010-23-03 21:02:35";
          $fromuser = $loggedinname;
          $touser = $user;
          runquery("INSERT INTO {$prefix}visitor_messages (vid, fromuser, touser, datesent, vmtext)
  VALUES ('', '$fromuser', '$touser' , '$datesent', '$vmcontent')");
          $article_content .= "<p>Your comment for user has been posted. You may now view your conversation with {$user} from <a href='vmessage.php?act=view&user1={$fromuser}&user2={$touser}'>here</a>.</p>";
        }
      }
}
    else{
        $article_content .= "</table>Guests cannot post profile comment, sorry...";
    }

    // Now the second tab: About me...

    $article_content .= "{$profile_tabs -> endtab(0)}{$profile_tabs -> starttab(1)}
                                    <li><strong><u>{$lang_basic_info} {$user}</u></strong><br /><br />
<img src='{$row['avatar']}' border=0 width='100' height=100 /><br />
<strong>Member Since:</strong> {$row['membersince']}<br /><br />
Gender: {$row['gender']}<br />
Favorite Color: {$row['color']}<br />
Nickname: {$row['nickname']}<br />
Bio: <br />
{$row['bio']}<br /></li>";


// The third tab: Adopts...
$article_content .= {$profile_tabs -> endtab(1)}{$profile_tabs -> starttab(2)}<h2>.:AdoptSpotlight:.</h2><br />
{$row['favpet']}<br />{$row['about']}<br /><br />
<strong><u>{$user}'s Pets:</u></strong><br /><br />";

$query = "SELECT COUNT(*) AS pets FROM {$prefix}owned_adoptables WHERE owner = '{$user}'";
$result = runquery($query);
$total = mysql_fetch_array($result);

if($total['pets'] > 0){
$rowsperpage = 15;
$totalpages = ceil($total['pets'] / $rowsperpage);
if(is_numeric($page)) $currentpage = $page;
else $currentpage = 1;

if($currentpage > $totalpages) $currentpage = $totalpages;
if($currentpage < 1) $currentpage = 1;
$offset = ($currentpage - 1) * $rowsperpage;
        $query = "SELECT * FROM {$prefix}owned_adoptables WHERE owner = '{$user}' LIMIT {$offset}, {$rowsperpage}";
$result = runquery($query);
        while($row = mysql_fetch_array($result)){
$image = getcurrentimage($row['aid']);
$article_content .= "<a href='levelup.php?id={$row['aid']}'><img src='{$image}' border='0' /></a>";

}
$article_content .= "<br />";

if($currentpage > 1){
$newpage = $currentpage - 1;
$article_content .= "<strong><a href='profile.php?user={$user}&page={$newpage}'><img src='templates/icons/prev.gif' border=0> Previous Page</a></strong> ";
}
else $article_content .= "<strong><img src='templates/icons/prev.gif' border=0> Previous Page</strong> ";

if($currentpage < $totalpages){
$newpage = $currentpage + 1;
$article_content .= " ::  <strong><a href='profile.php?user={$user}&page={$newpage}'>Next Page <img src='templates/icons/next.gif' border=0></a></strong> ";
}
else $article_content .= " ::  <strong>Next Page <img src='templates/icons/next.gif' border=0></strong>";
}
else{
$article_content .= "This user currently does not have any pets.";
}

    // The fourth tab: Friends...

$friendlist = getfriendid($user);
    $friendnum = getfriendnum($user);
    $article_content .= "{$profile_tabs -> endtab(2)}{$profile_tabs -> starttab(3)}{$user} currently have {$friendnum} friends.<br /><table>";

if($friendnum != 0){
  foreach($friendlist as $friendid){
        $query = "SELECT * FROM {$prefix}users, {$prefix}users_profile
                                                WHERE {$prefix}users.uid = '{$friendid}'
                                                  AND {$prefix}users_profile.uid = {$prefix}users.uid
          AND {$prefix}users_profile.username = {$prefix}users.username";
        $result = runquery($query) ;
        $friendinfo = mysql_fetch_array($result);
        $uid = $friendinfo['uid'];
        $username = $friendinfo['username'];
        $friendgender = getfriendgender($username);
        $onlinestatus = getonlinestatus($username);
        $article_content .= "<tr><td style='text-align: left'><img src='{$friendinfo['avatar']}' border=0 width='60' height =60></td>
        <td><strong><a href='profile.php?user={$username}'>{$username}</a></strong>  {$friendgender}<br />{$friendinfo['nickname']}<br />{$onlinestatus}
        <a href='{$friendinfo['website']}' target='_blank'><img src='templates/icons/web.gif'></a>
        <a href='messages.php?act=newpm&user={$username}'><img src='templates/icons/title.gif'></a></td>";
        $article_content .= ($user == $loggedinname)?"<td style='text-align: right'><br /><br /><br /><a href='friends.php?act=delete&uid={$uid}'>Break Friendship </td></tr>":"</tr>";
      }
}

$article_content .= "</table>";

// The last tab: Contact Info!

    $article_content .= "{$profile_tabs -> endtab(3)}{$profile_tabs -> starttab(4)}<img src='templates/icons/web.gif' /> {$website}<br />
                    <img src='templates/icons/facebook.gif' /> {$facebook}<br />
<img src='templates/icons/twitter.gif' /> {$twitter}<br />
                     <img src='templates/icons/aim.gif' /> {$aim}<br />
<img src='templates/icons/msn.gif' /> {$msn}<br />
<img src='templates/icons/yahoo.gif' /> {$yahoo}<br />
<img src='templates/icons/skype.gif' /> {$skype}<br />
<img src='templates/icons/title.gif' /> <a href='messages.php?act=newpm&user={$user}'>Send {$user} a Private Message</a><br />
<img src='templates/icons/fr.gif' /><a href='friends.php?act=request&uid={$id}'>Send {$user} a Friend Request</a><br />
<br />{$profile_tabs -> endtab(4)}";
  }

   else{
     $article_content .= "Sorry, but we could not find a user in the system with the name {$user}.
Please make sure you have the username right.  The user's account may also have been deleted by the system admin.";
  }

}
else{

// We did not specify a user, so show the memberlist
$article_title = "Memberlist";
$article_content = "Here are all of the members of this site, sorted by registration date.<br /><br />";
    include("classes/class_pagination.php");
    include("css/pagination.css");
$query = "SELECT * FROM {$prefix}users ORDER BY uid ASC";
$result = runquery($query);
$rowsperpage = 15;
    $pagination = new Pagination($query, $rowsperpage, "http://www.{$domain}{$scriptpath}/profile.php");
    $pagination->setPage($_GET[page]);

$query = "SELECT * FROM {$prefix}users ORDER BY uid ASC LIMIT {$pagination->getLimit()},{$rowsperpage}";
$result = runquery($query);

while ($row = mysql_fetch_array($result)){
$status = cancp($row['usergroup']);
        $star = ($status == "yes")?"<img src='templates/icons/star.gif' border=0' /> ":"";
$article_content .= "<strong><a href='profile.php?user={$row['username']}'>{$star}{$row['username']}</a></strong><br />";

}

$article_content .= "<br />{$pagination->showPage()}";

}

//***************//
//  OUTPUT PAGE  //
//***************//

echo showpage($article_title, $article_content, $date);

?>

Incase you find it necessary, the css/tabs.css and inc/tabs.php files are provided below. They should be irrelevant to this problem though, but just incase..
css/tabs.css
Code: [Select]

<style type="text/css">

*
body { font: 12px Georgia, serif; }
html { overflow-y: scroll; }
a { text-decoration: none; }
a:focus { outline: 0; }
p { font-size: 15px; margin: 0 0 20px 0; }
#page-wrap { width: 640px; margin: 30px;}
h1 { font: bold 40px Sans-Serif; margin: 0 0 20px 0; }

/* Generic Utility */
.hide { position: absolute; top: -9999px; left: -9999px; }

/* Specific to example one */

#profile { background: #eee; padding: 10px; margin: 0 0 20px 0; -moz-box-shadow: 0 0 5px #666; -webkit-box-shadow: 0 0 5px #666; }

#profile .nav { overflow: hidden; margin: 0 0 10px 0; }
#profile .nav li { width: 97px; float: left; margin: 0 10px 0 0; }
#profile .nav li.last { margin-right: 0; }
#profile .nav li a { display: block; padding: 5px; background: #959290; color: white; font-size: 10px; text-align: center; border: 0; }
#profile .nav li a:hover { background-color: #111; }

#profile ul { list-style: none; }
#profile ul li a { display: block; border-bottom: 1px solid #666; padding: 4px; color: #666; }
#profile ul li a:hover { background: #fe4902; color: white; }
#profile ul li:last-child a { border: none; }

#profile ul li.nav0 a.current, #profile ul.visitormessage li a:hover { background-color: #0575f4; color: white; }
#profile ul li.nav1 a.current, #profile ul.aboutme li a:hover { background-color: #d30000; color: white; }
#profile ul li.nav2 a.current, #profile ul.adopts li a:hover { background-color: #8d01b0; color: white; }
#profile ul li.nav3 a.current, #profile ul.friends li a:hover { background-color: #FE4902; color: white; }
#profile ul li.nav4 a.current, #profile ul.contactinfo li a:hover { background-color: #Eac117; color: white; }

</style>

Code: [Select]
<?php

if($filename == "profile"){

?>

<script src='http://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js'></script>
<script src="js/tabs.js"></script>
<script>
$(function() {

$("#profile").organicTabs();

});
</script>

<?
}

?>

Please help...

Similar Tutorials

View Content

Hi all. In my database, i have a table where a client chose a service providers to make payments and each bill setup counts as a reward point for the client. Each bill counts as a single point even if the bill is edited after a services might have expired or renewed it should not be counted again as point. to count the number of bill set up by a client i did

$stmt = $pdo->prepare("UPDATE reward_points SET num_bill = num_bill + 1 WHERE username = '$username' AND acct_num = '$acct_num'");
$stmt->execute();

Its okay if it counts for new bills but i want it not to count for the same service provide and so i did

$stmt=$pdo->query("SELECT company FROM payment WHERE username = '$username' AND trans_ref = '$trans_ref'");
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$coy = $row['company'];
}
//ps: note, $company is a variable from the form
if(strcmp($coy, $company) == 0){

$stmt = $pdo->prepare("UPDATE reward_points SET num_bill = num_bill + 0 WHERE username = '$username' AND acct_num = '$acct_num'");
$stmt->execute();
}elseif(strcmp($coy, $company) != 0){
    
$stmt = $pdo->prepare("UPDATE reward_points SET num_bill = num_bill + 1 WHERE username = '$username' AND acct_num = '$acct_num'");
$stmt->execute();    
}

it just wont add up i also tried

$coy1 = $coy;
$coy2 = $company;
$point = 0;

if(strcmp($coy1, $coy2) == 0){
   
    $add_point = $point + 0;
}else{
   
    $add_point = $point + 1;
}

$stmt = $pdo->prepare("UPDATE reward_points SET num_bill = $add_point WHERE username = '$username' AND acct_num = '$acct_num'");
$stmt->execute();

still wont work. any idea?

Checking Condition In Sql Query

Similar Tutorials

View Content

Hi there,

I am working on a PHP website. And I am running a query which checks for the expired products.

We check to see if the expiry date is greater than the current systems date then display the record. It looks something like this:

Code: [Select]
select * from products WHERE products.productExpiry) >= '2010-10-13 00:00:00'
'productExpiry' field is of 'Datetime' Datatype

And Expiry date is stored in database as:

2010-10-19 04:39:35

Now it works fine. But the problem only arises (no record shows) when there is no date in the 'productExpiry' field.

How can I check or set a condition in my SQL query that whenever the 'productExpiry' is Null or Blank don't compare it with the current date.

Please reply

All comments and feedbacks are welcomed

Thank you!

Sort And Paging With Where Condition

Similar Tutorials

View Content

Hello everybody, i have page called cat.php $cat_name get the data submited from othe .php page see line 77 this page show records WHERE category='$cat_name' see line 78 i have 2 problems: first problem: if i dont have this "where" condition, the sort function works fine see line 74 second problem: if i dont have this "where" condition, the paging function works fine see line from 108 here is my code thank you very much for your help Rafal

<html>
<head>
<title></title>
</head>
<body>
<?php>
include("config.php");
?>
<?php
$verbindung1 = mysql_connect("$hoster", "$nameuser", "$password")
or die ("connection error");
mysql_select_db("$basedata")
or die ("database error");
$abfrage = "SELECT cat_id, cat_name FROM $table3 ORDER BY cat_name ASC";
$ergebnis = mysql_query($abfrage);
$num = mysql_num_rows($ergebnis);
?>
<table>
<tr>
<?php
while ($row = mysql_fetch_object($ergebnis))
{
?>
<td>
<font face="Arial" size="2">
<form action="cat.php" method="post" name="cat_form" id="cat_form">
<input type="hidden" name="inp_cat_name" value="<?php echo $row->cat_name; ?>">
<input type="submit" value="<?php echo $row->cat_name; ?>">
</form>
</font>
</td>
<?php
}
?>
</tr></table>
<?php>
include("config.php");
?>
<?Php
try
{
$dbo = new PDO('mysql:host=db.abcdef.fr;dbname='.$basedata, $nameuser, $password);
}
catch (PDOException $e)
{
print "Error!: " . $e->getMessage() . "<br/>";
die();
}
$page_name="cat.php"; // page name
@$sort=$_GET['sort'];
if(strlen($sort)>0 and !ctype_alnum($sort))
{ 
echo "Data Error";
exit;
}
@$start=$_GET['start'];
if(strlen($start) > 0 and !is_numeric($start))
{
echo "Data Error";
exit;
}
$zero = ($start - 0); 
$limit = 20; // number of rows per page
$this1 = $zero + $limit; 
$back = $zero - $limit; 
$next = $zero + $limit;
$query2=" SELECT destination, stars, price FROM $table1 WHERE vis='yes'";
$count=$dbo->prepare($query2);

$count->execute();
$nume=$count->rowCount();
?>
<font face="Arial" size="2">Sortieren nach:<br>
<?php echo "<a href='$page_name?sort=destination'>Zielort</a>"; ?> | <?php echo "<a href='$page_name?sort=stars'>Sterne</a>"; ?> | <?php echo "<a href='$page_name?sort=price'>Preis</a>"; ?><br><br>
</font>
<?php
$cat_name = $_POST["inp_cat_name"];
$query=" SELECT * FROM $table1 WHERE category='$cat_name'";
if(isset($sort) and strlen($sort)>0){
$query = $query . " order by $sort";
}
$query = $query. " limit $zero, $limit ";
foreach ($dbo->query($query) as $row)
{
?>
<table cellspacing="0" cellpadding="0" border="1" width="600px" class="table">
<tr>
<td rowspan="2" valign="top" class="td">
<img src="<?php if ($row[photo1] != '') { ?><?php echo $row[photo1] ?><?php } ?><?php if ($row[photo1] == '') { ?><?php echo 'cloud/500x282.gif' ?><?php } ?>" width="200" height="113">
</td>
<th width="400px" class="th"><font face="Arial" size="2"><b><?php echo  $row[product] ?></b>
<?php if ($row[stars] == "1") { ?><?php echo "<img src='cloud/star.png'>"; } ?>
<?php echo  $row[destination] ?> (<?php echo  $row[category] ?>)</font></th>
</tr>
<tr>
<td valign="top" class="td" style="padding:7px;">
<font face="Arial" size="2">
<?php echo  $row[shortdesc] ?><br>
from <font size="4"><b><?php echo  $row[price] ?> &euro;</b></font> <font face="Arial" size="1">Nr. <?php echo  $row[inventar] ?></font><br>
<br>
</font>
</td></tr>
</table>
<br>
<?php
}
if($back >=0) { 
echo "<a href='$page_name?start=$back&sort=$sort'><font face='Verdana' size='2'>back</font></a>"; 
} 
echo "&nbsp;";
$i=0;
$l=1;
for($i=0;$i < $nume;$i=$i+$limit){
if($i <> $zero){
echo " <a href='$page_name?start=$i&sort=$sort'><font face='Verdana' size='2'>$l</font></a> ";
}
else { echo "<font face='arial' size='2' color='black'>$l</font>";}
$l=$l+1;
}
echo "&nbsp;";
if($this1 < $nume) { 
echo "<a href='$page_name?start=$next&sort=$sort'><font face='Verdana' size='2'>next</font></a>";} 
?>
</body>
</html>

If Condition Is Being Performed When False

Similar Tutorials

View Content

I'm having trouble with a script and I just can't figure out what's wrong with it. The script is located at http://www.qlhosting.com/ham/check.php

Here's the code for it
<?php
if (isset($_POST['submit'])) {
$domain = $_POST['domain'];
$password = md5($_POST['password']);
include 'db.php';
mysql_query("SELECT * FROM apps WHERE domain='$domain' AND WHERE cpassmd5='$password' LIMIT 1");
$stat = $row['status'];
}
else {
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Quotaless Web Hosting | Check Status</title>
<style type="text/css">
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
</style>
</head>

<body>
<h1>Check  Application/Account Status</h1>
<?php
if ($stat="PENDING") {
echo "<hr />";
echo "Your application is currently listed as PENDING. Our staff have not viewed your application yet. Please be patient, and watch your email for a response. Thank you!";
}
elseif ($stat="NMI") {
echo "<hr />";
echo "We need more information from you in order to take action on your application. Please check your e-mail inbox for a message from our staff specifically stating what we need. If you did not get this message, please post a message on our support forum. Thank you!";
}
else {
}
?>
<hr />
<h2>To check the status of your application or account, login using the form below.</h2>
<form id="check" name="check" method="post" action="<?php echo $PHP_SELF;?>">
<p>Domain:
  <input type="text" name="domain" id="domain" />
  <br />
Password:
  <input type="password" name="password" id="password" />
  <br />
  <input type="submit" name="button" id="button" value="Check" />
</p>
</form>
<hr />
<p> </p>
</body>
</html>
The part under if ($stat="PENDING") is performed upon page load, even when the if condition relating to it is false.

I can't seem to figure out what exactly is wrong here. Please help me out. I would really appreciate the help.

Thanks!

Anthony

How To Check Condition Again And Again Until It Satisfy ?

Similar Tutorials

View Content

Hello,
I am making a full backup of cPanel account.
It takes few seconds for zipping 4 to 10 MB of data but when there are more than 200 MB of data on cpanel account, obviously it will take some more time, say for example 2 minutes.

On cpanel based servers, while zipping, it temporarily creates a ZIP file of 33KB
And this file's size stays at 33KB until the process get completed i.e. till it completes a backup file

So conditionCHK is >> If example.zip > 33KB

then, backup ZIP file is ready

else
sleep(15) and check conditionCHK again

Point is that, it should check condition again and again until it satisfy.
So in my case, it script will check again and again whether example.zip has become more than 33KB or not.
If it not, then sleep for 15 seconds and again check
Once condition will satisfy, it will show "Success"

Which loop can I use here ? I am totally confused in developing a logic.
Thanks.

If/else Based On $numrows With A Condition...is It Possible?

Similar Tutorials

View Content

Hi all,
I'm wondering if it's possible to use the $numrows boolean parameter where $numrows = 0 and meets a condition.

For instance, my code is set up to check for classes where $numrows>0 and then displays the classes. If $numrows < 1, it echoes a message saying there are no classes available and to call the training department. I would like to redirect one of the classes to another link by using a strpos function to search for the classname within the URL. As I understand it, I would have to embed it in the else part of the statement if it's at all possible.

Here's what I have so far.
if ($numrows > 0)
{
  echo "<p align=\"left\" class=\"style2 style4\">Click in the check box next to the date for which you would like to register: </p>";
  echo "<p align=\"left\" class=\"style2 style4\">" . $_GET['classname'] . "</p>";
  echo "<table width=100% style=\"color:#FFFFFF\">";
  echo "<th></th>";
  echo "<th>Date</th>";
  echo "<th>Time</th>";
  echo "<th>Location</th>";
  echo "<th>Instructor</th>";
  while ($results = mysql_fetch_array($rs)){
      echo "<tr>";
      echo "<td><input type=\"radio\" name=\"checkbox\" value=\"" . $results['date'] . "|" . $results['time'] . "|" . $results['location'] . "|" . $results['instructor'] . "|" .   $results['course'] . "\"" . "></td>";
      echo "<td class=\"style11\">" . $results['date'] . "</td>";
      echo "<td class=\"style11\">" . $results['time'] . "</td>";
      echo "<td class=\"style11\">" . $results['location'] . "</td>";
      echo "<td class=\"style11\">" . $results['instructor'] . "</td>";
      echo "</tr>";
  }
  echo "</table>";
}
elseif (strpos($_REQUEST['classname'], "BloodBorne Pathogens Video"));
{
echo "Bloodborne Pathogens is exclusively offered online. Please <a href=../training/online_courses/Bloodborne/BB.html>click here</a> to take the course.";
}
else
{
echo "Please call the training department as there are no classes scheduled at this time."
}

Please let me know if this is even possible or if I'm off my rocker. I'm fairly new to the PHP world but not a newb

Thanks a bunch for your time!

Loop Condition With If Statment

Similar Tutorials

View Content

I have a while loop that works fine but when I add an if condition within the loop it does not echo the if condition. I'm trying to echo an extra row in the table if the number of clubs returned is > 2

<?php

for($i = 0; ($ClubDetails1 =  mysql_fetch_assoc($ClubDetails)) && $i < 2; $i++){  ?>
  <tr>
    <th scope="col"></th>
    <th scope="col"><?php echo $ClubDetails1['name']; ?></th>
  <?php
    if ($i > 2) {
  echo "<th scope=\"col\"><a href=\"club_page.php\"> More </a> </th>";

}

?>
</tr>
<?php } ?>