PHP - Auto Nested Categories From Flat File

I want to make the news feed on my website easier to maintain. I just created a form that I will use to add the information. The form saves the files that it creates as "entry-date-time.txt" and places it in a folder for the year and a sub folder for the month. Such as "2011\09".

I have displayed data from a single flat file before, but I am unsure how to go about displaying the data from multiple files. Can anyone show me an example?

I want to be able to paginate the data, displaying a number of updates per page from newest to oldest.

I don't have MySQL access on the server or I'd just use that, instead.

I currently have a flat file user registration and login in system. I also have a simple guestbook which i didn't code myself, the guest book currently requires the user to type in there name and e-mail address to make a post. how ever i would like them to have to login and if they aren't logged in then don't display the guestbook.

Live version:
B50crew.co.uk

Guestbook.php:
Code: [Select]
<?php
  // find out the domain:
  $domain = $_SERVER['HTTP_HOST'];
  // find out the path to the current file:
  $path = $_SERVER['SCRIPT_NAME'];
$url = "http://" . $domain . $path  ;
extract($_POST);
if($Submit){
$date = date('D d Y h:i');

$comment=eregi_replace("\r\n","*",$comment);
$comment=eregi_replace("\n","*",$comment);
$fp = fopen("bin/guestbook.nfo","a+");

if(!$fp) {
    echo 'Error: Cannot open file.';
    exit;
}

fwrite($fp, $date."||".$name."||".$email."||".$comment."\n");

fclose($fp);

 }
?>



<div align="center">
  <h2><span class="style1">Guestbook </span><br>
  </h2>
</div>
<form name="form1" method="post" action="<?php echo $url;?>">
  <label>Name
  <input type="text" name="name">
  </label>




  <label>Email
  <input type="text" name="email">
  </label>
  <p>&nbsp;</p>
  <p>
    comment<br>
    <textarea name="comment" cols="40" rows="10"></textarea>

    <br>
    <label>
    <input type="submit" name="Submit" value="Sign">
    </label>
    <br>
    </p>
</form>
<hr>

<?php

$userinfo = file("cgi-bin/guestbook.nfo");

   echo '<table border="0">';

foreach($userinfo as $val)

{
   //explode that data into a new array:
   $data = explode("||", $val);


  echo '<tr><td>'.$data[0].'</td></tr>';
   echo '<tr><td>'.$data[1].' Wrote:</td></tr>';

    $data[3]=eregi_replace("\*","<br>",$data[3]);

   echo '<tr><td>'.$data[3].'</td></tr>';
   echo '<tr><td>Email:'.$data[2].'<hr></td></tr>';
}


   echo '</table>';



 ?>
Login:
Code: [Select]
<?php
  // find out the domain:
  $domain = $_SERVER['HTTP_HOST'];
  // find out the path to the current file:
  $path = $_SERVER['SCRIPT_NAME'];
$url = "http://" . $domain . $path  ;
extract($_POST);
if($Submit){
$date = date('D d Y h:i');

$comment=eregi_replace("\r\n","*",$comment);
$comment=eregi_replace("\n","*",$comment);
$fp = fopen("bin/guestbook.nfo","a+");

if(!$fp) {
    echo 'Error: Cannot open file.';
    exit;
}

fwrite($fp, $date."||".$name."||".$email."||".$comment."\n");

fclose($fp);

 }
?>



<div align="center">
  <h2><span class="style1">Guestbook </span><br>
  </h2>
</div>
<form name="form1" method="post" action="<?php echo $url;?>">
  <label>Name
  <input type="text" name="name">
  </label>




  <label>Email
  <input type="text" name="email">
  </label>
  <p>&nbsp;</p>
  <p>
    comment<br>
    <textarea name="comment" cols="40" rows="10"></textarea>

    <br>
    <label>
    <input type="submit" name="Submit" value="Sign">
    </label>
    <br>
    </p>
</form>
<hr>

<?php

$userinfo = file("cgi-bin/guestbook.nfo");

   echo '<table border="0">';

foreach($userinfo as $val)

{
   //explode that data into a new array:
   $data = explode("||", $val);


  echo '<tr><td>'.$data[0].'</td></tr>';
   echo '<tr><td>'.$data[1].' Wrote:</td></tr>';

    $data[3]=eregi_replace("\*","<br>",$data[3]);

   echo '<tr><td>'.$data[3].'</td></tr>';
   echo '<tr><td>Email:'.$data[2].'<hr></td></tr>';
}


   echo '</table>';



 ?>
