PHP Advanced Database Class

i found this class very useful for php mysql development. you can use this class to sped up your php development.

usualy if you want to make a query to a table in your database you need to:

1. make the connection to database
2. add the query (eg. $sql = select * from table)
3. add the ($result = mysql_query($sql)) line
4. then (while($row = mysq_fetch_array($result)){….})

now when you use this class, you do it like this:

 

// Include the class:
include("db.class.php");

// Open the base (construct the object):
$db = new DB($base, $server, $user, $pass);

// Commonly, you can copy/paste this code for one query at a time:
$db->query("SELECT * FROM People");
while ($line = $db->fetchNextObject()) {
  use($line->aField);
}

although you can use $db->query("SELECT * FROM People",true); this will enable debug mode, so if there is an error you will got a help on your error.

for more information please visit the main site

you can download the class from here

SQL Maestro for MySQL v8.3

SQL Maestro for MySQL is the premier MySQL admin tool for database management, control and development. Key features include:

• Easy database object management
• Database Designer
• Data management: viewing, editing, grouping, sorting and filtering abilities
• Handy SQL Editor with code folding, syntax highlighting, and multi-threading
• Visual Query Builder
• Possibility to connect to remote servers via SSH or HTTP tunnel
• Data export/import to/from the most popular formats
• Powerful BLOB Viewer/Editor

The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, compose OLAP cubes, and much more.

Easy installation and intuitive interface in combination with support of all the MySQL latest features make it an irreplaceable tool for MySQL on the web or at your local desktop.

SQL Maestro for MySQL provides an ability to manage queries in the same way as if they were database objects. This means that you can view queries in the explorer tree, use them in BLOB Viewer and Diagram Viewer, perform drag-and-drop operation upon them, copy them to clipboard like you copy an object, an so on. To be able to manage a query as an object, you should save the query to database profile using the corresponding item of SQL Editor or Visual Query Builder. After that the query will appear in the explorer tree.

size: 20MB

download here

30 Google Chrome tips, tricks and shortcuts

1. Create desktop and Start menu shortcuts to web apps such as Gmail - go to Gmail.com and then select Create application shortcuts... from the Page Control menu (in the top-right corner of your browser - it looks like a page with the corner folded over). Now choose where you want to place your shortcut. This works for other Google apps such as Calendar and Documents, and other services such as Windows Live Hotmail.

2. Control + Shift + N opens an 'incognito' window - sites you view in this window won't appear in your history and cookies served by sites in this window will be deleted when the window is closed.

3. You can open a link in an incognito window by right-clicking the link and selecting Open link in incognito window.

4. Alt + Home loads your Google Chrome home page, with thumbnails of your most visited sites shown in the active tabbed window.

5. Control + T opens a new tab. You can drag tabs around to change their order or drag a tab out of the window into its own window.

6. Control + Shift + T opens your most recently closed tab. Press the key combination again to open the tab closed before that one. Google Chrome remembers the last 10 tabs you've closed.

7. Jump to different open tabs using Control + 1, Control + 2, Control + 3, etc. Control + 9 takes you to the last tab.

8. Control + Tab lets you cycle through your open tabs in order.

9. Control + Shift + Tab cycles through your tabs in the opposite order.

10. As with Firefox 3, you can drag a link onto a tab to open it in that tab, or drop it between two tabs to open a new tab in that position.

11. To bookmark a site click the star on the left of the address bar and then select a folder to add it to.

12. Control +B hides the Google Chrome bookmarks bar. Press Control + B to bring it back again.

13. Right-click or hold down the back button and you'll get a drop-down list of sites to go back through. Show Full History, at the bottom of the list, opens a new tab with your full browser history.

14. Control + H is a faster way to bring up the History page.

15. You can delete history for chosen days by scrolling to the day you want to delete and clicking Delete history for this day on the right-hand side of the window.

16. Control + J brings up your Downloads page.

17. To clear an item from your Downloads page, right-click an entry and select Remove.

18. Press Control + K or Control + E to search from the address bar. Once pressed, you'll see a ? symbol appear in the address bar and you can simply enter your search query and hit Return.

19. Right-click the top of the browser window and select Task manager to see how much memory different tabs and plug-ins are using. Highlight one and click End process to stop it running.

20. Shift + Escape is a quicker way to bring up the Google Chrome Task manager.

21. To see what plug-ins are installed, type about:plugins into the address window.

22. You can also type the following commands into the Google Chrome address window: about:stats, about:network, about:histograms, about:memory, about:cache, about:dns.

23. Type about:crash to see what a crashed tab looks like.

24. A three-second diversion: type about:internets. (Only works in Windows XP.)

25. Edit any web page - right-click a page and select Inspect element. Now edit the HTML source code and hit Return to view the changes.

26. To make Google Chrome your default browser, click the Tools button (in the right-hand corner of the browser window - a spanner icon). Select Options, click the Basics tab and then click the Make Google Chrome my default browser button.

27. To delete cookies, go to Tools > Options > Under the Hood. Scroll down to the Security section, and click Show cookies. Now you can click Remove all or remove individual cookies.

28. To clear more data such as the Google Chrome browsing history and cache, click the Tools icon and select Clear browsing data...

29. To clear the most visited web sites that appear on your Google Chrome start page, you must clear your browsing history using the method above.

30. Clearing your Google Chrome browser history will also stop matches from previously browsed sites appearing as suggestions in your address bar.

By Paul Douglas

 

via http://www.techradar.com/

10 ways to make Chrome as good as Firefox - How to get the best Firefox features in Chrome today

i have found this article interesting from http://www.techradar.com

The Google Chrome browser is designed to be lightweight in comparison to what it perceives are bloated offerings from Microsoft and Mozilla among others.

