Jump to content

doddsey_65

Members
 View Profile  See their activity

  • Posts

    902

  • Joined

  • Last visited

  • Days Won

    9

 Content Type 

Posts posted by doddsey_65

    another $_GET question

    in PHP Coding Help

    Posted

    my index.php file includes different files depending on the get value. all of them work except this one:

     

    elseif (isset($_GET['forum']) && $_GET['child']) {

include 'modules/pages/children.php';

}

     

    when i point my browser to index.php?forum=1&child=1 it stays on the same page. Do i need to include something else when getting a url with 2 $_GETs?

    $_GET?

    in PHP Coding Help

    Posted

    I have some javascript for a tabbed interface in index.php. The content of each tab is in content.php which uses $_GET to define which tab is selected. But i want to include queries based on variables from index.php how would i do this?

     

    here is the code for the tabbed interface:

     

    <script language="JavaScript" type="text/javascript" src="<?php echo SITE_ROOT; ?>/js/ahahLib.js"></script> 
<script language="JavaScript" type="text/javascript"> 
function makeactive(tab) { 
document.getElementById("tab1").className = ""; 
document.getElementById("tab2").className = ""; 
document.getElementById("tab3").className = ""; 
document.getElementById("tab"+tab).className = "active"; 
callAHAH('includes/content.php?content= '+tab, 'content', 'Loading...', 'Error'); } 
</script> 

<ul id="tabmenu" > 
<li onclick="makeactive(1)">
<a class="" id="tab1">Account Information</a>
</li> 
<li onclick="makeactive(2)">
<a class="" id="tab2">Second Page</a>
</li> 
<li onclick="makeactive(3)">
<a class="" id="tab3">Third Page</a>
</li> 
</ul> 
<div id="content"></div>

     

    and the code in content.php

     

    if ($_GET['content'] == 1) { echo 'Content for Page 1'; } 

if ($_GET['content'] == 2) { echo 'Content for Page 2'; }

if ($_GET['content'] == 3) { echo 'Content For Page 3'; }

     

    ive tried adding the variable $user_id to the content.php url as follows:

     

    callAHAH('includes/content.php?user=$user_id&content= '+tab, 'content', 'Loading...', 'Error'); }

     

    but that just brought up an error.

    auto update preview

    in Javascript Help

    Posted

    hi, i am looking for some code which will automatically update a div. the div will be updated to what the user types in the textbox automatically. I did have this feature working but for some reason it stopped working. If anyone could point me in the right direction or tell me why my code isnt working anymore. Heres the code:

     

    <script src="<?php echo SITE_ROOT; ?>/js/jquery.min.js" type="text/javascript">
</script>
<script src="<?php echo SITE_ROOT; ?>/js/jquery.bbcode.js" type="text/javascript"></script>
<script type="text/javascript">
  $(document).ready(function(){
    $("#test").bbcode({});
    process();
  });
  
  var bbcode="";
  function process()
  {
        if (bbcode != $("#test").val())
        {
            bbcode = $("#test").val();
            $.get('bbParser.php',
            {
                bbcode: bbcode
            },
            function(txt){
                $("#preview").html(txt);
                })
            
        }
        setTimeout("process()", 2000);
  
  }
  


</script>

    image troubles

    in PHP Coding Help

    Posted

    up until yesterday everything was fine, but now all of my icons are displaying at 10 times the size they originally are. This can only be fixed by defining width and height of them via css but i never had to do this before. Is this something to do with php? heres an eample line of code for an image i am using:

     

    echo "<img src=\"{$site_root}/avatars/{$posts_info->user_avatar}\"/>";

     

    any ideas why this is happening?

    that image is just an example btw. the same thing happens with icons that are 7x7.

    Forum post limitations

    in PHP Coding Help

    Posted

    Hi, i am wanting to implement a post restriction on the forum im building where a new user can only post 10 posts per day and create 2 topics per day.

    I have thought about the process but have become stuck. I am fine for checking if they have reached their post count for the day(just a simple +1 to the table when they post then query it before posting)

    but how would i reset the counter after the day is up?

    i have also done the bit that defines how long ago they registered.

     

    So if a user registered less than 1 week ago they are only permitted 10 posts and 2 topics per day. After the day ends they can post 10 more posts and 2 more topics(numbers are examples only). Then when they pass 1 week registered they can do anything.

     

    I just dont know how to reset the counter at the end of the day. This is my example code so far:

     

    $timeslot = (strtotime("-1 week"));
$reg_date = (strtotime($posts_info->user_regdate));