Session.php

<?php
class user {
    var $file_dir = "";
     
    function start($time = 3600) {
        session_set_cookie_params($time , '');
        session_name('afroxav-login');
        session_start();

         // Reset the expiration time upon page load
        if (isset($_COOKIE['afroxav-login'])) {
            setcookie('afroxav-login', $_COOKIE['afroxav-login'], time() + $time, '', 'localhost', 0, 1);
        }

        if (!isset($_SESSION['info'])) {
            $this->data = array('name' => 'Anonymous', 'logged' => false);
        } else {
            $this->data = $_SESSION['info'];
        }
    }

    function check_login() {
        if ($this->data['logged'] !== true) {
            return false;
        } else if ($this->data['logged'] === true) {
            if ($this->data['name'] !== 'Anonymous') {
                return true;
            }
            return false;
        }
        return false;
    }

    function login($user, $pass) {
        $logins_raw = @file_get_contents($this->file_dir . 'users.php');
        $logins_processed = str_replace('<?php exit; ?>', '', $logins_raw);
        $logins_array = explode('\n', $logins_processed);
        foreach ($logins_array as $id => $line) {
            $logins[$id] = explode('|', $line);
        }
        $pass = $this->hash_pass($pass);

        foreach ($logins as $user_info) {
            if ($user_info[1] == $user) {
                if ($user_info[2] == $pass) {
                    $this->update_session($user_info);
                    return true;
                }
            }
        }

        return false;
    }

    function hash_pass($string) {
        return hash('sha512', $string);
    }

    function logout() {
        $_SESSION['info'] = array('name' => 'Anonymous', 'logged' => false);
        $this->data = $_SESSION['info'];
        return true;
    }

    function prep_reg_array($name, $pass, $email, $mod = 'false', $admin = 'false') {
        $id_raw = @file_get_contents($this->file_dir . 'id.php');
        $id = str_replace('<?php exit; ?>', '', $id_raw);
        $id = $id + 1;
        @file_put_contents($this->file_dir . 'id.php', '<?php exit; ?>' . $id);
        return array($id, $name, $this->hash_pass($pass), $email, $mod, $admin);
    }

    function register($userdata) {
        $write = file_put_contents($this->file_dir . 'users.php', '\n' . implode('|', $userdata), FILE_APPEND);
        return ($write !== false) ? true : false;
    }

    function update_session($array) {
        $_SESSION['info'] = array(
            'id'        => $array[0],
            'name'        => $array[1],
            'pass'        => $array[2],
            'email'        => $array[3],
            'mod'        => $array[4],
            'admin'        => $array[5],
            'logged'    => true
        );
        $this->data = $_SESSION['info'];
    }
};

//html related functions
//not related at all with the sessions
function html_start($title) {
    header('Content-type: text/html');

    echo "<html>\n";
    echo "<head>\n";
    echo "<title>\n";
    echo $title;
    echo "</title>\n";
    echo "</head>\n";
    echo "<body>\n";
    echo "<h1>\n";
    echo $title;
    echo "</h1>\n";
}

function html_nav() {
    global $user;
     
    echo "<div>\n";
    echo "Navigation\n";
    echo "<ul>\n";
    echo "<li><a href=\"?page=home\">Home</a></li>\n";
    if ($user->check_login() == true) {
        echo "<li><a href=\"?page=logout\">Log Out</a></li>\n";
    } else {
        echo "<li><a href=\"?page=login\">Log In</a></li>\n";
        echo "<li><a href=\"?page=register\">Register</a></li>\n";
    }
    echo "</ul>\n";
    echo "</div>\n";     
}

function html_end() {
    echo "</body>\n";
    echo "</html>\n";
}
?>

Given this script:

<?php
$file = file('info.txt');
$statelist = array (1=> "California", "Florida", "Illinois", "New York", "Texas");
foreach ($file as $line => $data)
{
list($state, $abbrev, $population) = explode('|', trim($data));
for ($x=1; $x<5; $x++) {
     if ($statelist[$x] == $state) {
echo $state . ", " . $abbrev . " - " . $population . '<br />';
}
}
}
?>

