PHP - How Do Forums Check If You've Read A Post Or Not?

Once upon a time needed help on March 12, 2008 this community helped me, I am still a learner tried to help back but all the problems posted here beyond my skills to solve them so I kept quiet.  and Now I need help once again hope I will get it done.

Its PHPPOS developed in Codeigniter This code below is from application\controllers\inventory_summary.php file

Code: [Select]
<?php
require_once("report.php");
class Inventory_summary extends Report
{
function __construct()
{
parent::__construct();
}

public function getDataColumns()
{
return array($this->lang->line('reports_item_name'), $this->lang->line('reports_item_number'), $this->lang->line('reports_description'), $this->lang->line('reports_count'), $this->lang->line('reports_reorder_level'));
}

public function getData(array $inputs)
{
$this->db->select('name, item_number, quantity, reorder_level, description');
$this->db->from('items');
$this->db->where('deleted', 0);
$this->db->order_by('name');

return $this->db->get()->result_array();

}

public function getSummaryData(array $inputs)
{
return array();
}
}
?>

And this partial code below  is from application\controllers\report.php file


Code: [Select]
function inventory_summary($export_excel=0)
  {
    $this->load->model('reports/Inventory_summary');
    $model = $this->Inventory_summary;
    $tabular_data = array();
    $report_data = $model->getData(array());
    foreach($report_data as $row)
    {
      $tabular_data[] = array($row['name'], $row['item_number'], $row['description'], $row['quantity'], $row['reorder_level']);
    }

    $data = array(
      "title" => $this->lang->line('reports_inventory_summary_report'),
      "subtitle" => '',
      "headers" => $model->getDataColumns(),
      "data" => $tabular_data,
      "summary_data" => $model->getSummaryData(array()),
      "export_excel" => $export_excel
    );

    $this->load->view("reports/tabular",$data); 
  }
 
}
?>
Together they get the job done as follow:



Item Name   Item Number   Description   Count   Reorder Level   (Count is quantity in stock)
Item 1                   0002            xyz                    5                  3
Item 2                   0s00            xyz                    5                  3
Item 3                   0005            xyz                    5                  3
Item 4                   0006            xyz                    5                  3


The output I want need to be like this:

Item Name   Item Number   Description    cost price         Count        Reorder Level
Item 1                   0002            xyz                       250                5                  3
Item 2                   0s00            xyz                       120                5                  3
Item 3                   0005            xyz                       300                5                  3
Item 4                   0006            xyz                       500                5                  3
                                                                                   
                                                Total Stock Value  5850  Total Count 20  <-- this doesn't require any formation just needs to be at bottom of all the queries  like shown here.
           

This is what I want mainly >>>>>>>>>>  Total Stock Value (cost price * count foreach and then sum of all results ) and  sum of all count


cost price table and column is different than one used above in the code which is:

databse table is ' receivings_items '
Column is 'item_cost_price'

example php code to fetch is :


Code: [Select]
$sql = "SELECT `item_cost_price` FROM `receivings_items`";
config.php contains all the connection variables to MySQL



Please Help me   

Hello together,

I'm still relatively new with PHP and I'm encountering an error with the error code (Warning: Undefined array key "title" in I:\xampp\htdocs\test\Datenspeichern.php on line 13 to 17.).

Normally I wanted that when I enter the data in the fields from the CD_Website page, that it is inserted in my created database and displayed in the table on the page. 

Does anyone know where my error is? 

Thanks a lot

 

main Code=

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Unbenanntes Dokument</title>
<style type="text/css">
table {
        border-collaps: collapse;
        width: 100%;
        font-family: serif;
        font-size: 35px;
        text-align: center;
        
    
}

td {
        font-size: 25px;
        text-align: center;
        font-family: serif;
}


</style>
</head>
<body>
<table>
    <tr>
        <th>CD-Titel</th>
        <th>Artist</th>
        <th>Songtitel</th>
        <th>Musiklänge</th>
        <th>Lied Nummer</th>
        </tr>
        
    
        
