Tryangled Solutions web designing tips tricks

MySQL is a relational database management system (RDBMS) based on SQL (Structured Query Language). First released in January, 1998, MySQL is now one component of parent company MySQL AB’s product line of database servers and development tools.

Many Internet startups became interested in the original open source version of MySQL as an alternative to the proprietary database systems from Oracle, IBM, and Informix. MySQL is currently available under two different licensing agreements: free of charge, under the GNU General Public License (GPL) open source system or through subscription to MySQL Network for business applications.

MySQL runs on virtually all platforms, including Linux, Unix, and Windows. It is fully multi-threaded using kernel threads, and provides application program interfaces (APIs) for many programming languages, including C, C++, Eiffel, Java, Perl, PHP, Python, and Tcl.

MySQL is used in a wide range of applications, including data warehousing, e-commerce, Web databases, logging applications and distributed applications. It is also increasingly embedded in third-party software and other technologies. According to MySQL AB, their flagship product has over six million active MySQL installations worldwide. Customers include Cisco, Dun & Bradstreet, Google, NASA, Lufthansa, Hyperion, and Suzuki.

First, Google News is not the major player for news releases, it’s Yahoo News that has the greater market share of news search. In some cases it does make sense to have two variations of a news release. One version is distributed via a news wire service and another version is posted to the client’s online newsroom. Content related to the release can be created for pitching, or a social media news release might be appropriate as well as alternative information formats for social news.

There are a lot of applications for variations of the same message as far as a news release. As far as there being a conflict between what’s appropriate for journalists and what’s meaningful for news search engines, you have to focus on the audience not on the mechanism for distribution. Don’t compromise your message just for search engines.

<calendar.google.com>: Google’s version of web calendaring offers drag-n-drop changes to events and the ability to synchornize with Gmail and to share with others; another good feature: ability to import public calendars. I recently switched after five years with Yahoo’s version.

<news.google.com>: Allows you to search 4,500 constantly updated news Web sites at once. Saves you the trip to various new sites to find out what’s going on. The new personizable version (see upper right on the page) allows you to layout the page as you like it, including personalized news searches. eg, I have it set up so that news I am interested in - India, New York Yankees, New York Jets, golf, etc - are displayed when I go to the site.

<desktop.google.com>: For Windows only - a way to search your computer’s contents faster than any built-in finder function. Works very well when it comes to searching Word documents, AOL IM messages, web searches, etc. You can pause it if you don’t want what you’re doing to be indexed by Google. The information isn’t shared with Google itself (you know this because it works even if you are offline). Be sure to read the FAQ. Mac folks get the same functionality in the Spotlight search built into Tiger, the latest version of OSX.

// TIMEDIFF between two dates and the result is in seconds
SELECT ((TO_DAYS(DATE_FORMAT(’1997-10-04 22:23:00′, ‘%Y-%m-%d’)) * 86400) +
TIME_TO_SEC(DATE_FORMAT(’1997-10-04 22:24:00′, ‘%T’)))
- ((TO_DAYS(DATE_FORMAT(’1997-10-04 22:24:00′, ‘%Y-%m-%d’)) * 86400) +
TIME_TO_SEC(DATE_FORMAT(’1997-10-04 22:22:00′, ‘%T’)))

<form>
<p>
This program lets to find out what mysql version your current hosting is running on.
You need to enter correct databaes parameters in order to get desired info.
</p>
<b>db host: <b/>
<input type=”text” name=”db_host” value=”localhost”>
<hr size=1 width=”25%” align=left>
<b>db username: <b/>
<input type=”text” name=”db_user” value=”">
<hr size=1 width=”25%” align=left>
<b>db password: <b/>
<input type=”text” name=”db_pass” value=”">
<hr size=1 width=”25%” align=left>
<hr size=1 width=”25%” align=left>
<input type=”submit” name=”submit” value=”submit”>
</form>
<?php
/*
1) enter db user/pass: host = localhost
2) view results
scenario:
1) show form
2) try to login
3) if OK -> show version
4) otherwise tell incorrect db user/pass combination
Freeware for comercial or non-commercial use.
no warranties!
*/
$submit = empty($_REQUEST['submit']) ? 0:1;
if ($submit) {
$db_host = empty($_REQUEST['db_host']) ? “localhost” : $_REQUEST['db_host'];
$db_user = empty($_REQUEST['db_user']) ? “” : $_REQUEST['db_user'];
$db_pass = empty($_REQUEST['db_pass']) ? “” : $_REQUEST['db_pass'];;
if (         empty($db_host)
|| empty($db_host)
|| empty($db_host) ) {
die(”<font color=’red’>Missing fields.</font>”);
}
$link = @mysql_connect($db_host, $db_user, $db_pass);
if (!$link)
die(”<font color=’red’>Can’t connect.
Please check your data.</font>”);
$qry = “SELECT VERSION()”;
$result = @mysql_query($qry);
if (!$result) {
die(”<font color=’red’>Query error: ” . mysql_error() . “</font>”);
}
$ver = @mysql_result($result, 0);
print “<font color=’green’>MySQL version: <b>$ver</b></font>”;
@mysql_free_result($result);
}
?>

Windows

ConTEXT - version 0.97.4; freeware
Crimson Editor - version 3.60; freeware
Programmer’s Notepad -
PSPad - version 4.3.0; freeware
Notepad++
NuSphere PhpED - version 5.0; commercial
NuSphere Nu-Coder - version 1.4; commercial

Mac OS X

skEdit
Smultron - version 1.0.1; freeware
TextWrangler
TextMate
Coda

Linux

Bluefish - version 1.0; other
Geany
gedit
gPHPEdit
Kate - version 2.2; freeware
Quanta Plus - version 3.2.1; freeware

Multiple OS

NetBeans
Eclipse
Aptana
Emacs - version 21; freeware
jEdit - version 4.1; freeware
SciTE - version 1.53; freeware
Vim - version 6.1; freeware
nano

Microsoft released it’s much-anticipated 2007 version of its Office product in January 2007. Years in the making, Office 2007 contains a number of new features, the most notable of which is the entirely new graphical user interface called the Ribbon, replacing the menus and toolbars that have been the cornerstone of Office since its inception. Students and faculty purchasing new computers since January have been purchasing this new version. Although there are many improvements to Word, PowerPoint, Excel and Access, one thing that you should be aware of is that the default file formats are not only different from all past versions, they are not readable by past versions. This means that if a student creates a document in Word 2007 it will automatically be saved in a format called .docx. Since this file type is not recognized in Word 2003 or XP, you will not be able to open it. Some of you may have already run into this problem with student submissions.

WordPress is a web-server-neutral application, meaning that it can run on many different platforms. Apache and Linux are the most robust platforms for running WordPress, but any server that supports PHP and MySQL will do.

Make sure your host features the most up-to-date and stable version of these platforms to create a strong environment in which to run WordPress.

Choosing the best method to run PHP, the language that interprets the WordPress code, can also affect your server’s performance. In CGI mode, the server creates a new instance of the PHP program for every PHP file that a visitor requests. In shared module mode (or ISAPI), a single library instance is used for each PHP hit. There are advantages and drawbacks to each method - while choosing the method for your server, be sure to keep in mind traffic and its demands on the server.