and this flat file (info.txt):

Code: [Select]
California|CA|36,756,666
Texas|TX|24,326,974
New York|NY|19,490,297
Florida|FL|18,328,340
Illinois|IL|12,901,563

This is what is outputted:
Code: [Select]
California, CA - 36,756,666
Texas, TX - 24,326,974
New York, NY - 19,490,297
Florida, FL - 18,328,340
Illinois, IL - 12,901,563
How can I sort the output by the index value of the "statelist array" so get this output:
Code: [Select]
California, CA - 36,756,666
Florida, FL - 18,328,340
Illinois, IL - 12,901,563
New York, NY - 19,490,297
Texas, TX - 24,326,974
Could  ksort($statelist) be implemented?

I have a login system that uses a flat file database.  The flat file is in a directory outside the public_html.  My questions;

1- Is is still possible to hack into that file?

Currently I do not encrypt the passwords as I have been told that having the file outside the public_html makes the file unavailable to the public.  This allows me the advantage of sending the Username and Password to the user in an email if they forget there password or username.  Otherwise- I would have to set up a more complicated method to allow them to change their password to re-gain access to the site.  I have an SSL on the site also so I am not worried about packet sniffing.

Thanks

it is displaying the lastnames in the order they are in the profile but do not know  how to get it to sort by lastname - please help

<?php
$lines = file('database/profile.txt');
foreach($lines as $thisline){list($p_id,$p_status,$p_filestart,$p_filemodified,$p_first,$p_middle,$p_last,$p_nick) = explode('|',$thisline);{
$names []= $p_last.', '.$p_first.' '.$p_middle.'.';
foreach($names as $value);
{echo ''.$value.'<br>';}}}
?>

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=333509.0

 

I am pretty new to php and trying to teach myself.  I can't get the values from this form to write to my flat file called orders.txt:

browse_index.php

<?php 
include("includes/menu_members.php")
?>
<div id="content">

<h1>SHOPPING CART</h1>
<a href="browse_index.php">CLICK HERE TO CONTINUE SHOPPING</a>
  

<?php 

echo '
  <table border="0">
  <tr>
  <td><form id="f2" method="post"name="f2"><input type="submit" action="order_summary.php" name="submit2" value="submit order"></td>
  ';

  if(isset($_POST['submit']))
  {

  $itemname = $_POST['h1'];

  //echo $_SESSION['itemname'][$itemname];
  unset($_SESSION['itemqty'][$itemname]);
  unset($_SESSION['itemprice'][$itemname]);
  unset($_SESSION['itemname'][$itemname]);
  }

  echo "<br/><br/>";
  echo "<table border='8' bgcolor='#efefef'>";
  echo "<tr><th>Name</th><th>Quantity</th><th>Price</th><th>Subtotal</th></tr>";
  foreach($_SESSION['itemname'] as $key=>$value)
{

echo
'<tr><td><b>'.$_SESSION['itemname'][$key].'</b></td>
<td>'.$_SESSION['itemqty'][$key].'</td>
<td>$'.$_SESSION['itemprice'][$key].'</td>
<td name="subtotal">$'.($_SESSION['itemqty'][$key] * $_SESSION['itemprice'][$key]).'</td>
<td><form id="f1" method="post" name="f1"><input type="submit" name="submit" value =
"delete"><input type="hidden" name="h1" value='.$key.'></td></tr>'
;

}
  
?>


order_summary.php:

<?php
session_start ();

$date = date ("H:i jS F");

$outputstring = $date."/t"

.$_POST['h1']. ":"

.$_SESSION['itemqty'][$key]. ":"

.$_SESSION['subtotal'][$key]. ":"

."\n";

$fp = fopen("orders.txt","a");

fwrite($fp, $outputstring);

fclose($fp);
?>

Can someone direct me where I am going wrong???

Hello Guys,

Need a little help here. I have a db structure like this

cat_id |  cat_name | cat_status | parent_id
1        First Test         1                  0
2        Just testing       1                    0
4        Books               1                    2
5        Cars               1                    0
6        Ford               1                  5

If the parent_id = 0 it is considered to be the parent.
If it is a number it is considered a child and referencing the parent

I want to be able to query the database and grab the cat and the sub cat and echo it on my page. Its like a classified ads application.