<?php                                                             

    $host = "localhost";
    $user = "root";
    $password = "";
    $db_name = "cdaufgabe";

    $con = mysqli_connect($host, $user, $password, $db_name);
    if(mysqli_connect_error()) {
        die("Verbindungsabbruch mit der Datenbank: ". mysqli_connect_error());
      };

    $check = "SELECT * FROM `cd-titel`";
    $result = mysqli_query($con, $check);
    
    if ($result > null) {
    while ($row = $result->fetch_assoc()){
    echo "<tr><td>" . $row['CD-Titel'] . "</td> <td>" . $row['Artist'] . "</td> <td>" . $row['Songtitel'] . "</td> <td>" . $row['Musiklänge'] . "</td> <td>" . $row['Lied-Nummer'] . "</td></tr>";
    };        
    };
    
    
    
    /*if (isset($_POST['submitted'])) {
            
    
    $titel = $_POST['titel'];
    $artist = $_POST['artist'];
    $songtitel = $_POST['songtitel'];
    $musicle = $_POST['musicle'];
    $liednr = $_POST['liednr'];
    $data_add =  "INSERT INTO cd-titel (CD-Titel, Artist, Songtitel, Musiklänge, Lied-Nummer) VALUES ('$titel', '$artist', '$songtitel', '$musicle', '$liednr')";
    
    if (!mysqli_query($db_name, $data_add)) {
        die('Fehler beim einfügen von Daten');
    }
        

}
*/
// $data_add =  "INSERT INTO `cd-titel` (`CD-Titel`, `Artist`, `Songtitel`, `Musiklänge`, `Lied-Nummer`) VALUES ('$titel', '$artist', '$songtitel', '$musicle', '$liednr')";
// mysqli_query($con, $data_add);    
    
    
    /*mysqli_query($con, $data_add);*/
    

?>

<form methode="post" action="Datenspeichern.php"> 
            <input type="text" name="titel" placeholder="CD-Titel"/>
            <input type="text" name="artist" placeholder="Artist"/>
            <input type="text" name="songtitel" placeholder="Songtitel"/>
            <input type="text" name="musicle" placeholder="Musiklänge"/>
            <input type="text" name="liednr" placeholder="Lied-Nummer"/> 
             <input type="submit" name="submitted" value="speichern"/>
    </form>
    </br></br></br>
    </table>

</body>
</html>

second code(Datenspeichern.php)=

<?php                                                             
$con = mysqli_connect('localhost', 'root', '');
 if (!$con) {
     echo'Nicht verfügbar';
 }
 
 if (!mysqli_select_db($con, 'cdaufgabe')){
 
        echo 'Datenbank nicht ausgewählt';
        
 };
 
    $titel = $_POST['titel'];
    $artist = $_POST['artist'];
    $songtitel = $_POST['songtitel'];
    $musicle = $_POST['musicle'];
    $liednr = $_POST['liednr'];
 
 
    $data_add =  "INSERT INTO cd-titel (CD-Titel, Artist, Songtitel, Musiklänge, Lied-Nummer) VALUES ('$titel', '$artist', '$songtitel', '$musicle', '$liednr')";
    
 if (!mysqli_query($con, $data_add)){
     echo 'Fehler';
     
 }
 
 else {
     echo'Eingefügt';
 };
 
 
 
 header("url=CD_Webseite.php");
 
?>

Does anyone knows the mistake i keep doing?

Im wanting to not allow people to post any links in the comments section of a form (spammers) and have created a comma delimited list of essentially of every known domain name extension.

To apply the filter I have the following code:

Code: [Select]
$WordAllowed = true;
$BannedWords = explode(",", ReadDB($Options["ban_words"]));
if (count($BannedWords)>0) {
  $checkComment = strtolower($_REQUEST["comment"]);
  for($i=0;$i<count($BannedWords);$i++){
  $banWord = trim($BannedWords[$i]);
  if (trim($BannedWords[$i])<>'') {
  if(preg_match("/".$banWord."/i", $checkComment)){
  $WordAllowed = false;
  break;
  }
  }
  }
}
if($WordAllowed==false) {
$SysMessage =  $OptionsLang["Banned_word_used"];
} else { Insert into my table

I could have sworn this was working last time I was in this code but recently checking it again it is blocking pretty much everything claiming a banned word is used.  The only thing I can get to post is 'lol'.  Trying funny phrases like: first! or Great information, thanks, this is a test of the comment section, etc....they all get flagged 

Can anyone with fresh eyes assist?  Im weary and frustrated and its been forever since I wrapped my head around this. 

My banned word list:
Code: [Select]
www,http,com,org,.aero,.asia,.biz,.com,.coop,.edu,.gov,.info,.int,.jobs,.mil,.mobi,.museum,.name,.net,.org,
.pro,.tel,.travel,.xxx,.a,.bitnet,.ac,.ad,.ae,.af,.ag,.ai,.al,.am,.an,.ao,.aq,.ar,.as,.at,.au,.aw,.az,.ba,.bb,.bd,.be,.bf,.bg
,.bh,.bi,.bj,.bm,.bn,.bo,.br,.bs,.bt,.bv,.bw,.by,.bz,.ca,.cc,.cf,.cg,.ch,.ci,.ck,.cl,.cm,.cn,.co,.com,.cr,.cs,.cu,.cv,.cx,.cy,.cz
,.de,.dj,.dk,.dm,.do,.dz,.ec,.edu,.ee,.eg,.eh,.er,.es,.et,.fi,.fj,.fk,.fm,.fo,.fr,.fx,.ga,.gb,.gd,.ge,.gf,.gh,.gi,.gl,.gm,.gn
,.gov,.gp,.gq,.gr,.gs,.gt,.gu,.gw,.gy,.hk,.hm,.hn,.hr,.ht,.hu,.id,.ie,.il,.in,.io,.iq,.ir,.is,.it,.jm,.jo,.jp,.ke,.kg,.kh,.ki,.km
,.kn,.kp,.kr,.kw,.ky,.kz,.la,.lb,.lc,.li,.lk,.lr,.ls,.lt,.lu,.lv,.ly,.ma,.mc,.md,.mg,.mh,.mil,.mk,.ml,.mm,.mn,.mo,.mp,.mq,.mr,
.ms,.mt,.mu,.mv,.mw,.mx,.my,.mz,.na,.nc,.ne,.net,.nf,.ng,.ni,.nl,.no,.np,.nr,.nt,.nu,.nz,.om,.org,.pa,.pe,.pf,.pg,.ph,
.pk,.pl,.pm,.pn,.pr,.pt,.pw,.py,.qa,.re,.ro,.ru,.rw,.sa,.sb,.sc,.sd,.se,.sg,.sh,.si,.sj,.sk,.sl,.sm,.sn,.so,.sr,.st,.su,.sv,
.sy,.sz,.tc,.td,.tf,.tg,.th,.tj,.tk,.tm,.tn,.to,.tp,.tr,.tt,.tv,.tw,.tz,.ua,.ug,.uk,.um,.us,.uy,.uz,.va,.vc,.ve,.vg,.vi,.vn,.vu,.wf,
.ws,.ye,.yt,.yu,.za,.zm,.zr,.zw
Thanks in advance for any help

Hello. I'm new to pHp and I would like to know how to get my $date_posted to read as March 12, 2012, instead of 2012-12-03.
Here is the code:
Code: [Select]
<?php

$sql = " SELECT id, title, date_posted, summary FROM blog_posts ORDER BY date_posted ASC LIMIT 10 ";

$result = mysql_query($sql);

while($row = mysql_fetch_assoc($result)) {
$id = $row['id'];
$title = $row['title'];
$date_posted = $row['date_posted'];
$summary = $row['summary'];

echo "<h3>$title</h3>\n";
echo "<p>$date_posted</p>\n";
echo "<p>$summary</p>\n";
echo "<p><a href=\"post.php?id=$id\" title=\"Read More\">Read More...</a></p>\n";
}

?>
I have tried the date() function but it always updates with the current time & date so I'm a little confused on how I get this to work.

Hello, I try to get website speed of some website, but i can read only ''domain.com'' i can't read website files like css , js ... why ? i use proxies for this job. here is the php code:

$options = array(
'useragent' => "Firefox (+http://www.firefox.org)", // who am i
'connecttimeout' => 120, // timeout on connect
'timeout' => 120, // timeout on response
'redirect' => 10, // stop after 10 redirects
'referer' => "http://www.google.com",
'proxyhost' =>'85.25.8.14:80'
);
$response = http_get("http://solve-ict.com/wp-content/themes/ict%20theme/js/jquery-1.7.1.min.js", $options , $info);

but it works fine with http://domain.com/ , but with files css or js it gives 404, using some free proxy servers available ? Thanks.

Trying to get this done:

Page_1 has many external links, when certain links are clicked i do not want user to go directly to page, but rather go to a special add page_2 where user must click a second time on the link to finally get there.

The add page_2 must show on screen the name of the initial link from page_1, it must change accordingly with the link it came from page_1,once on page_2 the hyperlink redirects outside the site.

So far i am thinking give an id to the div or "<a href..." on page_1 then somehow have page_2 detect that id and fill in the variable for the final external link. Other wise is there a way to detect a url from incoming?

I guess a similar example is how some domain name sellers landing page will indicate the name of the site. Such as "Thisdomain.com" is for sale. same landing page but the name changes according to the domain that was typed.

im using the modified preorder tree traversal heirarchal system for my forum. (http://articles.sitepoint.com/article/hierarchical-data-database/2)
basically where you store the left and right id to form relationships between forums like phpbb does. but im struggling to show subforums underneath their parents. eg:

Code: [Select]
forum id    left id     right id     parent id
    1            1           8               0          this is a category
    2            2           7               1          this is a forum belonging to the category
    3            3           6               1          this is a forum belonging to the category
    4            4           5               2          this is a subforum belonging to forum 2

i can display all of the forums within their categories fine but cant think how to add the subforums underneath the forums that have them. has anyone got any advice?

I wil ltry and explain this the best i can so please bare with me if it doesnt come out right first time lol.

I am making a forum and as we all know forums have subforums or child boards that are within the forums themselves. Like php freaks has the forum php coding and then a sub forum within it for php regex.

Im having trouble coding this though. Anyone have any tips on code and database structure that could help?
I was thinking of making three new database tables for child forums, child topics and child posts but im sure there is an easier way. something like a column within the main forum table which defines wether the forum is a child or not. But then how would i link this child forum with the forum that its supposed to be in. Any advice is greatly appreciated. Thanks.

Hi all  ,

I'm a newbie in PHP coding and wondering how to do like that:
...forums / showthread.php? t = 10
in VBulletin forums.
I created forums using PHP (and his pros ^^ ) but I gave for each new topic a new .php page.

Thanks for all who'll help me to do, at least some keywords to look for.
Nice Regards!

So, you know how on forums (including this one) the icon of a topic/forum will be greyed out if your account viewed that topic's latest post, regardless of which computer you viewed it on? How exactly does it store that?

I know that logically it would store it on the Database, but I'm curious as to the actual implementation. It seems to me that storing every single topic you viewed it and when would take up huge numbers of rows, even for a small number of people, like say 100. If you have a forum with 1000's of people, each viewing even 3 topics a day, you're record numbers would be huge, slowing down the database. And calling your last viewed time for each and ever topic? Wouldn't that slow down the code excecution heaps?

If you have any input, I'd love to hear it. It's a question I've been wrestling with in the back of my mind for a few years now

i installed the most popular chat mod on smf forums called ajax chat. i am certain i did everything correctly.
but when i try to test it i get a 403 on byethost. ive also had problems with phpbb
this must mean that byethost must not allow ajax
does anyone know of a server that will allow me to use this mod?

I have asked this question in 3 different places but I get no answers lol. I hope to find some help here.   i want to only display user role for keymaster and moderator users. I don't want every participant to have their role shown , only the keymaster and moderators are important enough to me to show their role next to their avatar. The following function code i found, and used... It worked but has some issues:

function role_show () {
$displayed_user = bbp_get_reply_author_id() ;
$role = bbp_get_user_role( $displayed_user);
if ( bbp_is_user_keymaster($displayed_user) ||$role == 'bbp_moderator') $args['show_role'] = true ;
else $args['show_role'] = false ;
return $args ;
}
add_filter ('bbp_before_get_reply_author_link_parse_args', 'role_show' )

Code Issues: On the Forums topic post lists, This code also removes the avatar from showing in the same cell section as the “last post by” . And it removes the “last post by” name in this same section. How can I fix this ? If needed, I could implement this code again and provide a link to the error so you can see. Thank you for any help.       Side notes: Someone told me to try

function role_show ($args) {

As my first line , but it did not work. It resulted in the following screenshot :   as

Attached Files  functions-picture.png   35.46KB   0 downloads

Hi guys

I found a nice script that removes all the work of writing individual embedding for a long list of video host, it works well and pretty easy to be tweaked even by non coders such as me. One problem seems to be that some host have that annoying autostart or autoplay feature when a person places a link to a forum.  So if you have a forum page with multiple urls for videos that auto start or play feature drives you nuts.

I have tried to tweak the code by adding a param name= and used the 0 token and the false alpha word, still no luck with vimeo, it continues to start as soon as it finishes loading.  This code block shows the script file for vimeo, there are only two files in my includes to run this script so both must be tweaked with the changes, I use the nifty free PSPad editor to do this and have no trouble making any changes needed.

My question is at what level can an option like disabling a feature take place, is this something that must be performed by the host or can this script actually take a param name= to disable it. 

Thanks for any input or advice, pointing to a good read is most welcome also.

Code: [Select]
if (($vimeo) && (strpos($message, 'www.vimeo.com/') !== false)){
$message = preg_replace('#<a class="postlink" href="http:\/\/www.vimeo.com\/(.*?)">(.*?)<\/a>#U', '<object type="application/x-shockwave-flash" style="width:400px;height:230px;" data="http://vimeo.com/moogaloop.swf?clip_id=$1&amp;server=vimeo.com&amp;show_title=1&amp;show_byline=1&amp;show_portrait=0&amp;color=&amp;fullscreen=1"><param name="allowfullscreen" value="true" /><param name="allowscriptaccess" value="always" /><param name="movie" value="http://vimeo.com/moogaloop.swf?clip_id=$1&amp;server=vimeo.com&amp;show_title=1&amp;show_byline=1&amp;show_portrait=0&amp;color=&amp;fullscreen=1" /></object>', $message);}

I got a question im using izabi for me im one who loves the software. But there some quirks that they forgot to add when making the mail system. I was wondering how it would be possible to code in a peice of php where it says read after someone read the email. If you need a copy of the mail mail script let me know.

Hey Guys. I am working with a form that shows the grand total on the checkout page. The value of the grand total is inside a hidden field. When click on  submit, the _POST array doesn't get back the last value of the grand total. I need to hit the button twice to get the last value. The weird thing is when I  echo the value of the grand total it display the latest value, but not with the POST array   For example. If the grand total is $10.00 and I click on submit. It will show the POST['grand_total'] as empty. If I click on submit again it will show the grand total of $10.00. Below is my code that I am working with. Any help would be really appreciated.

if(isset($_POST['submit'])) {
/* Doesn't show if i put it after if($_POST['submit'] */
if(isset($_POST['grand_total'])) {
echo $_POST['grand_total'];
}

}

//A bunch of other html/php code. Another class calculates the subtotal assigns it the variable $subtotal



$cart_totals = new cartTotals($subtotal, $discounted_amount,$post_values->tip); // Cart class is shown below

/* Doesn't show if i put it before if($_POST['submit'] */
if(isset($_POST['grand_total'])) {
echo $_POST['grand_total'];
}
echo  "<input name='grand_total' type='hidden' value='$cart_totals->grand_total'  />"; // Shows the grand total after second from submission
echo "$cart_totals->grand_total"; // Shows grand total after the first submission

Cart Totals Class

class cartTotals  {

	public $subtotal;
	public $sales_tax;
        public $tip;
	public $grand_total;
        public $discount_amount;
	public $href_page;
	public $invalidCouponMessage;
	const  TEST_ENVIORMENT = FALSE;


	/**
	 * [ Function gets constructed in the order summary where the [$discount_amount= ""]  arg does need to be passed.
     * But does get passed in when called on the checkout.php page. Therefore we set the default value to an empty string.]
	 * @param [float] $subtotal   [subtotal get passed in from the parent class coreCartFunction]
	 * @param string $discount_amount [The class checkCouponCode calculates this discount amount based on the
     * subtotal and the discount amount. It gets instantiated on the clients side and passed is this construction function.
     * This is all done on the checkout page.]
	 */

    /*The way the construct function works is by invoking all the methods the passed arguments
    When the methods get invoked the do all the work and set the properties its values. The properties then get echoed out
    on the client side.  */
	
    function __construct($subtotal="", $discount_amount= "", $tip=""){
    
    $this->subTotal($subtotal, $discount_amount);//SubTotal method takes the discount amount and subtracts it from the subtotal.
    $this->salesTax($subtotal, $discount_amount);
    $this->tip = $tip;
    $this->grandTotal();
	}

    private function subTotal($subtotal,$discount_amount) {

            $rounded_subtotal = round($subtotal-$discount_amount,2);
            $money_format_subtotal =  money_format('%i',$rounded_subtotal);
            $this->subtotal = $money_format_subtotal;
    }


    private function salesTax($subtotal, $discount_amount =""){
	$sales_tax = (STORE_SALES_TAX)?(float)STORE_SALES_TAX:8.875;
	$sales_tax =(($this->subtotal)*$sales_tax)/100;
	$sales_tax = round($sales_tax,2);
	$this->sales_tax = $sales_tax;
	}


	public function Tip() {
    //global $post_values;
    //$last_tip_selected = $post_values->tip > 0 ? $post_values->tip : "" ;
	$tip_output = "<select id='tip' name='tip'>";
 	for($tip=0.00; $tip<=11.75; $tip+=0.25){
 	if( $tip == "2") {$selected = " selected";} else {$selected ="";}
       $formatted_tip =  money_format('%i',$tip);

	$tip_output .= "<option {$selected} id='selected_tip' value='$formatted_tip'>"."$".$formatted_tip ."</option>".PHP_EOL;
		}

		$tip_output .= "</select>";
		return $tip_output;

    }

    private function grandTotal(){
        $grand_total = round($this->sales_tax+$this->subtotal+$this->tip,2);
        $grand_total_formatted =  money_format('%i',$grand_total);
        $this->grand_total = $grand_total_formatted;

    }