For some, however, it's too lightweight.

So if you've put off switching due to Chrome lacking key features that you've come to rely on in other web browsers, then read on to discover 10 easy ways you can plug the functionality gap.

1. Enhance RSS support
Want to detect RSS feeds in Chrome and then subscribe to them through a third-party reader? Browse to savanttools.com/feedhelp-bookmarklet.asp and drag the 'Detect Feed' link on to your Bookmarks toolbar. Click this on any page with a RSS feed and you can then easily subscribe to the feed through one of nine supported readers, including Google Reader, Newsgator and iTunes.

2. Secure passwords manager
Chrome doesn't encrypt your saved passwords; neither does it provide a master password to prevent other users from using them or viewing them. Use the free KeePass tool to store and fill your passwords.

3. Social bookmarking
Thanks to Chrome's support of bookmarklets, you won't be left behind in the cut-throat world of social networking. Just drag and drop the links provided at the URLs below on to your Bookmarks bar for easy updates:
ShareThis
Digg
Share the current page via Twitter
Update your Twitter status quickly

4. Synchronising bookmarks
If you want to use Chrome on multiple PCs, keeping your bookmarks synchronised between them is tricky. Foxmarks has reiterated its intention to develop a version for Chrome, but in the meantime use Google's own web-based bookmarks service in place of Chrome's own bookmarks. Use the bookmarklet from orizens.com/wp/topics/google-bookmarks-bookmarklet to access your Google bookmarks from a pop-up window.

5. Block ads in Chrome
The simplest way to block ads in Chrome is to use a third-party program called Hostsman. Once installed, choose Hosts > Check for Updates and add MVPS Hosts, Mike's Ad Blocking Hosts and Peter Lowe's AdServers List.

6. Use mouse gestures in Chrome
Missing Firefox's mouse gestures? Add this functionality to Chrome with the lightweight, but infinitely customistable, gMote tool, which you can download from www.handform.net/gmote.php.

7. Open a blank new tab
Don't want to see the Most Visited page appear on opening a new tab? Type 'about:blank' into the address bar. Drag this on to your bookmark's toolbar, and then hold [Ctrl] + [Shift] when you click this to open a blank new tab.

8. Change your Chrome theme
If you're tired of Firefox's look, you can get another by installing a new skin. Chrome doesn't have built-in support for swapping out themes, but it's easily done by changing the default.dll file. You'll find more than 20 alternative themes (including one that mimics Firefox) at freechromethemes.com, or you can find out how to create your own with the help of the tutorial at askvg.com.

9. Anonymise Chrome
Each installation of Google Chrome has a unique identifier that could potentially be used to identify you. It's not necessary for Chrome to function, so if you're the paranoid type, download UnChrome from www.abelssoft.net/unchrome.php, which will replace your identifier ID with zeroes.

10. Check for updates
Chrome is in a constant state of evolution, and new features that close the gap on other browsers will be made available in version 2. If you can't wait to zoom into and out of web pages or autoscroll using the middle mouse button, use autocomplete in web forms, set up up multiple profiles or import bookmarks from Google Bookmarks, then visit dev.chromium.org/getting-involved/dev-channel for instructions on trying the beta version.

PHP designer 2008 6.2.4

phpDesigner 2008 is your PHP IDE and PHP editor for all your PHP and Web development with support for PHP object-oriented programming, PHP frameworks, debug with Xdebug, remote ftp-editing and hundreds other cool features!

Introduction

phpDesigner 2008 is today's PHP IDE and PHP editor - the complete integrated development environment for PHP for both beginners and professional developers that help you boost the process of editing, analyzing, debugging and publishing applications and websites powered by PHP and other web languages!


Boost your productivity

phpDesigner 2008 is designed to boost your productivity and simplify complex coding projects through intelligent set of editing tools that includes full support for PHP4/PHP5, syntax highlighters, highlighting of matching tags/braces and numerous tools and wizards to speed of your development!


Intelligent syntax highlighting

The intelligent syntax highlighter in phpDesigner 2008 makes it the ideal development environment for AJAX developers. Automatic switch between syntax highlighters for PHP, HTML, CSS, and JavaScript dependant on your position in the file and dim the rest of the code!


PHP, HTML, CSS, JavaScript and more...

phpDesigner 2008 has the WAMP and LAMP developer in mind. The strength in PHP lies in the ability to embed it into- and together with other web-languages and technologies.



Therefore, does phpDesigner 2008 not only support PHP but also other web-languages as HTML, XHTML, MySQL, XML, CSS, JavaScript, VBScript, Java, C#, Perl, Python and Ruby!


PHP Object-oriented programming (OOP)

In phpDesigner 2008 you can work with object-oriented programming (OOP) in PHP5, nested code completion and have code tip displayed as you type so you do not need to look into documentation to see classes and function attributes!


Work with projects and PHP frameworks

In phpDesigner 2008 you can work with projects and integrate any PHP framework into your project and access all your files, classes, functions, interfaces, variables and constants declared in your project on the fly!


Real debugging using Xdebug

Debugging has never been easier with the new integration of Xdebug in phpDesigner 2008.

Analyze your code step by step using breakpoints, watches, evaluations etc. Find bottlenecks in your code or see which parts of your code are slow and could use a speed boost with the profiler support!


Learn PHP

Explore the world of PHP and shorten the learning curve with detailed information about more than 3000 native PHP functions on the fly!


Enjoyable to use for hours and hours!

The philosophy behind phpDesigner 2008 is to make it, enjoyable to use for hours and hours for both beginners and professional developers through an easy-to-use-, intuitive-, customizable- and tabbed interface!

download version: 6.2.4