PHP - Filtering Out The Latest Entries On Openstreetmap - With Certain Tags

Right now I just cheated and sorted by descending then put like thirty <br />'s so you couldn't see old ones. How can I do this properly?

I am asking out of curiosity, how does this problem usually get solved, when using a tag system to sort content, and users enter similar tags.

For example:

flower and flowers...

which means the difference between singular and plural. Judging by other sites which are around, this problem is not solved at all, they simply let you add as many tags as you want and then rank the most used tags, it indeed is a solution, but seems more like a walk-around solution to me.

Any ideas how somebody could approach to solve this one?

EDIT:

My suggestion would be an analysis function, which analyzes the entered tag and then suggests the user that similar tags have been already entered and perhaps he wants to choose one of those which have been already entered. This does work though with a high traffic websites what can happen is the following:

php and php5

You can end up with two similar tags which are both widely used though have different meanings to the user base.

This one could be solved by simply prohibiting similar tags with little additions or changes, and so to speak "forcing" the user to choose something which is already there. May be a way, though it can turn out as a bad solution as well.

Hi Guys,

Sorry if this is the wrong forum but i wasnt sure the best one.

i am trying to see how others control the version of apps they have written and updating.

i want to set the version of my app e.g. 1.0 and then have a section where if i release 1.5 it will show up that a new version is available for upgrade.

the only thing im not too sure about is when someone goes to upgrade if not all of the updated files are uploaded correctly i want it to say version missmatch.

could someone give me examples of how i could achieve this?

I'm in the process of creating a webage that shows latest scores and an updated league table for soccer/football matches like the bbc sports website does.

I have the database set up with a form to update and display latest score all work well apart from if i update a score like the following

teamA  1  teamB  0   it updates table to give  teamA 3 points based on the current score however if teamA score again
teamA 2 teamB 0 it updates table again  but gives teamA another 3 points which is not correct so i need a way to stop it happening.

thought about it for a while and only thing i can come up with is some maths to compare the values of score for each team and add/remove points as dependent on current score.


Anyone got something similar to this

Hi,

I want to get a latest video from Youtube Playlist. I look it on Google API, and the other solutions, but I think dont undestand quit good what I need to do.

For example a have a playlist:

https://www.youtube.com/playlist?list=PLW8l7rX2YaXkaSI8GGbmqPjOEmfzd2hz3

And I want to see always only a latest uploaded video, so I need a link (embed - watch, or "youtu.be/xy"):

https://www.youtube.com/watch?v=LyzziLETNUw&list=PLW8l7rX2YaXkaSI8GGbmqPjOEmfzd2hz3

Thanks in advanced,

T

Hello all,

My question is about a custom-coded latest-news plugin written by someone else. I don't know if it is generic, a copy of something else or what. It works good! but when I go to add a new news item to the list under Settings, it adds the item to the bottom of the list. The news is displayed on my homepage in short form and in full format on the primary news page.

I need new items to be added to the TOP of the list instead or in reverse, so that in all the containers where it resides, the latest news item added is always at the top of the list. I know nothing about php but I am looking to learn. I plan on taking some basic classes on css and php to upgrade my archaic html skills, but I'm currently studying other subjects. Regardless, if this has a simple fix, I would be very interested in knowing what is needed and where/why.

Here is the core of the php that I am finding in the plugin: There are three php files, This one says active, the other two say inactive so I get the impression they are not in use. Let me know if I should post their contents as well.

Appreciate any help with this! My sincere thanks in advance.

