Tag Archives: mysql

PHP RSS Reader Gets Better With New Version

31 Aug

" alt="PHP RSS Reader Gets Better With New Version" width="490" height="200" class="thumbnail" />

PHP RSS Reader, a free application with a paid/premium version that was shared before at WRD, now has a new version with nice features.

The application can crawl any number of feeds and can organize them inside categories created.

Similar to how Google News does, it can now show related news articles appear below each new item, in clusters nice way of discovering more.

PHP RSS Reader

The premium version has the ability to categorize contents that include pre-defined keywords which is very useful if you're monitoring your brand or a specific subject.

That version also has a multi-user interface where each user can create his/her own feeds and vote on the stories displayed.

Who is it good for?

It fits to various scenarios:

  • creating a website from scratch which totally feeds from other sources.
  • a companion to a website for displaying content from other similar websites.
  • monitoring your brand or specific keywords from preferred sources (Twitter, newspapers and more).

P.S. The premium version also comes with an optional free installation.

Special Downloads:
Ajaxed Add-To-Basket Scenarios With jQuery And PHP
Free Admin Template For Web Applications
jQuery Dynamic Drag’n Drop
ScheduledTweets

Advertisements:
Professional XHTML Admin Template ($15 Discount With The Code: WRD.)
Psd to Xhtml
SSLmatic – Cheap SSL Certificates (from $19.99/year)

Tags: ,

Related posts

 

Click here to read the full article

Article Source: PHP RSS Reader Gets Better With New Version

PHP RSS Reader Gets Better With New Version

31 Aug

" alt="PHP RSS Reader Gets Better With New Version" width="490" height="200" class="thumbnail" />

PHP RSS Reader, a free application with a paid/premium version that was shared before at WRD, now has a new version with nice features.

The application can crawl any number of feeds and can organize them inside categories created.

Similar to how Google News does, it can now show related news articles appear below each new item, in clusters nice way of discovering more.

PHP RSS Reader

The premium version has the ability to categorize contents that include pre-defined keywords which is very useful if you're monitoring your brand or a specific subject.

That version also has a multi-user interface where each user can create his/her own feeds and vote on the stories displayed.

Who is it good for?

It fits to various scenarios:

  • creating a website from scratch which totally feeds from other sources.
  • a companion to a website for displaying content from other similar websites.
  • monitoring your brand or specific keywords from preferred sources (Twitter, newspapers and more).

P.S. The premium version also comes with an optional free installation.

Special Downloads:
Ajaxed Add-To-Basket Scenarios With jQuery And PHP
Free Admin Template For Web Applications
jQuery Dynamic Drag’n Drop
ScheduledTweets

Advertisements:
Professional XHTML Admin Template ($15 Discount With The Code: WRD.)
Psd to Xhtml
SSLmatic – Cheap SSL Certificates (from $19.99/year)

Tags: ,

Related posts

 

Click here to read the full article

Article Source: PHP RSS Reader Gets Better With New Version

Fully Ajaxed MySQL Admin – MonoQL

26 Aug

" alt="Fully Ajaxed MySQL Admin – MonoQL" width="490" height="200" class="thumbnail" />

MonoQL is a PHP-powered, open source and Ajaxed web application for managing MySQL databases.

It has a desktop-like interface -thanks to Ext JS- and can accomplish almost every task you can ask for like database/table design, data browsing/editing, advanced querying & more.

MonoQL

The application has support for controlling advanced MySQL features like triggers, stored procedures and views.

MonoQL can connect to any number of databases, both local or remote. Also, with the help of a context menu, it display options on every level like running queries, importing data from a CSV file or truncating/deleting a table.

Special Downloads:
Ajaxed Add-To-Basket Scenarios With jQuery And PHP
Free Admin Template For Web Applications
jQuery Dynamic Drag’n Drop
ScheduledTweets

Advertisements:
Professional XHTML Admin Template ($15 Discount With The Code: WRD.)
Psd to Xhtml
SSLmatic – Cheap SSL Certificates (from $19.99/year)

