PHP - How To Show Related Articles On My Website

I want to show different content to different users from different states. So, if a visitor is visiting the website from California, I want to show California content. Likewise, if a user is visiting from any other State (say NY, Chicago, or anywhere), I want to show content relating to that State. Any suggestions?

Thanks.

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=355205.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?

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.

This topic has been moved to MySQL Help.

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

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!

This topic has been moved to Miscellaneous.

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

All other pages on my browser (Google Chrome) work, but whenever I open up register.php, I get this:

Code: [Select]
Error 324 (net::ERR_EMPTY_RESPONSE): Unknown error.

My register.php code:


<?php

include_once('includes/config.php');
include_once('functions.php');

$return_content = AccountRelated(null, null, 3);

?>

<html>
<head>
<link rel="stylesheet" type="text/css" href="style/style.css" />
<title><?php echo $title; ?></title>
</head>
<body>

<div class="logo"><a href="index.php"><img src="style/images/logo.png"></a></div>

<center>

<div class="background">

<div class="container">

<?php echo $return_content; ?>

</div>

</div>
</center>

</body>
</html>


functions.php


<?php

function AccountRelated($username, $password, $query_type)
{

if($query_type == 1)

{

$set_query = mysql_query("SELECT COUNT(d.username), u.date, u.username FROM uploads d, users u WHERE d.username = '$username' AND u.username = '$username' LIMIT 1") or die(mysql_error());

if(mysql_num_rows($set_query) == 0)

{

$content_return = 'Sorry, no information was found';

}

else

{

$grab = mysql_fetch_assoc($set_query);

//login information

if($grab['COUNT(d.username)'] > 0)

{

$welcome_return = "You have uploaded ". $grab['COUNT(d.username)'] ." files. You've registered on ". $grab['u.date'] ."!";

}

else

{

$welcome_return = "You have uploaded 0 files. You've registered on ".$grab['date'] . "!";

}

}

}

elseif($query_type == 2)

{

$set_query = mysql_query("SELECT title,views,downloads,description,username,date FROM uploads LIMIT 20");

if(mysql_num_rows($set_query) == 0)

{

$content_return = "Sorry, there are currently no files uploaded to view.";

}

else

{

while($row = mysql_fetch_assoc($set_query) == 0)

{

echo $row['title']."<br/>";

}

}

}

elseif($query_type == 3)

{

$username = mysql_real_escape_string($_POST['username']);

$password = md5($_POST['password']);

if(!$username || !$password)

{

$return_content = "All fields are required! <table><form action='register.php' method='POST'>

<tr><td>Username</td><td><input type='text' name='username' maxlength='20'></td></tr>

<tr><td>Password</td><td><input type='text' name='password' maxlength='30'</td></tr>

<tr><td><input type='submit' value='Register'></td></tr>

</form></table>";

AccountRelated($_POST['username'], $_POST['password'], 3);

}

else

{

$set_query = mysql_query("SELECT username FROM users WHERE username = '$username' LIMIT 1");

if(mysql_num_rows($set_query) == 0)

{

$return_content = "You have successfully registered the account ". $username ." with the

password ". $password ."!";

}

else

{

$return_content = "An account with this username already exists.";

}

}

return $return_content;

}

else

{

//nothing to process

}
}
?>

i have shopping cart i need to make the related product section in which i can show the related product when user view the product details.

do i need to create any table for it ?

please guide me about it.
thanks

I have two related websites which utilize the same database:

Main website for public use. Admin website for administration purposes.

Currently, I have both located in /var/www/combined-app which is a single git repository and contains the following:

/var/www/combined-app/
    public/
    public-admin/
    src/
        main/
        admin/
    vendor/
    composer.json
    bootstrap.php

Alternatively, I could have done the following:

/var/www/combined-app/
    main/
        public/
        src/
        vendor/
        composer.json
        bootstrap.php
    admin/
        public/
        src/
        vendor/
        composer.json
        bootstrap.php

Or maybe something else all together?

Is one approach typically better than the other?   If so, please provide reasons why.  If my second example, would you recommend separate git repositories for main and admin?

Thanks

Hello again!

I've been trying out new things (well, new for me) in php again.  This time I decided to try a real challenge and make a forum system.  A friend suggested I use a class for all database functionalities.  i was reluctant at first, but decided if I was going to try using classes for the first time, it might as well be with this.  With some guiding help, I set up the files and gave it a visual once over to check for errors.  Nothing seemed out of place, but when I loaded the page to try it out, I got this error:

Quote

Fatal error: Call to a member function query() on a non-object in /home/ck9/public_html/planning/forumbuild/list.php on line 20



