PHP - How Do I Get The Latest Tweet In To Webpage

try {
echo "<br>";
foreach($dbh->query("SELECT * FROM test_shot WHERE sold=1 ORDER BY year ASC") as $row) {
	
						if($row['picture'] != "" && $row['picture'] != null)
						{
						echo "<div class='image-holder'><img src ='".$row['picture']."' width=300px /><br>";  
            			}
						if($row['year'] != "" && $row['year'] != null)
						{
							echo $row['year'];
						}
						if($row['description'] != "" && $row['description'] != null)
						{
							echo $row['description'];
						}
						if($row['sold'] == 1) {
							echo "<img src='images/sold1.png'><br>";//Add your image code here
							}
							elseif ($row['sold'] == 0) {
							
							echo "</div><br>";
						}
					}

	}	

catch (PDOException $e) {
  print $e->getMessage();
}

?>

 

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?

hey I am not usually in this php forum, I am usually around html/css but a task arose and I figure since this forum uses smf it would be a perfect place to ask. Not saying you are all smf experts though.

My question is how do I display the latest posts for smf in a page thats not a forum page. Like  On my index page I want to display the latest posts on the forum. Help anyone?

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

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 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;    }}?>()

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

hello dear Linux-experts

well at the moment i wonder how i can find out the latest schools at openstreetmap -

note: i focus on a country - south america and he on Argentina: so here we go

[date:"2014-09-18T00:00:00Z"];area[name="Argentina"][boundary=administrative]->.a;(node(area.a)[amenity=school];way(area.a)[amenity=school];);out center;

  js this doable with overpass-api.de or with overpass-turbo.eu   love to hear from you

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!

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

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.

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 ?

now i use this code to show where the visitors came from to my site.

<?php
$referer=$_SERVER['HTTP_REFERER'];
echo $referer;
?>

now, i want to show the  5 latest vistors referer's site url on my site ?