Tags: ,

Related posts

 

Click here to read the full article

Article Source: Fully Ajaxed MySQL Admin – MonoQL

Open Source & Ajaxed Notebook – Surreal Todo

24 Aug

" alt="Open Source & Ajaxed Notebook – Surreal Todo" width="490" height="200" class="thumbnail" />

Surreal Todo is an open source web application that can be used as an online notebook or a to-do-list manager.

It is built with PHP, uses MySQL for storing data and relies on jQuery for the JavaScript part.

Surreal Todo

With a totally Ajaxed interface, you can create new lists, style every item or mark them as completed.

The application enables you to create new tabs and pages instantly for a better organization of the lists/content.

Also, list items can be re-ordered or moved to other lists via drag'n drops and lists can be collapsed to save space.

Special Downloads:
Ajaxed Add-To-Basket Scenarios With jQuery And PHP
Free Admin Template For Web Applications
jQuery Dynamic Drag’n Drop
ScheduledTweets

Advertisements:
Professional XHTML Admin Template ($15 Discount With The Code: WRD.)
Psd to Xhtml
SSLmatic – Cheap SSL Certificates (from $19.99/year)

Tags: , ,

Related posts

 

Click here to read the full article

Article Source: Open Source & Ajaxed Notebook – Surreal Todo

MyWebSql – Open Source & Ajaxed MySQL Manager

13 Aug

" alt="MyWebSql – Open Source & Ajaxed MySQL Manager" width="490" height="200" class="thumbnail" />

MyWebSql is a web-based and open source MySQL client that is built with PHP.

It has an Ajaxed interface and besides the rows of tables, it can control views, stored procedures, triggers and functions.

MyWebSql

Data can be exported and imported easily (query results can be exported as well).

MyWebSql comes with a syntax highlighting rich-text SQL editor to run queries (the last-ran query is shown automatically which is a nice reminder).

The application is improved frequently and, within time, can become a good alternative to mature solutions.

Special Downloads:
Ajaxed Add-To-Basket Scenarios With jQuery And PHP
Free Admin Template For Web Applications
jQuery Dynamic Drag’n Drop
ScheduledTweets

Advertisements:
Professional XHTML Admin Template ($15 Discount With The Code: WRD.)
Psd to Xhtml
SSLmatic – Cheap SSL Certificates (from $19.99/year)

Tags: ,

Related posts

 

Click here to read the full article

Article Source: MyWebSql – Open Source & Ajaxed MySQL Manager

Feature-Rich, Robust & Professional CMS: Vivvo

5 Aug

" alt="Feature-Rich, Robust & Professional CMS: Vivvo" width="490" height="200" class="thumbnail" />

Vivvo is a professional and “commercial open source” CMS application that is built with PHP, uses MySQL for storing data and offers a “top-notch” experience.

The application is ready to power any type and size of website from a portal to a newspaper, a blog, etc. as it is already preferred by 1000s of websites.

Vivvo CMS

The CMS comes as a downloadable package to install on your own servers (has a web-based installer) with powerful features for managing the content like publishing articles, static pages, blogs, images, photo galleries, videos, podcasts and keeping revisions of them.

It has the tools to equip any website with functional modules like an event calendar, commenting system, integrated search, ability to show related articles and integrate with popular forum softwares.

Also, the application helps the content to spread with social bookmarking syndication, “email to a friend”, print version, subscribe, RSS and more.

Vivvo Admin

Vivvo has an impressive and slick admin interface which has a permission-based user management system where it is possible to define editors, writers, photo gallery managers, members, etc.

It is SEO-friendly in means of the URLs created, ability to customize meta tags/keywords and auto-sitemap generation. And, the 20 free templates that the CMS comes with are all SEO optimized.

Besides these features, it is always to think of something missing. But Vivvo is ready to cover it with 100+ free plugins and widgets (like multi-site manager, Twitter updater) where it is possible to create new ones as the application is open source.