Labeled active: latest_news.php
*/ob_start();register_activation_hook(__file__, latest_news_install);function latest_news_install() {    global $wpdb;    $table_name = $wpdb->prefix . "latest_news";    if ($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) {        $sql = "CREATE TABLE IF NOT EXISTS " . $table_name . " (                     `id` int(10) NOT NULL AUTO_INCREMENT,                     `title` varchar(255) NOT NULL,                     `description` text NOT NULL,                     `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,                     PRIMARY KEY (id)                 );";        mysql_query($sql) or die(mysql_error());    }}if( !function_exists('wp_latest_news_init') ) {    function wp_latest_news_init() {        add_shortcode( 'wp_latest_news', 'shortcode_latest_news');    }}if( !function_exists('shortcode_latest_news') ) {    function shortcode_latest_news() {       // extract(shortcode_atts(array('limit' => '5', ), $atts));        global $wpdb;              $user_count = $wpdb->get_results("SELECT * FROM wp_latest_news ORDER BY date ASC LIMIT 4");                foreach ($user_count as $output) {            $htmlOutput[] = "<li><b><a href='".  get_permalink(287)."?news_id=".$output->id."'>" . $output->title . "</a></b></li>";        }        //echo $htmlOutput;        //echo "<pre>"; print_r($user_count); echo "</pre>";        foreach ($htmlOutput as $out) {            echo $out;        }                return $htmlOutput;    }}/* add_action('init', 'wp_latest_news_init' ) is used for call init function for create shortcode */add_action('init', 'wp_latest_news_init' );add_action('admin_menu', 'wp_latestnews_links' );function wp_latestnews_links() {    add_submenu_page( 'options-general.php', __( 'Latest News ' ), __( 'Latest News ' ), 5 , 'latest_news_settings', 'latest_news_settings' );}//     function latest_news_settings() {//          global $wpdb;//        if (isset($_POST["submit"])) {//            $sql="INSERT INTO ".$wpdb->prefix . "latest_news(`title`,`description`) VALUES ('".$_POST['news_title']."','".$_POST['description']."') ";//           //$sql=$wpdb->insert( $wpdb->latest_news, array( 'title' => $_POST['news_title'] ,'description' => $_POST['description'] ) );//           mysql_query($sql) or die(mysql_error());//         }//         include 'Latest_news_setting.php';function latest_news_settings() {    global $wpdb;    $action = $_REQUEST["action"];    $id = $_REQUEST['id'];    $sql = "SELECT * from ".$wpdb->prefix."latest_news ";    $results = $wpdb->get_results($sql);    //echo "<pre>";print_r($results);    //$post_arr = query_posts("");    //echo "<pre>";print_r($post_arr);exit;    switch ($action) {        case 'add' :            include('news_form.php');            break;        case 'save' :            if(isset($_POST['cancel'])) {                include('latest_news_list.php');            } else if(isset($_POST['add'])) {                $wpdb->query("insert into ".$wpdb->prefix."latest_news (`title`,`description`) VALUES ('".$_REQUEST['news_title']."','".$_REQUEST['description']."')");                //header("Location: http://localhost:81/Bravo/wp-admin/edit.php?page=slider_images");                header("location:?page=latest_news_settings");            }            break;        case 'edit' :            $sql = "SELECT * from ".$wpdb->prefix."latest_news where id = '".$id."' ";            $results_arr = $wpdb->get_results($sql);            //echo "<pre>";print_r($results_arr);            include('news_form.php');            break;        case 'update' :            if(isset($_POST['cancel'])) {                include('news_form.php');            } else if(isset($_POST['edit'])) {                //echo $id;                $wpdb->query("update ".$wpdb->prefix."latest_news set title = '".$_REQUEST['news_title']."', description = '".$_REQUEST['description']."' where id='".$id."'");                header("location:?page=latest_news_settings");            }            break;        case 'delete' :            $wpdb->query("delete from ".$wpdb->prefix."latest_news where id='".$id."'");            header("location:?page=latest_news_settings");            break;        default:            include('latest_news_list.php');            break;    }}?>()

I'm having trouble listing the most recent 10 content. How can I solve this problem.

$sorgu = mysqli_query("select * from icerik order by id desc limit 0,10");

while($goster=mysqli_fetch_assoc($sorgu)) {
  echo $goster['baslik'];
  echo $goster['yazi'];
  echo $goster['yazar'];

}

error code:

Fatal error: Uncaught ArgumentCountError: mysqli_query() expects at least 2 arguments, 1 given in C:\xampp\htdocs\blog\orta.php:3 Stack trace: #0 C:\xampp\htdocs\blog\orta.php(3): mysqli_query('select * from i...') #1 C:\xampp\htdocs\blog\index.php(4): include('C:\\xampp\\htdocs...') #2 {main} thrown in C:\xampp\htdocs\blog\orta.php on line 3

Hello guys,

I've been reading through various threads here about getting latest tweets with php but they're all basically methods I've seen before, and involve getting the tweets from the atom feed xml. I've been experimenting with various code snippets that do this on my site, and most of the time they work. But about one in every 10 times it doesn't, because for some reason the tweet doesn't appear in the atom feed. I guess this is a problem with Twitter, but I've google this, and to be honest there's only a few whispers from people that could be experiencing something like this problem, which makes me wonder whether I'm just unlucky or being stupid and overlooking something..? I don't see what though.

Anyway I know there's methods where you can actually log into your twitter acount and post tweets, and all the rest of it, but the codes I've found are all extremely lengthy and arcane, and do far more than what I want them to. So what I'm wondering is- has anyone used this foolproof method of retrieving tweets, and if so I wonder is you could share your code with me, or point me in the right direction? All I want to do is get my latest tweet and display it on my site.

Many Thanks

I need to find the earliest and latest times, but there must be at least 3 to count it.

$array[] = "09:00 - 15:00"
$array[] = "09:00 - 15:00"
$array[] = "09:00 - 15:00"
$array[] = "09:00 - 17:00"
$array[] = "09:00 - 15:30"
$array[] = "07:30 - 15:00"
$array[] = "07:00 - 12:00"

So the above would return 09:00 - 15:00

I thin would need to ensure that a maximum 4 hours inbetween, so I then get something like 10:00 - 14:00 returned

Hi there,

I have updated a webpage and it appears that some users are still seeing the older version of the page. Is there a way I can force the user's version of the page to display the latest content on the page?

I have see I can add some meta tags which control the cache, but my site relies quite heavily on cookies, so I guess clearing the cache would reset/have an effect on the cookies?

Does anyone have any ideas on how I can make users always see the latest content?

Thanks!

Hi friends i have latest rss news feed im my php site, i would like to share latest 5 rss feed so some of our partners can publish in thier site . How to do it ?

I have a search page and everything works fine but I would like to add the latest 10 rows to the page so there is something to look at or click on before the user searches.

The page is at: www.giantstridedives.com/locations. You can see that it's pretty boring. Hit submit and you'll see the entries so far (only 3 right now). I'd like to have the latest 10 display there by default but then when a user searches they are replaced by the search results. Make sense?

Here's the code I'm using for the search:

Code: [Select]
<?php
if (isset($_POST['submit'])) {

require_once('dbconnection.php'); 
mysqli_select_db($conn, $dbname); 
$searchterm = $_POST['search']; 
$searchterm = strip_tags($searchterm);
$searchterm = trim ($searchterm);
$q ="SELECT * FROM locations WHERE loc_name LIKE '%" . $searchterm . "%' AND loc_approved != '0'"; 
$r = mysqli_query($conn, $q) or die(mysql_error($q)); 
$row = mysqli_fetch_assoc($r); 
$rowcount = mysqli_num_rows($r);
}
?>

<h1>Search for Scuba Dive Locations</h1>
<form id="searchform" name="searchform" method="post" action="index.php"> 
    <input type="text" name="search" id="search_bar" />
    <input type="submit" name="submit" id="submit" value="Submit" /> </form>
<span style="color: #333;">Search for the name of the location, ie: Devils Den or USS Oriskany.</span><br />   


<?php 
if (isset($_POST['submit'])) {

if ($rowcount == 0)  
{
echo "Sorry, but we can not find an entry to match your query: <strong>$searchterm</strong>";
}
else { //this tells the table below to display since $totalRows_Products_res is not 0
?>
<table style="font-size: 14px;" border="0" width="650">
 <tr>
  <td colspan="6"><p>You searched for <strong><?php echo $searchterm; ?></strong>. Results are displayed below.</p></td>
 </tr>
<tr>
  <td><strong>Location Name</strong></td>
  <td><strong>City</strong></td>
  <td><strong>State</strong></td>
  <td><strong>Depth (ft)</strong></td>
  <td><strong>Fees</strong></td>
  <td><strong>Gear Rentals</strong></td>
  <td><strong>Map</strong></td>
 </tr>
 <?php do { ?>
  <tr>
   <td><a href="loc_details.php?loc_id=<?php echo $row ['loc_id']; ?>">
<?php echo $row ['loc_name']; ?> </a></td>
<td><?php echo $row ['loc_city']; ?></td>
<td><?php echo $row ['loc_state']; ?></td>
<td><?php echo $row ['loc_depth']; ?></td>
<td>$<?php echo $row ['loc_fee']; ?></td>
<td><?php if($row['loc_gear'] == 1) {
echo 'Yes';
} else { echo 'No'; } ?></td>
<td><a href="http://maps.google.com/maps?q=<?php echo $row ['loc_lat'];?>,<?php echo $row ['loc_lon'];?>" target="_blank">View Map</a></td>
   </tr>
  <?php } while ($row = mysqli_fetch_assoc($r)); ?>
</table>
<?php 
mysqli_free_result($r); 
} // this closes out results else
}
?>

I figure I can use the below query to get the results.
Code: [Select]
select * from table WHERE id >  ((SELECT MAX(id) from table) - 10);I'm just not sure how I can display them by default and then have them be replaced by the search results.  Anyone have any ideas for me? As always I appreciate the help as I continue to learn this beast.

I have a form and script that is used to collect information from users.
There is one field that is url.
There is one field that is email.

I want to filter out scripts.  I also only want to allow url in the url field and email in the email field.

Is there an easy way to filter?  I have tried several pieces of code to no avail.

Code: [Select]
<?php
$root = $_SERVER['DOCUMENT_ROOT'];
include('/home/arts/public_html/shows/includes/config.db.php');
if ($link)
{
  foreach ($_POST as $k => $v)
  {
    if (($k == "start_date") || ($k == "end_date") || ($k == "application_dead"))
  {
  $varray = explode("/",$v);
  $v = $varray[2] . "-" .  $varray[0] . "-" . $varray[1];  
  }
   
  $v = "'" . addslashes($v) . "'";
  
      
  if($k != "captcha_code") 
{
  
$keys[] = $k;
$vals[] = $v;
} 
  }
  
  $fields = implode(",", $keys);  
  $values = implode(",", $vals);
  //$fields = "id," . $fields;
  //$values = "null," . $values;  

  $sql = "INSERT into craft_shows ($fields) VALUES ($values)";  
  
  $result = mysql_query($sql,$link);
if (!$result) {
    die('There was a problem with your submission. Refresh the page to try again');
}
else
{
  echo "Thank you for your submission.<br>";
  echo "<a href=\"http://www.artsandcraftsnetwork.com/shows/\">Back to shows</a><br>";
  echo "<a href=\"http://www.artsandcraftsnetwork.com/shows/shows_submit.php\">Submit another show</a>";
}

  
}
?>