I didn't see anything out of line, so I consulted my friend about it.  He made a few small adjustment suggestions, but nothing fixed the issue.  I then bugged my host about it, and he couldn't find anything wrong either.  Both people are highly experienced in php, so when they say it SHOULD be working I am left rather confused.

Here is list.php:
Code: [Select]
<?php
 include("db.class.php");
 include("db.config.php");

 $db = new databaseConnection($config['user'],$config['pass'],$config['database']);
 $g = $_GET['g'];
 $s = $_GET['s'];
 $t = $_GET['t'];

 function tablestart($a = '1')
  {
   global $db;

   echo "<table border='" . $a . "' cellpadding='10' cellspacing='0' align='center' width='80%' style='color: #C0C0C0'>\n";
  }
 function contents($table, $a, $b = '1', $c = '1')
  {
   global $db;

   $db->query("SELECT * FROM $table");

   while($row = $db->fetch_array())
    {
     if($row['level'] <= $_SESSION['ulevel'])
      {
       echo "<tr><td width='5%'><!--indicator--></td><td width='80%'><a href='index.php?pg=h&g='" . $row['g'];
       if(($a > '1') && ($row['g'] == $b))
        {
         echo "&s=" . $row['s'];
         if(($a > '2') && ($row['s'] == $c))
          {
           echo "&t=" . $row['t'];
          }
        }
      }
     echo "' style='color: #C0C0C0 ; text-decoration: none'><font size='4'>" . $row['name'] . "</font><br /><fpnt size='3'>" . $row['desc'] . "</td><td width='15%'><!--last update--></td></tr>\n";
    }
  }

 if(empty($_SESSION['ulevel']))
  {
   $_SESSION['ulevel'] = '0';
   echo "<font color='#CC0000'><center>You need to register to post in these forums.</center></font><br />\n";
  }

 if(empty($g))
  {
   tablestart();
   contents('group', '1');
   echo "</table>\n";
  }
 elseif(empty($s))
  {
   tablestart();
   contents('section', '2', $g);
   echo "</table>\n";
  }
 elseif(empty($t))
  {
   tablestart('0');
   echo "<tr><td width='80%'></td><td><!--new topic--></td></tr>\n</table>\n";
   tablestart();
   contents('topic', '3', $g, $s);
   echo "</table>\n";
  }
 elseif(!empty($t))
  {
   tablestart('0');
   echo "<tr><td width='80%'></td><td><!--new topic and reply--></td></tr>\n</table>\n";
   $data = file_get_contents('topics/g' . $g . 's' . $s . 't' . $t . '.txt');
   $post = explode("<!--p-->", $data);
   $length = count($post);
   tablestart('1');
   for($z = '0'; $z < $length; $z ++)
    {
     $i = '0';
     $cont = explode("<!--e-->", $post[$pos]);
     echo "<tr><td><b>" . $cont[$i] . "</b><br /><!--future additions--></td><td>\n<table width='100%' style='font-size: xx-small'>\n<tr><td height='3' width='75%'>";
     $i ++;
     echo "Posted on" . $cont[$i] . "</td><td height='3' width='25%'><!--future additions--></td></tr><tr><td width='100%'>";
     $i ++;
     echo $cont[$i] . "</td></tr></table></td></tr>\n";
    }
   echo "</table>\n";
  }
?>
My aim here was to have a single page to display the groups, sections, topics, and posts in order to keep database calls where I could find them easily.

and here is the class file:

Code: [Select]
<?php
class databaseConnection
 {
  protected $link;
  protected $lastResult;
  function databaseConnection($user,$pass,$database)
   {
    $this->link = mysql_connect("localhost",$user,$pass);
    if( !$this->link )
     {
      die('Vital information missing.');
     }
    else
     {
      mysql_select_db($database,$this->link) or die('could not find database: ' . mysql_error());
     }
   }
  function query($query)
   {
    $this->lastresult = mysql_query($query) or die('MySQL error: ' . mysql_error());
    return $this->lastresult;
   }
  function fetch_array($result = false)
   {
    if(!$result)
     {
      return mysql_fetch_array($this->lastresult);
     }
    else
     {
      return mysql_fetch_array($result);
     }
   }
 }
?>
I have tried everything from adjusting the php tags to putting the class directly in the page.

The config file just provides the user, pass, and which database to connect to.  I've checked it's formatting a few times just in case.

i hav this url n whenever i click on this url i get som mssg send on my mobile
i hav a form whose code is
Code: [Select]
<form action="formprocess.php method="post">
telephone<input type="text name="telephone>
<input type="submit" name="submit">
</form>


i want to send telephone as parameter to this url so whenever user enters his telephone he gets d mssg
after clicking on submit.....but i hav no idea how to do tht...help me somone plssssssss

http://www.abc.in/smsapi/sendsms.php?sendto=9987234123&msg=your