Here is my while loop that I currently have which only echo's out the parent category. I would like to echo the child category under the respective parent category.

I think I would have to do a loop within a loop, but not sure how to do it..


$query  = "SELECT * FROM ad_category WHERE cat_status='1' && Parent_id='0' ORDER BY cat_name";
$result = mysql_query($query);

while($row = mysql_fetch_row($result))
{
   
    $cat_name = $row[1];
    

$cupper = UCWords($cat_name);

    echo $cupper . "<br>" ;
    
        
} 




Thanks for your help in advance

I have been going in circles about how to handle the issue that I have come up with and was hoping that someone could provide a different method. Basically I want to be able to create an infinite number of categories and allow them to be assigned to other categories then making them subcategories/sub sub categories if you will. My initial plan was to use a method I have used before by just saving the parent id of the subcategories and recursively going through the data. However, I am not to fond of this because of the inefficiency that it provides. I did some research and found that method is called the "Adjacency List". I also found another way to do it called "Nested Sets" which seems to be much more efficient but its a little harder to understand / maintain. I was hoping that someone here could offer alternatives to both of these methods that will allow me to keep the efficiency of "Nested Sets" but providing the ease of use / maintenance of the "Adjacency List".

Thanks in advance for any help.

Hi,

Please help

I need to make categories with su-categories
I made in my database tables like this

table = categories

cid      |     cat_id    |   parent_list    | categ_name                 | type
1               0                   1                  General category            c
2               1                   1,2               sub category                   s
3               1                   1,3               sub category                   s
4               1                   1,2               sub category                   s
5               1                   1,5               sub category                   s
6               5                   1,5,6            sub sub category            s
7               0                   7                  General category2          c
8               7                   7,8               sub category                   s

I need to view this in dropdown menu using parent_list column

hi,
i looking for a way to use a auto fill for a inputbox text
but all that i found is using a mysql bd.
there is any solution using a txt file? stored in server.
thanks a lot for your help

Hey Everyone,

I'll start by saying that I am a very novice php programmer. But I am working on a file storage website, and I have it working and running properly, what you see here is on a new page called index2.php (Thought you might need to know) and full working version can be found here, http://www.jstpreview.net84.net now want I want the site to do is automatically generate a new .php or .html page once the user presses the "submit" button, I've looked through many tutorials to figure this out but anything I have tried so far didn't work. So anyways, the page generated should be named the name of the file uploaded plus the extension. I also want this page to be generated using a pre-uploaded template but if you look at the code, you will see that I havn't implemented that part yet.

Code: [Select]
<?php 
//Load the settings
require_once("settings.php");


$message = "";
//Has the user uploaded something?
if(isset($_FILES['file']))
{

$target_path = Settings::$uploadFolder;
$target_path = $target_path . time() . '_' . basename( $_FILES['file']['name']); 

//Check the password to verify legal upload
if($_POST['password'] != Settings::$password)
{
$message = "Invalid Password!";
}
else
{
//Try to move the uploaded file into the designated folder
if(move_uploaded_file($_FILES['file']['tmp_name'], $target_path)) {
    $message = "The file ".  basename( $_FILES['file']['name']). 
    " has been uploaded";
} else{
    $message = "There was an error uploading the file, please try again!";
}
}

//Clear the array
unset($_FILES['file']);
}



if(strlen($message) > 0)
{
$message = '<p class="error">' . $message . '</p>';
}

/** LIST UPLOADED FILES **/
$uploaded_files = "";

//Open directory for reading
$dh = opendir(Settings::$uploadFolder);

//LOOP through the files
while (($file = readdir($dh)) !== false) 
{
if($file != '.' && $file != '..')
{
$filename = Settings::$uploadFolder . $file;
$parts = explode("_", $file);
$size = formatBytes(filesize($filename));
$added = date("m/d/Y", $parts[0]);
$origName = $parts[1];
$filetype = getFileType(substr($file, strlen($file) - 3));
        $uploaded_files .= "<li class=\"$filetype\"><a href=\"$filename\">$origName</a> $size - $added</li>\n";
}
}
closedir($dh);

if(strlen($uploaded_files) == 0)
{
$uploaded_files = "<li><em>No files have been uploaded yet!</em></li>";
}

