Something like an upgraded `EXPLAIN` command for browser. Highlights and explains MySQL queries. It gives also hints and links. Hope it will help
Render a graphical representation of a MySQL or SQLite database from a mysqldump or sqlite3 .dump file.
The original MySQL API is going away, deprecated by PHP in Version 5.5, with published statements that it will be removed in the future (see the red warning box). Since PHP 5.3 is now (February 2013) at end of life, and PHP 5.4 is current, the issues that will arise from the deprecation and removal are already before us. In fact, some parts of the API are already deprecated. It's time to think about making a change in our scripts. And if you're thinking about PHP 5.5, it's necessary to make the change now: "Please, note that this alpha version [php 5.5.0alpha2] also introduces the ext/mysql depreciation."
When you publish something online, there are not that many ways to determine whether people like what you have to say. Comments, the cornerstone of blogging, are too demanding, and users often prefer not to post one. If you’ve dropped by Behance, you’ve probably noticed their appreciate badge, which is a neat solution to this exact problem. With it people share their appreciation for somebody’s work.
Today we are implementing such a badge, which you can include in every page of your website with a bit of jQuery magic. So go ahead and download the zip from the button above (PSD included!) and continue with the tutorial.
J’ai récemment du faire une comparaison des données entre deux versions de la base MySQL de mon blog. En cherchant comment procéder le plus facilement possible, je suis tombé sur le le freeware Toad for MySQL : Toad est édité par Quest et l’acromyme signifie Tool for Oracle Application Developers. La version Toad for MySQL propose les mêmes fonctionnalités, mais pour la base de données opensource MySQL.
Voici une petite astuce pour mettre en cache les requetes mysql. Pour donner une idée du gain j’ai fait un petit script de benchmark, le gain à la lecture est plutôt convaincant. Je ne suis pas benchmarkeur de profession alors si il y en a dans la salle qui pensent que ce test n’est pas réaliste merci d’apporter votre contribution
DbNinja is an advanced web-based application for MySQL database administration and development. It's a must-have for those who wish to access their hosted servers remotely.
A CSV (Comma Separated Value) file is usually sufficient for exporting MySQL data as an Excel Spreadsheet. These CSV files are data only though. A real Excel spreadsheet has formatting, formulas and perhaps even graphics — the difference between a simple method of data transfer and a professional report.
For the past 40-some years, relational databases have ruled the data world. Relational models first appeared in the early 1970s thanks to the research of computer science pioneers such as E.F. Codd. Early versions of SQL-like languages were also developed in the early 70s, with modern SQL appearing in the late 1970s, and becoming popular by the mid-1980s.
Even in times of a growing market of specialized NoSQL databases, the relevance of traditional RDBMS doesn't decline. Especially when it comes to the calculation of aggregates based on complex data sets that can not be processed as a batch like Map&Reduce. MySQL is already bringing in a handful of aggregate functions that can be useful for a statistical analysis.
Vous n’avez jamais utilisé MySQL auparavant ? Commencez ici ! Cet article va vous guider à travers les principes mêmes des bases de données MySQL et SQL. Apprenez à installer MySQL, comment effectuer des transactions, et comment créer et utiliser des bases de données. Vous n’avez jamais utilisé MySQL auparavant ? Commencez ici ! Cet article va vous guider à travers les principes mêmes des bases de données MySQL et SQL. Apprenez à installer MySQL, comment effectuer des transactions, et comment créer et utiliser des bases de données.
Ready to get in and start learning about MongoDB, one of the coolest technologies for web developers?
In this new series, you’ll go from beginner to pro and be able to use Mongo just as easily as MySQL in your web apps. But first, let’s look at the basics.
We've covered PHP's PDO API a couple of times here on Nettuts+, but, generally, those articles focused more on the theory, and less on the application. This article will fix that!
To put it plainly, if you're still using PHP's old mysql API to connect to your databases, read on!
Xoops Engine is the next generation of XOOPS, designed as an application development engine for web and mobile. It is released under New BSD License and aims at building a sustainable ecosystem to benefit all contributors and user in technology and business.
Xoops Engine is actively developed by most active and talented XOOPS core developers led by Taiwen Jiang (a.k.a. phppp), who was Project Lead and Core Dev Lead for XOOPS from 2007 to 2011, core developer from 2005 to 2007.
Xoops Engine development is fully encouraged by support from XOOPS founder Ono Kazumi: "I hope that you keep on going with the development of XE, since there is no bright future ahead with X2."
The Uniform Server is a WAMP package that allows you to run a server on any MS Windows OS based computer. It is small and mobile to download or move around and can also be used or setup as a production/live server. Developers also use The Uniform Server to test their applications made with either PHP, MySQL, Perl, or the Apache HTTPd Server.
For any web application uploading an image is comman task. But what is the comman way to manage the uploaded files?
Generally what we do is place the uploaded file on specific folder and store the name of the image or some times path to image in VARCHAR field of the database table.
But this article is to cover the concept to store the image in mysql database. Later on we will discuss how to show the stored image from database to the web page.
This article is about to explain how you can manage database collation and character set of your database. If you are working on website which covers only one language which is english then you may not worry about these stuff.
But If you are dealing with the multilinguag website which includes various languages (chinese, hindi, gujarati, etc.) then you MUST need to take care of this stuff.
To make your database able to handle these characters of different languages you need to set proper Database Collation and Character Set for the database.