if ($reg_date <= $timeslot)
	{ THEY CAN DO ANYTHING
} else {

if $todays_post_count == 10)
{ THEY CANT POST }
else {
THEY CAN POST
}

    query problems

    in PHP Coding Help

    Posted

    I have a query which pulls all the data i need and it works fine. But when there is more than one topic in a forum it displays the forum each time. Say there are 4 topics in a forum. The forum name is displayed 4 times. Heres the code:

     

    $query = $db->query("SELECT
              f.forum_id, f.forum_name, f.forum_description, f.forum_topics, f.forum_posts,
              f.forum_last_poster, f.forum_last_post_time, f.forum_last_post,
              p.parent_id, p.parent_name,
              m.user_id, m.user_username, m.user_group,
              t.topic_id, t.topic_name,
              po.post_id, po.post_subject
          FROM ".DB_PREFIX."forums as f
          JOIN ".DB_PREFIX."parents as p
              ON f.parent_id = p.parent_id
          LEFT JOIN ".DB_PREFIX."members as m
              ON f.forum_last_poster = m.user_id
          LEFT JOIN ".DB_PREFIX."topics as t
              ON f.forum_id = t.forum_id
          LEFT JOIN ".DB_PREFIX."posts as po
              ON po.post_id = f.forum_last_post
          ORDER BY p.parent_id")
          or trigger_error("SQL", E_USER_ERROR);

while ($forum_info = mysql_fetch_object($query))
{

     

    I am new to table joins but someone helped me set this up so it should work but it doesnt. Any ideas why?

    pagination

    in PHP Coding Help

    Posted

    i have some code which checks all of the posts in the database with the topic_id of $topic_id.

     

    what i want to do is like on many forums. On the topic list next to the name just show the pages like:

     

    1-2-3-4

     

    and when there are more than 4 or so

     

    1-2....8-9

     

    here is the code which gets the number of pages:

     

    $data = $db->query("SELECT * FROM
                    ".DB_PREFIX."posts
                    WHERE topic_id = '$topic_info->topic_id'");
$rows = mysql_num_rows($data); 
$page_rows = $posts_per_page; 

if ($rows > $page_rows) {

$rowsArray = array($rows);

}

     

    as you can see i have added it into an array but i dont know what to do from there. I guessed it would be something like a for statement but im not sure. Can anyone help?

    table joins

    in PHP Coding Help

    Posted

    Instead of defining $userClass before the switch, just change the assignments in the switch to "=" instead of ".="

     

    For the second error, I should have used implode() instead of print_r().

    $output .= implode("\n"; $parentData['records']);

     

    i get a parse error with that but i just changed the ; to a .

    But now i get the error:

    Warning: implode() [function.implode]: Argument must be an array in C:\wamp\www\myforum\modules\pages\forums.php on line 48

     

    Sorry if this is frustrating you lol. And thanks for all the help thus far

    table joins

    in PHP Coding Help

    Posted

    Thanks for the reply. I used your code and did get a few errors. Some were just typos though. There was one saying $userClass was undefined so i defined it as $userClass=''; before the switch.  But the site isnt displaying the data properly. it just displays the three headers with the words array then the number 1 above them. Heres the code with the few changes i made to fix the errors:

     

    function createTable($parentData)
{
    //Exit if this is the first record
    if($parentData['parent_id']===false) { return false; }
    
    $output  = "<table class=\"forum_table\" onclick=\"expandCollapseTable(this)\">\n";
    $output .= "<tr id=\"tr1\">\n";
    $output .= "<th class=\"forum_left_corner\"></th>\n";
    $output .= "<th class=\"forum_parent_name\">{$parentData['parent_name']}</th>\n";
    $output .= "<th class=\"empty\"></th>\n";
    $output .= "<th class=\"empty\"></th>\n";
    $output .= "<th class=\"forum_last_post_header\">".LAST_POST."</th>\n";
    $output .= "</tr>\n";
    $output .= print_r("\n". $parentData['records']);
    return $output;
}
    
//Create and run query to get all the data
$query = $db->query("SELECT
              f.forum_id, f.forum_name, f.forum_description, f.forum_topics, f.forum_posts,
              f.forum_last_poster, f.forum_last_post_time, f.forum_last_post,
              p.parent_id, p.parent_name,
              m.user_id, m.user_username, m.user_group,
              t.topic_id, t.topic_name,
              po.post_id, po.post_subject
          FROM ".DB_PREFIX."forums as f
          JOIN ".DB_PREFIX."parents as p
              ON f.parent_id = p.parent_id
          LEFT JOIN ".DB_PREFIX."members as m
              ON f.forum_last_poster = m.user_id
          LEFT JOIN ".DB_PREFIX."topics as t
              ON f.forum_id = t.forum_id
          LEFT JOIN ".DB_PREFIX."posts as po
              ON po.post_id = f.forum_last_post
          ORDER BY p.parent_id")
          or trigger_error("SQL", E_USER_ERROR);
    
//Loop through records to process data
$parentData = array('parent_id' => false);
while ($forum_info = mysql_fetch_object($query))
{
    //Detect if this record is in a new parent id from the last
    if($forum_info->parent_id!=$parentData['parent_id'])
    {
        //Create table output for last parent data
        echo createTable($parentData);
        //Set new parent ID/name
        $parentData['parent_id'] = $forum_info->parent_id;
        $parentData['parent_name'] = $forum_info->parent_name;
        //Reset the data array
        $parentData['records'] = array();
    }
    
    //Create url string    
    $forum_url_name = str_replace(' ', '_', $forum_info->forum_name);

    //Create HTML output for current record
    $recordHTML  = "  <tr class=\"gradient\">\n";
    $recordHTML .= "    <td class=\"forum_icon\">\n";
    $recordHTML .= "    <div class=\"thread_icon\">{$forum_info->forum_id}</div>\n";
    $recordHTML .= "    </td>\n";
    $recordHTML .= "    <td class=\"forum_name\">\n";
    $recordHTML .= "    <p class=\"forum_name\">\n";
    $recordHTML .= "    <a href=\"index.php?forum=\{$forum_info->forum_id}&name={$forum_url_name}\">{$forum_info->forum_name}</a>\n";
    $recordHTML .= "    </p>\n";
    $recordHTML .= "    <p class=\"forum_description\">{$forum_info->forum_description}</p>\n";
    $recordHTML .= "    </td>\n";
    $recordHTML .= "    <td class=\"forum_topics\">{$forum_info->forum_topics}<span class=\"small_word\">".TOPICS."</span></td>\n";
    $recordHTML .= "    <td class=\"forum_posts\">{$forum_info->forum_posts}<span class=\"small_word\">".POSTS."</span></td>\n";
    
    $recordHTML .= "    <td class=\"forum_last_post\">\n";
    if(!$forum_info->forum_last_poster || $forum_info->forum_last_poster==0)
    {
        $recordHTML .= "<p class=\"noposts\">".NO_POSTS."</p><p class=\"be_the_first\">".BE_FIRST."</p>\n";
    }
    else
    {
        $forum_last_post_clean = str_replace(' ', '_', $forum_info->user_username);
        $last_post = date("F j, Y", strtotime($forum_info->forum_last_post_time));
        if ($last_post == date('F j, Y')) { $last_post = 'Today at '.date("g:i a", strtotime($forum_info->forum_last_post_time)); }

        $recordHTML .= "<p class=\"last_post_name\">\n";
        $recordHTML .= "<a href=\"index.php?topic={$forum_info->topic_id}&name={$forum_last_post_clean}\">{$forum_info->post_subject}</a>\n";
        $recordHTML .= "</p>\n";
        $userClass = '';
        switch($forum_info->forum_last_poster)
        {
            case 1:
                $userClass .= 'admin';
                break;
            case 2:
                $userClass .= 'mod';
                break;
            case 3:
            case 0:
            default:
                $userClass .= 'user';
                break;
        }
        $recordHTML .= "<p class=\"posted_by\">Posted By - <span class=\"{$userClass}\">{$forum_info->user_username}}</span></p>\n";
        $recordHTML .= "<p class=\"last_post_date\">{$last_post}</p>\n";
    }
    $recordHTML .= "</td>\n";
    $recordHTML .= "</tr>\n";
    
    //Add the record HTML to records array
    $parentData['records'][] = $recordHTML;
}
    
//Display records for last parent ID
echo createTable($parentData);
?>

     

    Here is the sql dump also for the database if it helps. This code will be open source when i finish so im not too fussed about people knowing the layout. There are bound to be changes anyway.

     

    
CREATE TABLE IF NOT EXISTS `forum_config` (
  `config_id` int(11) NOT NULL AUTO_INCREMENT,
  `config_site_root` varchar(55) NOT NULL,
  `config_site_name` varchar(55) NOT NULL,
  `config_word_filter` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`config_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `forum_config`
--

INSERT INTO `forum_config` (`config_id`, `config_site_root`, `config_site_name`, `config_word_filter`) VALUES
(1, 'http://localhost/myforum', 'ASF', 0);

-- --------------------------------------------------------

--
-- Table structure for table `forum_forums`
--

CREATE TABLE IF NOT EXISTS `forum_forums` (
  `forum_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL,
  `forum_name` varchar(100) NOT NULL,
  `forum_description` varchar(500) NOT NULL,
  `forum_topics` int(11) NOT NULL,
  `forum_posts` int(11) NOT NULL,
  `forum_last_post` int(11) NOT NULL,
  `forum_last_post_time` datetime NOT NULL,
  `forum_last_poster` int(11) NOT NULL,
  PRIMARY KEY (`forum_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `forum_forums`
--

INSERT INTO `forum_forums` (`forum_id`, `parent_id`, `forum_name`, `forum_description`, `forum_topics`, `forum_posts`, `forum_last_post`, `forum_last_post_time`, `forum_last_poster`) VALUES
(4, 3, 'Offtopic Chat', 'If you have something to say, something that maybe doesn''t quite fit anywhere else, then post it here. This is where you can talk about anything and everything.', 1, 1, 11, '2010-09-12 06:11:22', 27),
(3, 2, 'Have an Idea?', 'Everyone building a project from the ground up needs ideas. And that''s where you come in. You may have an idea for a new feature or you may have a better design. Whatever it is, share it here.', 0, 0, 0, '0000-00-00 00:00:00', 0),
(1, 1, 'Welcome', 'Are you new to the forum? If so then this is the place to start. Post an introduction and get aquainted with the staff and friendly members of our community.', 1, 1, 22, '2010-09-18 04:55:49', 27),
(5, 1, 'New Features', 'All new features that have already been implemented wil be posted here. This is the place to come if you want to find out about them or talk about them.', 0, 0, 0, '0000-00-00 00:00:00', 0),
(2, 1, 'Coming Soon', 'Coming soon to a forum near you. Interested to find out what is going on behind the scenes? Well you will find out everything you need to know here, including the latest features.', 0, 0, 0, '0000-00-00 00:00:00', 0);

CREATE TABLE IF NOT EXISTS `forum_members` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_username` varchar(32) NOT NULL,
  `user_email` varchar(100) NOT NULL,
  `user_password` varchar(55) NOT NULL,
  `user_real_name` varchar(32) NOT NULL,
  `user_group` int(1) NOT NULL,
  `user_register_ip` varchar(32) NOT NULL,
  `user_regdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_birthday` varchar(5) NOT NULL DEFAULT '00-00',
  `user_online` int(1) NOT NULL,
  `user_group_color` varchar(6) NOT NULL,
  `user_avatar` varchar(150) NOT NULL DEFAULT 'avatars/none.png',
  `user_sex` varchar(1) NOT NULL,
  `user_location` varchar(32) NOT NULL,
  `user_confirmed` int(1) NOT NULL,
  `user_show_sex` int(1) NOT NULL DEFAULT '0',
  `user_show_location` int(1) NOT NULL DEFAULT '0',
  `user_show_status` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;

INSERT INTO `forum_members` (`user_id`, `user_username`, `user_email`, `user_password`, `user_real_name`, `user_group`, `user_register_ip`, `user_regdate`, `user_birthday`, `user_online`, `user_group_color`, `user_avatar`, `user_sex`, `user_location`, `user_confirmed`, `user_show_sex`, `user_show_location`, `user_show_status`) VALUES
(27, 'doddsey65', 'doddsey_65@hotmail.com', 'ff97e4e4e184e00299c90eac38d54799c97096d2', '', 1, '127.0.0.1', '2010-09-21 14:40:39', '11-11', 1, 'ff0000', 'avatars/asf.jpg', 'm', 'UK North East', 1, 1, 1, 1);


CREATE TABLE IF NOT EXISTS `forum_parents` (
  `parent_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_name` varchar(100) NOT NULL,
  PRIMARY KEY (`parent_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `forum_parents`
--

INSERT INTO `forum_parents` (`parent_id`, `parent_name`) VALUES
(1, 'Forum and Site News'),
(2, 'Share Your Ideas'),
(3, 'Offtopic Chat');

-- --------------------------------------------------------

--
-- Table structure for table `forum_posts`
--

CREATE TABLE IF NOT EXISTS `forum_posts` (
  `post_id` int(11) NOT NULL AUTO_INCREMENT,
  `topic_id` int(11) NOT NULL,
  `forum_id` int(11) NOT NULL,
  `post_poster` int(11) NOT NULL,
  `post_subject` varchar(100) NOT NULL,
  `post_content` longtext NOT NULL,
  `post_time` datetime NOT NULL,
  `post_edit_by` varchar(32) NOT NULL,
  `post_edit_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_approved` int(1) NOT NULL DEFAULT '0',
  `post_quoting` varchar(32) NOT NULL,
  PRIMARY KEY (`post_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=110 ;

--
-- Dumping data for table `forum_posts`
--

INSERT INTO `forum_posts` (`post_id`, `topic_id`, `forum_id`, `post_poster`, `post_subject`, `post_content`, `post_time`, `post_edit_by`, `post_edit_date`, `post_approved`, `post_quoting`) VALUES
(22, 23, 1, 27, 'Welcome To ASF', 'Hi and Welcome to ASF Forums. \r\n\r\nFirst, let me thank you for visiting this site while it is still in production. If you come accross any errors please let us know via the contact page or on the forum thread [url=http://forum.nystic.com/viewtopic.php?f=27&t=11986]here[/url].\r\n\r\nAs we are still in development not all features may work. This may be due to them being currently worked on and we ask for your patience while we add such features. Please keep checking back on our progress.\r\n\r\nWe hope you like what you see. If you have any questions or comments then please register and post a thread.\r\n\r\nThanks', '2010-09-18 04:55:49', '', '0000-00-00 00:00:00', 0, ''),
(11, 19, 4, 27, 'Thanks To BillyMcguffin', 'Thanks go to [b]Billy Mcguffin[/b] for his logo, which is now the main logo for ASF forums.', '2010-09-12 02:09:13', '', '0000-00-00 00:00:00', 0, '');

-- --------------------------------------------------------

--
-- Table structure for table `forum_sessions`
--

CREATE TABLE IF NOT EXISTS `forum_sessions` (
  `session_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `session` int(11) NOT NULL,
  `ip` varchar(11) NOT NULL,
  `browser` varchar(255) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`session_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `forum_sessions`
--


-- --------------------------------------------------------

--
-- Table structure for table `forum_topics`
--

CREATE TABLE IF NOT EXISTS `forum_topics` (
  `topic_id` int(11) NOT NULL AUTO_INCREMENT,
  `forum_id` int(11) NOT NULL,
  `topic_name` varchar(100) NOT NULL,
  `topic_poster` int(11) NOT NULL,
  `topic_time_posted` datetime NOT NULL,
  `topic_views` int(11) NOT NULL,
  `topic_replies` int(11) NOT NULL,
  `topic_last_poster` int(11) NOT NULL,
  `topic_last_post_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `topic_locked` int(1) NOT NULL DEFAULT '0',
  `topic_sticky` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`topic_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

--
-- Dumping data for table `forum_topics`
--

INSERT INTO `forum_topics` (`topic_id`, `forum_id`, `topic_name`, `topic_poster`, `topic_time_posted`, `topic_views`, `topic_replies`, `topic_last_poster`, `topic_last_post_time`, `topic_locked`, `topic_sticky`) VALUES
(19, 4, 'Thanks To BillyMcguffin', 27, '2010-09-18 04:44:25', 0, 0, 27, '2010-09-12 01:06:00', 0, 0),
(23, 1, 'Welcome To ASF', 27, '2010-09-18 04:55:49', 129, 0, 27, '2010-09-18 03:55:00', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `forum_user_details`
--

CREATE TABLE IF NOT EXISTS `forum_user_details` (
  `user_id` int(11) NOT NULL,
  `user_fname` varchar(32) NOT NULL,
  `user_lname` varchar(32) NOT NULL,
  `user_avatar` varchar(255) NOT NULL,
  `user_sig` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `forum_user_details`
--

INSERT INTO `forum_user_details` (`user_id`, `user_fname`, `user_lname`, `user_avatar`, `user_sig`) VALUES
(27, '', '', 'avatars/asf.jpg', '
[left][img=http://img178.imageshack.us/img178/7157/mainlogo.jpg][/left]
 
[right][size=32][b][url=http://thevault.cz.cc]ASF - A Simple Forum[/url][/b][/size][/right]
');

     

    By the looks of it the code is exactly what i need. Maybe just a problem with the print_r. Ive never used arrays before so i wouldnt know.

     

    Thanks

    small class help

    in PHP Coding Help

    Posted

    Hi, i have a class which i am writing(just a small test) which is supposed to create a label for a form but nothing is showing up. Here is the html part:

     

    $frobj=new asf_form();
$frobj->form_label('Username');

     

    and here is the class code:

     

    function form_label($label='')
  {
  
  if($label == '') 
  {
  return false;
  }
  else
  {
  return '<label for='.$label.'>'.$label;
  }
  }

     

    Have i done something wrong?

    table joins

    in PHP Coding Help

    Posted

    okay let me put a stop to this, since i always come here first for help. Im sorry if you think i am being argumentative, or what i said was potrayed as such. Thats not what i meant to happen. Maybe just a little frustration on my part for not being able to understand. I only said i needed the loop within a loop because i couldnt see any other way. And yes your wuery did return all of the results and that has been implemented but that isnt the issue now. The new issue was about the table headers. I accept the blame though, as i never seem to be able to clearly explain a problem. It seems so simple in my head but i can never get it into words properly. Sorry

    table joins

    in PHP Coding Help

    Posted

    well i used to think this was a firendly community until now. No i am not lazy, i simply didnt understand. I never asked anyone to do the work for me i asked for help. I still dont understand the solution to my problem as i am fairly new to php but it doesnt matter now. I will just close this topic and get help elsewhere.

    table joins

    in PHP Coding Help

    Posted

    what about this then:

     

    $parent_info_query = $db->query("SELECT
              p.parent_id, p.parent_name

          FROM ".DB_PREFIX."parents as p
         
          ORDER BY p.parent_id")
         
            or trigger_error("SQL", E_USER_ERROR);
               
while ($parent_info = mysql_fetch_object($parent_info_query)) {



// Add parent_id into variable for later query

$parent_id = $parent_info->parent_id;

echo '<table class="forum_table" onclick="expandCollapseTable(this)">
<tr id="tr1">
<th class="forum_left_corner"></th>
<th class="forum_parent_name">'.$parent_info->parent_name.'</th>
<th class="empty"></th>
<th class="empty"></th>
<th class="forum_last_post_header">'.LAST_POST.'</th>
</tr>';


$forum_info_query = $db->query("SELECT
              f.forum_id,
              f.forum_name,
              f.forum_description,
              f.forum_topics,
              f.forum_posts,
              f.forum_last_poster,
              f.forum_last_post_time,
              f.forum_last_post,
              m.user_id,
              m.user_username,
              m.user_group,
              t.topic_id,
              t.topic_name,
              po.post_id,
              po.post_subject
             
          FROM ".DB_PREFIX."forums as f

          LEFT JOIN ".DB_PREFIX."members as m
              ON f.forum_last_poster = m.user_id
             
          LEFT JOIN ".DB_PREFIX."topics as t
              ON t.forum_id = f.forum_id
             
          LEFT JOIN ".DB_PREFIX."posts as po
              ON po.post_id = f.forum_last_post
             
          WHERE f.parent_id = '$parent_id'
             
          ORDER BY f.forum_id")
         
            or trigger_error("SQL", E_USER_ERROR);
               
while ($forum_info = mysql_fetch_object($forum_info_query)) {

// Get Forum information from DB to show all forums
// including who the last post was posted by

echo '<tr class="gradient">';

$forum_url_name = $forum_info->forum_name;
$forum_url_name = str_replace(' ', '_', $forum_url_name);

echo '    <td class="forum_icon">
        <div class="thread_icon"></div>
        </td>
        <td class="forum_name">
        <p class="forum_name"><a href="index.php?forum=
        '. $forum_info->forum_id . '
        &name=
        '.$forum_url_name.'
        ">
        ' . $forum_info->forum_name .'
        </a></p>
        <p class="forum_description">
        ' . $forum_info->forum_description .'
        </p></td>
       
        <td class="forum_topics">
        '. $forum_info->forum_topics .'
        <span class="small_word"> '.TOPICS.'</span></td>
       
        <td class="forum_posts">
        '. $forum_info->forum_posts .'
        <span class="small_word"> '.POSTS.'</span></td>
       
        <td class="forum_last_post">';
           
        if (!$forum_info->forum_last_poster) {
       
        echo '<p class="noposts">'.NO_POSTS.'</p>
                <p class="be_the_first">'.BE_FIRST.'</p>';
       
        }
        elseif ($forum_info->forum_last_post == 0) {
       
        echo '<p class="noposts">'.NO_POSTS.'</p>
                <p class="be_the_first">'.BE_FIRST.'</p>';
       
        }

        else {
       
       
        $forum_last_post_clean = str_replace(' ', '_', $forum_info->user_username);
       
        echo '<p class="last_post_name"><a href="index.php?topic='.$forum_info->topic_id.'
        &name='.$forum_last_post_clean.'">'.$forum_info->post_subject.'</a></p>';
       
        echo '<p class="posted_by">Posted By - ';
       
        $today = date('F j, Y');
        $last_post = date("F j, Y", strtotime($forum_info->forum_last_post_time));
       
        if ($last_post == $today) { $last_post = 'Today at '.date("g:i a", strtotime($forum_info->forum_last_post_time)); }
       
        else { $last_post = date("F j, Y - g:i a", strtotime($forum_info->forum_last_post_time)); }
        if ($forum_info->user_group == 1) { echo
        '<span class="admin">'; }
       
        elseif ($forum_info->user_group == 2) { echo
        '<span class="mod">'; }
       
        elseif ($forum_info->user_group == 3) { echo
        '<span class="user">'; }
       
        elseif ($forum_info->user_group == 0) { echo
        '<span class="user">'; }
       
echo    $forum_info->user_username .'</span></p>

       
        <p class="last_post_date">'
        .$last_post;
        }
echo    '</p></td></tr>';

}
}

     

     

    As you can see the first query ($parent_info_query) gets the parent name and parent id so i can use the parent id in the next query ($forum_info_query) so i can use WHERE parent_id = $parent_id. This is so it groups the results into the respective categories. Is there a way to do this without a loop in a loop? and why is this bad practice?

     

    Thanks

    table joins

    in PHP Coding Help

    Posted

    it is grouping them by parent_id but each record is in its own table with its own <th>s. What i need is so that records with parent_id 1 are in a table with <th>s and records with parent_id 2 in a different table with <th>s and so on.

     

    Heres my code so far:

     

    $forum_info_query = $db->query("SELECT
              f.forum_id, f.forum_name, f.forum_description, f.forum_topics, f.forum_posts,
              f.forum_last_poster, f.forum_last_post_time, f.forum_last_post,
              p.parent_id, p.parent_name,
              m.user_id, m.user_username, m.user_group,
              t.topic_id, t.topic_name,
              po.post_id, po.post_subject
          FROM ".DB_PREFIX."forums as f
          JOIN ".DB_PREFIX."parents as p
              ON f.parent_id = p.parent_id
          LEFT JOIN ".DB_PREFIX."members as m
              ON f.forum_last_poster = m.user_id
          LEFT JOIN ".DB_PREFIX."topics as t
              ON f.forum_id = t.forum_id
          LEFT JOIN ".DB_PREFIX."posts as po
              ON po.post_id = f.forum_last_post
          ORDER BY p.parent_id")
                    or trigger_error("SQL", E_USER_ERROR);

while ($forum_info = mysql_fetch_object($forum_info_query)) { 

// Add parent_id into variable for later query

$parent_id = $forum_info->parent_id;

echo '<table class="forum_table" onclick="expandCollapseTable(this)">
<tr id="tr1">
<th class="forum_left_corner"></th>
<th class="forum_parent_name">'.$forum_info->parent_name.'</th>
<th class="empty"></th>
<th class="empty"></th>
<th class="forum_last_post_header">'.LAST_POST.'</th>
</tr>';

// Get Forum information from DB to show all forums
// including who the last post was posted by

echo '<tr class="gradient">';

$forum_url_name = $forum_info->forum_name;
$forum_url_name = str_replace(' ', '_', $forum_url_name);

echo '    <td class="forum_icon">
        <div class="thread_icon">'.$forum_info->forum_id.'</div>
        </td>
        <td class="forum_name">
        <p class="forum_name"><a href="index.php?forum=
        '. $forum_info->forum_id . '
        &name=
        '.$forum_url_name.'
        ">
        ' . $forum_info->forum_name .'
        </a></p>
        <p class="forum_description">
        ' . $forum_info->forum_description .'
        </p></td>
        
        <td class="forum_topics">
        '. $forum_info->forum_topics .'
        <span class="small_word"> '.TOPICS.'</span></td>
        
        <td class="forum_posts">
        '. $forum_info->forum_posts .'
        <span class="small_word"> '.POSTS.'</span></td>
        
        <td class="forum_last_post">';
            
        if (!$forum_info->forum_last_poster) {
        
        echo '<p class="noposts">'.NO_POSTS.'</p>
                <p class="be_the_first">'.BE_FIRST.'</p>';
        
        }
        elseif ($forum_info->forum_last_post == 0) {
        
        echo '<p class="noposts">'.NO_POSTS.'</p>
                <p class="be_the_first">'.BE_FIRST.'</p>';
        
        }

        else {
        
        
        $forum_last_post_clean = str_replace(' ', '_', $forum_info->user_username);
        
        echo '<p class="last_post_name"><a href="index.php?topic='.$forum_info->topic_id.'
        &name='.$forum_last_post_clean.'">'.$forum_info->post_subject.'</a></p>';
        
        echo '<p class="posted_by">Posted By - ';
        
        $today = date('F j, Y');
        $last_post = date("F j, Y", strtotime($forum_info->forum_last_post_time));
        
        if ($last_post == $today) { $last_post = 'Today at '.date("g:i a", strtotime($forum_info->forum_last_post_time)); }
        
        else { $last_post = date("F j, Y - g:i a", strtotime($forum_info->forum_last_post_time)); }
        if ($forum_info->user_group == 1) { echo 
        '<span class="admin">'; }
        
        elseif ($forum_info->user_group == 2) { echo 
        '<span class="mod">'; }
        
        elseif ($forum_info->user_group == 3) { echo 
        '<span class="user">'; }
        
        elseif ($forum_info->user_group == 0) { echo 
        '<span class="user">'; }
        
echo    $forum_info->user_username .'</span></p>

        
        <p class="last_post_date">'
        .$last_post;
        }
echo    '</p></td></tr>';

}

     

    also one of the records(just one) is displayed twice. I can do an export of the forum table in the database if that helps.

     

    table joins

    in PHP Coding Help

    Posted

    thanks, it worked. I used your example and changed a few things. I also added the loop but they are no longer being grouped in their parents. They should be grouped by their parent id into different tables, but they arent anymore. Here is the link to the live version which shows what i mean about the grouping: http://thevault.cz.cc But they are all now in their own single tables.

    table joins

    in PHP Coding Help

    Posted

    UPDATE: I have realised that the wuery is not pulling the forums with no topics or replies. I think this is due to this bit of code in the query:

     

    JOIN ".DB_PREFIX."members
                    
                    ON ".DB_PREFIX."forums.forum_last_poster
                    = ".DB_PREFIX."members.user_id

     

    but i need that in to pull the username of the last poster. Any other way of doing this?

     

     

    table joins

    in PHP Coding Help

    Posted

    I have this code which should get all the results from forum_forums and list them in their respective parents using forum_forums.parent_id. It does work sort of but it repeats one of them and doesnt include all of them.

     

    Can anyone see where i am going wrong?

     

    $parent_info_query = $db->query("SELECT 
                    parent_id,
                    parent_name
                    FROM ".DB_PREFIX."parents")
                    or die(mysql_error());

while ($parent_info = mysql_fetch_object($parent_info_query)) { 

// Add parent_id into variable for later query

$parent_id = $parent_info->parent_id;

echo '<table class="forum_table" onclick="expandCollapseTable(this)">
<tr id="tr1">
<th class="forum_left_corner"></th>
<th class="forum_parent_name">'.$parent_info->parent_name.'</th>
<th class="empty"></th>
<th class="empty"></th>
<th class="forum_last_post_header">'.LAST_POST.'</th>
</tr>';

// Get Forum information from DB to show all forums
// including who the last post was posted by

$forum_info_query = $db->query("SELECT 

                    ".DB_PREFIX."forums.forum_id,
                    ".DB_PREFIX."forums.forum_name,
                    ".DB_PREFIX."forums.forum_description,
                    ".DB_PREFIX."forums.forum_topics,
                    ".DB_PREFIX."forums.forum_posts,
                    ".DB_PREFIX."forums.forum_last_poster,
                    ".DB_PREFIX."forums.forum_last_post_time,
                    ".DB_PREFIX."forums.forum_last_post,
                    
                    ".DB_PREFIX."members.user_id,
                    ".DB_PREFIX."members.user_username,
                    ".DB_PREFIX."members.user_group,
                    
                    ".DB_PREFIX."topics.topic_id,
                    ".DB_PREFIX."topics.topic_name
                    
                    FROM ".DB_PREFIX."forums
                    
                    JOIN ".DB_PREFIX."members
                    
                    ON ".DB_PREFIX."forums.forum_last_poster
                    = ".DB_PREFIX."members.user_id
                    
                    JOIN ".DB_PREFIX."topics
                    
                    ON ".DB_PREFIX."forums.forum_id
                    = ".DB_PREFIX."topics.forum_id
                    
                    WHERE ".DB_PREFIX."forums.parent_id 
                    = $parent_id") 
                    
                    or trigger_error("SQL", E_USER_ERROR);
                    
while ($forum_info = mysql_fetch_object($forum_info_query)) {

    collapsible table rows

    in Javascript Help

    Posted

    thanks, the expand collapse works perfectly when i added it to my code. i realise there are several coding issues and cleanups to be done. I have started doing this on another page, including table joins and classes. Just havent got far with it. Thanks alot. maybe if you have time later you could have a look at the page i have cleaned up and see if everything within it is clean and good standard. Only if you have time though.

×
×
  • 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.