function getFileType($extension)
{
$images = array('jpg', 'gif', 'png', 'bmp');
$docs  = array('txt', 'rtf', 'doc');
$apps  = array('zip', 'rar', 'exe');

if(in_array($extension, $images)) return "Images";
if(in_array($extension, $docs)) return "Documents";
if(in_array($extension, $apps)) return "Applications";
return "";
}

function formatBytes($bytes, $precision = 2) { 
    $units = array('B', 'KB', 'MB', 'GB', 'TB'); 
   
    $bytes = max($bytes, 0); 
    $pow = floor(($bytes ? log($bytes) : 0) / log(1024)); 
    $pow = min($pow, count($units) - 1); 
   
    $bytes /= pow(1024, $pow); 
   
    return round($bytes, $precision) . ' ' . $units[$pow]; 
} 

?>

<!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=ISO-8859-1" />
<style type="text/css" media="all">
@import url("style/style.css");
</style>
<script src="http://code.jquery.com/jquery-latest.js"></script>
<title>JetStorm Technologies | Staff - CloudNet</title>
</head>
<body>

<div id="container">


<h1></h1>

<form method="post" action="index.php" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="15728640" />
<fieldset>
<legend>Add a new file to CloudNet:</legend>
<?php echo $message; ?>
<p><label for="name">Select file:</label><br />
<input type="file" name="files" /></p>
<p><label for="password">Authentication for upload:</label><br />
<input type="password" name="password" /></p>
<p><input type="submit" name="submit" value="Start upload" /></p>


</fieldset>
</form>
<fieldset>

<center>

<?php

if(isset($_FILES['file']));
//else $file=1;
$file = $_POST["$origName"]; // grabbed from the form
$file = fopen("filepages/" . $origName .".php","x"); //(Creates the file)
fwrite($out, "<p> Man this really does not work $origName</p>"); // Generates the contents of file

?>
</center>

</fieldset>

<fieldset>
<legend>Previousely uploaded files</legend>
<ul id="menu">
<li><a href="">All files</a></li>
<li><a href="">Documents</a></li>
<li><a href="">Images</a></li>
<li><a href="">Applications</a></li>
</ul>

<ul id="files">
<?php echo $uploaded_files; ?>
</ul>
</fieldset>

</div>

<script src="js/filestorage.js" />
</body>
</html>
I would greatly appreciate it if someone can point out and fix the errors in this code, but it would be even more appreciated if someone could provide a working source code of auto-generation of pages on form submit.

Thanks in advanced

Hello all.  In lack of better terms, I am a programming noobie when it comes to designing code.  I can look at a code and figure it out, but basically I am trying to figure this out.  I host a website from home, running on a server 2008 machine, with apache/php, basically to share files from home, work, friends house, wherever I need.  I do have a FTP for this, but I also want to be able to upload files via http.  I actually want to be able to set a time or date that the file will auto-delete.  Such as, I select a file from my local machine, set the deletion time to 1 hour/60 minutes/3600 seconds, whatever, upload it to the site, and it spit back a url that I can access that file for that set amount of time.  It would be great to implement something like bit.ly to shorten the link, or even something to randomize the link.  Any ideas on that from anyone?  Willing to donate (paypal) a little bit if someone can actually help me out, or point me in the right direction.  A week on google has proved useless. 
Thanks so much.

$connet = mysql_connect("host", "db_username", "pass") or die(mysql_error());
 
$user = $_SESSION['SESS_FIRST_NAME'];
mysql_select_db('db_name, $connet) or die(mysql_error());

mysql_query("SELECT members Get $earn='earned' WHERE $user='username' LIMIT 1;");
$earn = $total_earn;
?>
<a>$<?php echo "$total_earn";?></a>

Hi guys, is there anyway to process this $result from a mysql query inside PHP so that the data below will be formatted to a pivot-like table? The number of rows and columns of the output 'table' will be indefinite. Thanks so much!

Data:
ID   Row   Col   Name
1   1   A   A1
2   2   A   A2
3   3   A   A3
4   1   B   B1
5   2   B   B2
6   3   B   B3
7   1   C   C1
8   2   C   C2
9   3   C   C3


Results:
A1(1)   A2(2)   A3(3)
B1(4)   B2(5)   B3(6)
C1(7)   C2(   C3(9)