Vivvo is very well documented with user guides, a knowledge base and a highly active community behind it.

P.S. This post is a sponsored review.

Special Downloads:
Ajaxed Add-To-Basket Scenarios With jQuery And PHP
Free Admin Template For Web Applications
jQuery Dynamic Drag’n Drop
ScheduledTweets

Advertisements:
Professional XHTML Admin Template ($15 Discount With The Code: WRD.)
Psd to Xhtml
SSLmatic – Cheap SSL Certificates (from $19.99/year)

Tags: ,

Related posts

 

Click here to read the full article

Article Source: Feature-Rich, Robust & Professional CMS: Vivvo

Clients-Oriented FTP Interface – cFTP

28 Jul

" alt="Clients-Oriented FTP Interface – cFTP" width="490" height="200" class="thumbnail" />

For anyone working with multiple clients, the sharing of files (screenshot of a design, documents, etc.) can be difficult, specially if they are large in size.

cFTP is an open source and multi-user PHP application that

Free PHP Comments Script – Commentics

20 Jul

" alt="Free PHP Comments Script – Commentics" width="490" height="200" class="thumbnail" />

If you're building a website without a CMS but still want to enable users to comment to the content, Commentics can be handy.

It is a free PHP comments script, using MySQL for storing data, that can be integrated into any website and comes with many features.

Commentics - PHP Comments Script

The script has various security features like captcha or swear/spam and anti-flooding filters.

Once a user sends a comment, they can also rate the content as well and subscribe to the future comments via e-mail or RSS.

A slick admin panel helps configuring the system from taking backups to viewing online users or statistics.

Special Downloads:
Ajaxed Add-To-Basket Scenarios With jQuery And PHP
Free Admin Template For Web Applications
jQuery Dynamic Drag’n Drop
ScheduledTweets

Advertisements:
Professional XHTML Admin Template ($15 Discount With The Code: WRD.)
Psd to Xhtml
SSLmatic – Cheap SSL Certificates (from $19.99/year)

Tags: ,

Related posts

 

Click here to read the full article

Article Source: Free PHP Comments Script – Commentics

Feed-Based Data Aggregator: Managing News

5 Jul

" alt="Feed-Based Data Aggregator: Managing News" width="490" height="200" class="thumbnail" />

Managing News is an open source application that aggregate RSS/Atom based content with search, republishing and mapping.

It is built on Drupal and 30 other open source resources (mostly Drupal modules) and can display the content as list or on a map (by geotagging them).

Managing News

Using Managing News, it is possible to search for key trends within the feeds followed and graph the results.

Also, it enables you to share any story using Facebook, Twitter or email.

Special Downloads:
Ajaxed Add-To-Basket Scenarios With jQuery And PHP
Free Admin Template For Web Applications
jQuery Dynamic Drag’n Drop
ScheduledTweets

Advertisements:
FindIcons.com – Ultimate Free Icon Search Engine
Psd to Xhtml
SSLmatic – Cheap SSL Certificates (from $19.99/year)

Tags: ,

Related posts

 

Click here to read the full article

Article Source: Feed-Based Data Aggregator: Managing News

Ajax Poll Script With PHP, MySQL & jQuery

22 Jun

" alt="Ajax Poll Script With PHP, MySQL & jQuery" width="490" height="200" class="thumbnail" />

In this tutorial, we'll be creating an Ajax Poll Script that displays the results with colored and animated lines using PHP, MySQL and jQuery.

The script has a pretty easy logic and can be implemented into any website quickly by simply calling a php function like getPoll(2) which brings the second poll.

Ajax Poll Script

Ajax Poll Script DemoAjax Poll Script Download

The code has 3 parts: HTML, JavaScript (jQuery) and PHP. Let's start with the easiest one:

HTML

The HTML for the poll is generated within the PHP function which is usually nice as it is only a 1-line-code and doesn't create a visual pollution in the overall HTML.

Poll Question 1

  • Answer1 for Poll1
  • Answer2 for Poll1
