PHP - Moved: Get All Articles From Parent Category

This topic has been moved to PHP Applications.

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

This topic has been moved to PHP Applications.

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

Hi everyone,

I'm making an admin page which will contain a number of articles. Unlike most sites, these articles won't be ordered based on date, but however the admin wishes.

To do this I've added an order column to the mysql, in the admin page all the articles are displayed and next to them a text input, with the value set to their current order number (1,2,3, 4 etc)

Here's selections of the code



<?php

$o = $_GET['o'];

if($o == 'new') {

$order1 = $_POST['order1'];

$update = "UPDATE `content` SET `order` = '$order1' WHERE `id` = '1'";

$result=mysql_query($update) or die(mysql_error());

}
?>

<form method="post" action="?o=new" name="order_form">

<!-- CONTENT -->

<div id="content">
<?php
$sql="SELECT * FROM `content` ORDER BY `order` ASC";
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){
?>
<ul>
<li class="article_left">
<input type="text" value="<?php echo $rows['order']; ?>" name="order<?php echo $rows['id']; ?>" class="order">
</li>
<li class="article_left_title">
<?php echo $rows['title']; ?>
</li>
<li <?php if ($rows['live'] == '1') { echo 'class="live"'; }else echo 'class="launch"'; ?>>
<?php if ($rows['live'] == '1') {
echo 'Now Live';
}else {
echo 'Launch';
}
?>
</li>
<div class="clear"></div>
</ul>
<?php
}
?>
</div>

<!-- END CONTENT -->

<div id="submit_order">
<input type="submit" name="submit" value="Submit Re-Order">
</div>

</form>



My problem is hard to explain, but as you can tell $update only does it for the first article. How can I make it change the `order` column for all the articles.

Feel free to ask more questions. Would really appreciate any help!

Howdy colleagues,   I have a history blog where I post, well, history related essays of my own. I'd like to store the articles in .md or .txt document in my GitHub profile. My question is, would these articles get indexed by Google, since I want them to be original for my blog?   Thank you!   Stef

Hi again PhpFreakz, yet again I have some issues with my PHP part of my website.

Is there any simple algorithm to summarize web news articles in PHP?

Im running a website about health and foods. I would like that at the end of each article, it shows other related articles that I have on my website. Im relatively new with php and mysql so I figure I have to put every page onto a database table.    I looked already everywhere but all I found is how to do with wordpress. But i'm not using anything like that.  I made the website myself with css and html and php.    Can somebody help me with a website where they explain how to do?   Also I would like that automatically it shows my latest articles in a sidebar. Without anytime adding myself manually.   Can anybody help me? 

