Los mejores Tweets
sobre Bigdata, Analitica, e-learning

107.400 tweets analizados.

Favoritos: Retweets:

Favoritos: Retweets:

= '$tempFav' order by favoritos, retweets desc LIMIT $start_from, $num_rec_per_page"; } if (isset($_POST["retweets"])){ $SQL = "SELECT id_Tweet,user,tweet, fecha, enviar, enviado,borrado,substring(tweet,locate('http',tweet),22) 'URL',favoritos, retweets FROM tweets WHERE tweet like '%$_POST[q]%' and retweets >= '$tempRet' order by retweets, favoritos desc LIMIT $start_from, $num_rec_per_page"; } if (( !isset($_POST["retweets"])) && ( !isset($_POST["favoritos"]) )){ $SQL = "SELECT id_Tweet,user,tweet, fecha, enviar, enviado,borrado,substring(tweet,locate('http',tweet),22) 'URL',favoritos, retweets FROM tweets WHERE tweet like '%$_POST[q]%' order by fecha desc LIMIT $start_from, $num_rec_per_page"; } /* if ((isset($_POST["retweets"])) && (isset($_POST["favoritos"]) )){ $SQL = "SELECT id_Tweet,user,tweet, fecha, enviar, enviado,borrado,substring(tweet,locate('http',tweet),22) 'URL',favoritos, retweets FROM tweets WHERE tweet like '%$_POST[q]%' and retweets >= '$tempRet' and favoritos >= '$tempFav' order by fecha desc LIMIT $start_from, $num_rec_per_page"; }*/ $result = mysql_query($SQL); $num_rows = mysql_num_rows($result); $counter = 1; while($db_field = mysql_fetch_assoc($result)){ echo ''; echo ''; echo ''; echo ''; $counter++; } } echo '
Tweet Favoritos / Retweets
'; echo "@".$db_field['user']." publicado en ".$db_field['fecha']; echo '

'; print $db_field['tweet']; echo ' Link"; echo ''; echo '

'; echo '

'; echo $db_field['favoritos']; echo 'Numero de favoritos'; echo $db_field['retweets']; echo 'Numero de retweets'; echo '
'; ?> = '$tempFav' order by favoritos desc"; } if (isset($_POST["retweets"])){ $SQL = "SELECT id_Tweet,user,tweet, fecha, enviar, enviado,borrado,substring(tweet,locate('http',tweet),22) 'URL',favoritos, retweets FROM tweets WHERE tweet like '%$_POST[q]%' and retweets >= '$tempRet' order by retweets desc"; } if (( !isset($_POST["retweets"])) && ( !isset($_POST["favoritos"]) )){ $SQL = "SELECT id_Tweet,user,tweet, fecha, enviar, enviado,borrado,substring(tweet,locate('http',tweet),22) 'URL',favoritos, retweets FROM tweets WHERE tweet like '%$_POST[q]%' order by fecha desc"; } /* if ((isset($_POST["retweets"])) && (isset($_POST["favoritos"]) )){ $SQL = "SELECT id_Tweet,user,tweet, fecha, enviar, enviado,borrado,substring(tweet,locate('http',tweet),22) 'URL',favoritos, retweets FROM tweets WHERE tweet like '%$_POST[q]%' and retweets >= '$tempRet' and favoritos >= '$tempFav' order by fecha desc LIMIT $start_from, $num_rec_per_page"; }*/ $result = mysql_query($SQL); $total_records = mysql_num_rows($result); //count number of records $total_pages = ceil($total_records / $num_rec_per_page); echo "

"; ?>