Ajax Loader

There is nothing original here. In one of the list items, we mention the answer and provide a unique ID for it which matches that answer's answerID in the database. For the other list item, we reserve it for the colored line, again by giving it the unique ID.

PHP

We first include our db connection file and handle the posted items from the Ajax requests

require("db.php");
//GETTING VARIABLES START
$action 		= mysql_real_escape_string($_POST['action']);
$pollAnswerID	= mysql_real_escape_string($_POST['pollAnswerID']);
//GETTING VARIABLES END

After that, create the function getPoll which simply loops through the database and creates the HTML for the poll mentioned above.

function getPoll($pollID){
	$query  = "SELECT * FROM polls LEFT JOIN pollAnswers ON polls.pollID = pollAnswers.pollID WHERE polls.pollID = " . $pollID . " ORDER By pollAnswerListing ASC";
	$result = mysql_query($query);
	//echo $query;jquery

	while($row = mysql_fetch_array($result, MYSQL_ASSOC))
	{
		$pollQuestion 		= $row['pollQuestion'];
		$pollAnswerID 		= $row['pollAnswerID'];
		$pollAnswerValue	= $row['pollAnswerValue'];

		if ($pollStartHtml == '') {
			$pollStartHtml 	= '

' . $pollQuestion .'

    '; $pollEndHtml = '
Ajax Loader
'; } $pollAnswersHtml = $pollAnswersHtml . '
  • ' . $pollAnswerValue .'
  • '; $pollAnswersHtml = $pollAnswersHtml . '
  • '; } echo $pollStartHtml . $pollAnswersHtml . $pollEndHtml; }

    This getPollID function below is for easily getting the ID of the related polls by providing an answerID:

    function getPollID($pollAnswerID){
    	$query  = "SELECT pollID FROM pollAnswers WHERE pollAnswerID = ".$pollAnswerID." LIMIT 1";
    	$result = mysql_query($query);
    	$row = mysql_fetch_array($result);
    
    	return $row['pollID'];
    }
    

    And, the getPollResults function which is kinda tricky but not that much.

    When ran, it returns a string like: 1|13|#ffcc00-2|32|#00ff00-3|18|#cc0000-63″ which the first number is the answerID, second is the points it has and third is the color for that answer's animated line.

    The last number is the sum of all points for easily calculating percentages.

    The string is parsed in the JavaScript side later on.

    function getPollResults($pollID){
    	$colorArray = array(1 => "#ffcc00", "#00ff00", "#cc0000", "#0066cc", "#ff0099", "#ffcc00", "#00ff00", "#cc0000", "#0066cc", "#ff0099");
    	$colorCounter = 1;
    	$query  = "SELECT pollAnswerID, pollAnswerPoints FROM pollAnswers WHERE pollID = ".$pollID."";
    	$result = mysql_query($query);
    	while($row = mysql_fetch_array($result))
    	{
    		if ($pollResults == "") {
    			$pollResults = $row['pollAnswerID'] . "|" . $row['pollAnswerPoints'] . "|" . $colorArray[$colorCounter];
    		} else {
    			$pollResults = $pollResults . "-" . $row['pollAnswerID'] . "|" . $row['pollAnswerPoints'] . "|" . $colorArray[$colorCounter];
    		}
    		$colorCounter = $colorCounter + 1;
    	}
    	$query  = "SELECT SUM(pollAnswerPoints) FROM pollAnswers WHERE pollID = ".$pollID."";
    	$result = mysql_query($query);
    	$row = mysql_fetch_array( $result );
    	$pollResults = $pollResults . "-" . $row['SUM(pollAnswerPoints)'];
    	echo $pollResults;
    }
    

    The last PHP code is the voting part which also sets a cookie:

    if ($action == "vote"){
    
    	if (isset($_COOKIE["poll" . getPollID($pollAnswerID)])) {
    		echo "voted";
    	} else {
    		$query  = "UPDATE pollAnswers SET pollAnswerPoints = pollAnswerPoints + 1 WHERE pollAnswerID = ".$pollAnswerID."";
    		mysql_query($query) or die('Error, insert query failed');
    		setcookie("poll" . getPollID($pollAnswerID), 1, time()+259200, "/", ".webresourcesdepot.com");
    		getPollResults(1);
    	}
    }
    

    jQuery (JavaScript)

    It is only an Ajax request that posts the selected answer to the PHP code, gets the string in return, parses it and makes some show/hide tricks for displaying and hiding the messages or loaders.

    Here it is:

    $(document).ready(function() {   
    
    	$("#pollAjaxLoader").hide(); //hide the ajax loader
    	$("#pollMessage").hide(); //hide the ajax loader
    	$("#pollSubmit").click(function() {
    		var pollAnswerVal = $('input:radio[name=pollAnswerID]:checked').val();//Getting the value of a selected radio element.
    		if ($('input:radio[name=pollAnswerID]:checked').length) {
    			$("#pollAjaxLoader").show(); //show the ajax loader
    			$.ajax({
    				type: "POST",
    				url: "inc/functions.php",
    				data: { pollAnswerID: pollAnswerVal, action: "vote" },
    				success: function(theResponse) {
    					//the functions.php returns a response like "1|13|#ffcc00-2|32|#00ff00-3|18|#cc0000-63" which the first number is the answerID, second is the points it has and third is the color for that answer's graph. The last number is the sum of all points for easilt calculating percentages.
    					if (theResponse == "voted") {
    						$("#pollAjaxLoader").hide(); //hide the ajax loader
    						$("#pollMessage").html("sorry, you already voted.").fadeTo("slow", 1);
    					} else {
    						var numberOfAnswers 		= (theResponse).split("-").length-2;//calculate the number of answers
    						var splittedResponse 		= (theResponse).split("-");
    						var pollAnswerTotalPoints 	= splittedResponse[numberOfAnswers+1];
    
    						for (i=0;i<=numberOfAnswers;i++)
    						{
    							var splittedAnswer 		= (splittedResponse[i]).split("|");
    							var pollAnswerID 		= (splittedAnswer[0]);
    							var pollAnswerPoints 	= (splittedAnswer[1]);
    							var pollAnswerColor 	= (splittedAnswer[2]);
    							var pollPercentage		= (100 * pollAnswerPoints / pollAnswerTotalPoints);
    							$(".pollChart" + pollAnswerID).css("background-color",pollAnswerColor);
    							$(".pollChart" + pollAnswerID).animate({width:pollPercentage + "%"});
    							$("#pollAnswer" + pollAnswerID).html(" (" + Math.round(pollPercentage) + "% - " + pollAnswerPoints + " votes)");
    							$("#pollRadioButton" + pollAnswerID).attr("disabled", "disabled"); //disable the radio buttons
    						}
    						$("#pollAjaxLoader").hide(); //hide the ajax loader again
    						$("#pollSubmit").attr("disabled", "disabled"); //disable the submit button
    					}
    				}
    			});
    			return false; 
    
    		} else {
    			$("#pollMessage").html("please select an answer.").fadeTo("slow", 1, function(){
    				setTimeout(function() {
    					$("#pollMessage").fadeOut("slow");
    				}, 3000);
    			});
    			return false;
    		}
    
    	});
    
    });
    

    The JavaScript code is well-commented and is pretty self-explanatory. Don't let the number of lines afraid you, most of them are just the make-up.

    That's all.

    Special Downloads:
    Ajaxed Add-To-Basket Scenarios With jQuery And PHP
    Free Admin Template For Web Applications
    jQuery Dynamic Drag’n Drop
    ScheduledTweets

    Advertisements:
    FindIcons.com – Ultimate Free Icon Search Engine
    Psd to Xhtml
    SSLmatic – Cheap SSL Certificates (from $19.99/year)

    Tags: ,

    Related posts

     

    Click here to read the full article

    Article Source: Ajax Poll Script With PHP, MySQL & jQuery