I'm using the fairly simple below code to output a list of the latest articles, but I'm wanting (not sure if it's possible) to display the articles from the current day in bold so users recognise that they are new and the older ones non-bold.

I've tried a few things, but they're not giving the desired results.

Code: [Select]
<?php
$con = mysql_connect("localhost","xxx","xxx");
if (!$con)
   {
   die('Could not connect: ' . mysql_error());
   }

mysql_select_db("xxx", $con);

$result = mysql_query("SELECT * FROM `articles` WHERE `quotes` NOT LIKE '%yes%' ORDER BY `date` DESC limit 0,14");

echo "<table class='links' border='0' width='100%'>";

while($row = mysql_fetch_array($result))
{
echo '<tr><td width="270" valign="top"><h4>&raquo; <a href="news/display/'.$row['id'].'">'.$row['title'].'</a></td><td width="40" valign="top"><span class="small">'.date("M d", strtotime($row['date'])).'</span></h4></td></tr>';
}

mysql_close($con);
?>
Cheers!

I have a full-text RSS component for Joomla that I was trying to modify. I wanted to be able to truncate the article to a given number of words and place a link at the end for the rest of the article. I need help figuring out how to add a link to the end of the source article.

Added this script to the post.php file. It sort of works but the "$ending" tag doesn't seem to function since there is no "..." appended to the end of articles posted, when I tested it.
public function truncate($text, $length = 200, $ending = '...', $exact = true, $considerHtml = false) {
if ($considerHtml) {
// if the plain text is shorter than the maximum length, return the whole text
if (str_word_count(preg_replace('/<.*?>/', '', $text)) <= $length) {
return $text;
}
// splits all html-tags to scanable lines
preg_match_all('/(<.+?>)?([^<>]*)/s', $text, $lines, PREG_SET_ORDER);
$total_length = str_word_count($ending);
$open_tags = array();
$truncate = '';
foreach ($lines as $line_matchings) {
// if there is any html-tag in this line, handle it and add it (uncounted) to the output
if (!empty($line_matchings[1])) {
// if it's an "empty element" with or without xhtml-conform closing slash (f.e. <br/>)
if (preg_match('/^<(\s*.+?\/\s*|\s*(img|br|input|hr|area|base|basefont|col|frame|isindex|link|meta|param)(\s.+?)?)>$/is', $line_matchings[1])) {
// do nothing
// if tag is a closing tag (f.e. </b>)
} else if (preg_match('/^<\s*\/([^\s]+?)\s*>$/s', $line_matchings[1], $tag_matchings)) {
// delete tag from $open_tags list
$pos = array_search($tag_matchings[1], $open_tags);
if ($pos !== false) {
unset($open_tags[$pos]);
}
// if tag is an opening tag (f.e. <b>)
} else if (preg_match('/^<\s*([^\s>!]+).*?>$/s', $line_matchings[1], $tag_matchings)) {
// add tag to the beginning of $open_tags list
array_unshift($open_tags, strtolower($tag_matchings[1]));
}
// add html-tag to $truncate'd text
$truncate .= $line_matchings[1];
}
// calculate the length of the plain text part of the line; handle entities as one character
$content_length = str_word_count(preg_replace('/&[0-9a-z]{2,8};|&#38;#[0-9]{1,7};|[0-9a-f]{1,6};/i', ' ', $line_matchings[2]));
if ($total_length+$content_length> $length) {
// the number of characters which are left
$left = $length - $total_length;
$entities_length = 0;
// search for html entities
if (preg_match_all('/&[0-9a-z]{2,8};|&#38;#[0-9]{1,7};|[0-9a-f]{1,6};/i', $line_matchings[2], $entities, PREG_OFFSET_CAPTURE)) {
// calculate the real length of all entities in the legal range
foreach ($entities[0] as $entity) {
if ($entity[1]+1-$entities_length <= $left) {
$left--;
$entities_length += str_word_count($entity[0]);
} else {
// no more characters left
break;
}
}
}
$truncate .= substr($line_matchings[2], 0, $left+$entities_length);
// maximum lenght is reached, so get off the loop
break;
} else {
$truncate .= $line_matchings[2];
$total_length += $content_length;
}
// if the maximum length is reached, get off the loop
if($total_length>= $length) {
break;
}
}
} else {
if (str_word_count($text) <= $length) {
return $text;
} else {
$truncate = substr($text, 0, $length - str_word_count($ending));
}
}
// if the words shouldn't be cut in the middle...
if (!$exact) {
// ...search the last occurance of a space...
$spacepos = strrpos($truncate, ' ');
if (isset($spacepos)) {
// ...and cut the text in this position
$truncate = substr($truncate, 0, $spacepos);
}
}
// add the defined ending to the text
$truncate .= $ending;
if($considerHtml) {
// close all unclosed html-tags
foreach ($open_tags as $tag) {
$truncate .= '</' . $tag . '>';
}
}
return $truncate;
}



I have attached the whole file as well if you want to see the rest.



This part of the script has the function that originally automatically added the link to the source article:

if($link_original==1){
if(strlen($ret->fullText))
$ret->fullText.="<p><a href='". $item->link."' target='_blank'>".$text_link_original."</a></p>";
else
$ret->introText.="<p><a href='". $item->link."' target='_blank'>".$text_link_original."</a></p>";
}

The problem is that it gets truncated with the rest of the article now.

An array of "categories" is given:

    $categories = array(
        array("id" => 1, "title" => "Pants", "children" => array(
            array("id" => 2,
                "title" => "Boots",
                "children" => array(
                    array("id" => 3, "title" => "Leather"),
                    array("id" => 4, "title" => "Textile"),
                ),
            ),
            array("id" => 5, "title" => "Sneakers"),
        ),
        ),
        array(
            "id" => 6,
            "title" => "Sort",
            "children" => array(
                array(
                    "id" => 7,
                    "title" => "Balls",
                ),
            ),
        ),
    );

I need to write a function searchCategory ($categories, $id) that returns the name of the category by the category ID.

Help me please.

So I am having some difficulties with a category system. I want my code to search the database an unlimited amount of times to the very last directory and then display it in tree view on my screen. I'm having some trouble because I am having to specify how many depths the code will search. How can I get it to do this on it's own? Currently my code does this...
 

<?php
// Establish SQL Connection.

$mysqli			=	mysqli_connect( $sql['host'], $sql['user'], $sql['pass'], $sql['db'] ) or die( "DARN");
$query			=	$mysqli->query( "SELECT * FROM folders ORDER BY name ASC" );
$num_rows	=	$query->num_rows;


echo "Found <b>" . $num_rows . "</b> row(s) in the database!<br>";


	while ( $row = mysqli_fetch_array( $query ) )
	{
		// DO NOT REMOVE
		$id		=	$row['id'];
		$name	=	$row['name'];
		$parent	=	$row['parent'];
		
		/***************************************************************************************************/
		
		if ( $parent == 0 )
		{
			echo $id . " " . $name . " " . $parent . "<br>";
			
			$query2	=	$mysqli->query( "SELECT * FROM folders WHERE parent = " . $id . " ORDER BY name ASC" );
			
			while ( $row2 = mysqli_fetch_array( $query2 ) )
			{
				echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" . $row2['name'] . "<br>";
			}
		}
	}
?>

I know it's messy, doing the best I can.     DB looks a little like this...   +----+---------+--------+

Hope I am in the right area.  I am working on a project which is sort of a business directory.  I have a category table, a sub-category table then the actual account table.  So a user clicks on the category, then selects the sub-category to view information of accounts in that category, and then be able to click to see the full profile.  Here's where I am getting stuck.  A user may be listed in more than one sub.  As an example, let's say a parent is Cars, then subs might be New, Used, Parts, etc.  Now a particular user might be listed under all three subs.  How can I link them?  I have my cat/sub linked via parent/child id's.  However, how can I get the user to be linked to multiple subs?  Would I need to create a separate table to do similar to parent/child of the categories?  If so, then how would I insert the multiple id's into the table?  I assume at this point that I would use drop downs for the subs.  I am having a real hard time wrapping my head around this so any help is greatly appreciated.

I have the following result that I am getting from a source.

Code: [Select]
SimpleXMLElement Object
(
    [CategoryID] => 1
    [Name] => Other
    [Order] => 0
    [link] => http://www.link.com?sub=1
)

SimpleXMLElement Object
(
    [CategoryID] => 1233916011
    [Name] => ceramic
    [Order] => 1
    [ChildCategory] => SimpleXMLElement Object
        (
            [CategoryID] => 1234016011
            [Name] => dish
            [Order] => 1
        )

    [link] => http://www.link.com?sub=13476
)

SimpleXMLElement Object
(
    [CategoryID] => 1233917011
    [Name] => laminate
    [Order] => 2
    [link] => http://www.link.com?sub=98247
)

I need to get it into a database with the following structure

Code: [Select]
id  categoryID  cName  cOrder  clink  cparent 

By using
Code: [Select]
foreach($this->resp->Store->CustomCategories->CustomCategory as $cat) {
$sub = $cat->CategoryID;
$ord = $cat->Order;
$linkto = "$stlink?fsub=$fsub";
$nm = htmlspecialchars($cat->Name);
$par=$cat->ChildCategory->Order;
$query = "INSERT INTO Cat (categoryID,cName,cOrder,clink,cparent) VALUES ('$sub','$nm','$ord','$linkto','$par')";
$result = @mysql_query ($query); // Run the query.
}

I can get
Code: [Select]
id   categoryID   cName   cOrder  clink                          cparent
1    1            Other   0       http://www.link.com?sub=1      0
2    1233916011   ceramic 1       http://www.link.com?sub=13476  0
2    1233917011   laminate 2      http://www.link.com?sub=98247  0
But I need to get the ChildCategory in there w/ cparent like
Code: [Select]
id   categoryID   cName   cOrder  clink                          cparent
1    1            Other   0       http://www.link.com?sub=1      0
2    1233916011   ceramic 1       http://www.link.com?sub=13476  0
3    1234016011   dish    1                                      1  <--- like this
4    1233917011   laminate 2      http://www.link.com?sub=98247  0
any help appreciated...

I have created a form which allows people to add data to a database.  However, I want to replicate the form across several pages and give each page a category.

For example, if I have a website based on sport.  I have a page which enters information into the baseball category, a page which enters information into the ice hockey category, a page which enters information into the soccer category etc.

Can someone advise how I would do this?

I'm trying to make one big array with my websites menu that has the categorys and the products i'm using code i found at http://www.phpfreaks.com/forums/index.php?topic=326419.msg1536842#msg1536842

its working fine till i try get the sub category and its products into the array


$cats = array( 0 => array( 'categoryID' => 1, 'name' => 'Menu', 'parent' => 0)

   ,1 => array( 'categoryID' => 50, 'name' => 'Takeaway', 'parent' => 60)

  ); //root of the category
$categorys = array( 1 => array(

 1 => array( 'categoryID' => 6 , 'name' => 'Breads' , 'parent' => 1 )

   

,0 => array( 'categoryID' => 2 , 'name' => 'Drinks' , 'parent' => 1 )

,2 => array( 'categoryID' => 7 , 'name' => 'Salads' , 'parent' => 1 )

)

    ,2 => array(

0 => array( 'categoryID' => 4 , 'name' => 'Tea' , 'parent' => 2 )

,1 => array( 'categoryID' => 18 , 'name' => 'Coffee' , 'parent' => 2 )

)

); // the category themselfs
$product = array(6 => array(

0 => array('productID' => 1, 'categoryID' => 6,'name' => 'Plain Bread', 'description' => 'description')

,1 => array('productID' => 2, 'categoryID' => 6, 'name' => 'Garlic Bread', 'description' => 'description')

)

 ,7 => array(

0 => array('productID' => 44, 'categoryID' => 7, 'name' => 'Garden Salad', 'description' => 'description')

,1 => array('productID' => 45, 'categoryID' => 7, 'name' => 'Greek Salad', 'description' => 'description')

)

 ,4 => array(
            

0 => array('productID' => 74, 'categoryID' => 4, 'name' => 'Green Tea', 'description' => 'description')

)

 ,18 => array(
            

0 => array('productID' => 75, 'categoryID' => 18, 'name' => 'Espresso', 'description' => 'description')

)

 ); // the products
if(is_array($cats)) {

    foreach($cats as $cat) {

      if(is_array($categorys[$cat['categoryID']])) {

  
            foreach($categorys[$cat['categoryID']] as $category) {

if(is_array($categorys[$category['categoryID']])) {

foreach ($categorys[$category['categoryID']] as $subcat){

$subcat['product'] = $product[$subcat['categoryID']];

$subprod[] = $subcat; //have tryed using parent $subprod[$subcat['parent']] but it over rides it self each time

}

}

 $category['product'] = $product[$category['categoryID']];

 
             $category['subcategory'] = $subprod; // here is where I'm having problem

 $this_category[] = $category;
            }
        }

if(!empty($this_category)){

$ncategory[]    = array($cat,$this_category);

}

$this_category        = array();
    }

  
}
print_r($ncategory); 


thank you for your time sorry for any spelling or grammar errors