Want to develop and use applications with PHP and the MySQL database? Consider taking the MySQL and PHP: Developing Dynamic Web Applications training course.
Before taking this course you should:
This 4-day live, instructor-led course is perfect for developers who use PHP and MySQL to build and maintain their websites and who want to learn how PHP and MySQL can be used to rapidly prototype and[Read more...]
PHP users who attended any of my recent PHP&MySQL related talks or read Ulf's blog will know our mysqlnd_ms plugin. This plugin hooks into PHP's mysqlnd library and provides transparent support for replication and load-balancing features. Without changing your application you get transparent load-balancing and read-writ splitting so all your reading queries will be sent to a slave while the writes go to a master server. The exact strategies for that can be defined in mysqlnd_ms's configuration so quite often no, or only few application changes are needed. But we have one limitation: The MySQL servers have to be configured in each configuration on all your PHP servers, this can be annoying when you're changing your environment like adding a new slave or promoting a machine to master in case[Read more...]
Want to learn to develop next generation web applications on MySQL using languages such as Java and PHP; take the MySQL for Developers course. In this course you will learn to:
You can take this 5-day instructor-led course as a:
As a first step to developing your websites with MySQL and PHP, take the MySQL and PHP: Developing Dynamic Applications training course where you will learn to:
ConFoo is currently looking for web professionals with deep understanding of PHP, Java, Ruby, Python, DotNet, HTML5, Databases, Cloud Computing, Security and Mobile development to share their skills and experience at the next ConFoo. Submit your proposals between August 26th and September 22nd.
ConFoo is a conference for developers that has built a reputation as a prime destination for exploring new technologies, diving deeper into familiar topics, and experiencing the best of community and culture.
Installing Lighttpd With PHP5 (PHP-FPM) And MySQL Support On Fedora 19
Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a Fedora 19 server with PHP5 support (through PHP-FPM) and MySQL support. PHP-FPM (FastCGI Process Manager) is an alternative PHP FastCGI implementation with some additional features useful for sites of any size, especially busier sites. I use PHP-FPM in this tutorial instead of Lighttpd's spawn-fcgi.
Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Fedora 19
Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a Fedora 19 server with PHP5 support (through PHP-FPM) and MySQL support.
Installing Apache2 With PHP5 And MySQL Support On Fedora 19 (LAMP)
LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a Fedora 19 server with PHP5 support (mod_php) and MySQL support.
The MySQL for Developers course examines the tools used by MySQL development professionals. Expert instructors reference real-world examples when illustrating how to generate complex queries, and consume them in your application. This course covers Java and PHP languages.
You can take this course as:
If something is missing from the list please leave a comment and share your story. Thanks!Note: There is a poll embedded within this post, please visit the site to participate in this post's poll.
The post Poll: What programming languages and platforms do you use? appeared first on MySQL Performance Blog.
Learn to design web-based applications with MySQL and PHP - Developing Dynamic Web Applications. In this 4-day live, instructor-led class, you will learn to:
Join 7500 others and follow Sean Hull on twitter @hullsean.
There’s a lot of talk on the web about scalability. Making web applications scale is not easy. The modern web architecture has so many moving parts. How can we grapple with the underlying problem?
The truth that is half right. True there are a lot of moving parts, and a lot to setup. The internet stack made up of Linux, Apache, MySQL & PHP. LAMP as it’s called, was built to be resilient, dynamic, and scalable.[Read more...]
Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support (LEMP) On Ubuntu 13.04
Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 13.04 server with PHP5 support (through PHP-FPM) and MySQL support (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP) .
Installing Apache2 With PHP5 And MySQL Support On Ubuntu 13.04 (LAMP)
LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 13.04 server with PHP5 support (mod_php) and MySQL support.
The MySQL for Developers course teaches you the knowledge, skills, tools and issues involved in writing applications with the MySQL database server. It forms the core of the MySQL Developer learning path.
During this 5-day course, you will perform lab work with Java and PHP, connecting to MySQL databases and executing queries and stored routines. Enrolling in this course will simultaneoursly help you prepare for the Oracle Certified Professional, MySQL Developer certification.
You can take this instructor-led course as a:
If you execute
mysqli_multi() and later you try to execute
mysqli_result(), you may get the infamous error 2014:
Commands out of sync; you can't run this command now (
SQLSTATE: HY000). This happens because you didn’t free all resultsets before executing another query. But probably, you didn’t even know that any resultset exists, because you executed statements like
DELETE, or DDL.
Well, here is a function which frees all resultsets, and an usage example:
* Free all resultsets from $dbCon.
* @param mysqli $dbCon mysqli object.
Installing Apache2 With PHP5 And MySQL Support On Debian Wheezy
LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a Debian Wheezy server with PHP5 support (mod_php) and MySQL support.
Just went through all my PHP testing against a fresh instance of Oracle with Zend Server Community Edition 6, and found these warnings, guess that’s pretty clean for the Oracle part of the installation. I didn’t notice it before because generally I do most of my PHP development against a MySQL database. I should have been configuring the
php.ini file routinely, as qualified in this PHP forum discussion.
Warning: oci_set_client_info(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your[Read more...]
The PHPTek Conference bills itself as the premier professional PHP conference with a community flair. Having been to dozens of PHP conferences, I thought that was a pretty bold claim.
MySQL BoogiebotBut as they say in Texas, it ain’t bragging if you can do it.
MySQL plush dolphins and BoogieBots. The wind up dancing robots were popular in ChicagoAnd the organizers picked perfect weather for this Chicago based show.
The quality of the presenters and presentations was amazing high. Most of these sessions covered intricacies with the PHP language. The talks covered the range from[Read more...]
Whether you are a developer who wants to use MySQL and PHP to build and maintain websites or if you want to learn how MySQL and PHP can be used for the rapid prototyping and development of dynamic websites, the MySQL and PHP - Developing Dynamic Web Applications training course is for you.
This four day, live, instructor-led course is available as a:
Installing Apache2 With PHP5 And MySQL Support On OpenSUSE 12.3 (LAMP)
LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an OpenSUSE 12.3 server with PHP5 support (mod_php) and MySQL support.
Get the most out of your MySQL environment by learning to develop your new applications cost-effectively using MySQL with different languages such as Java and PHP.
The MySQL for Developers course is a 5 day, live, instructor-led course where you learn to:
You can take this course as a:
One of the great things of mysqlnd as a base library for PHP's MySQL support are the collected statistics. mysqlnd collects about 160 different statistical values about all the things going on. When having such an amount of raw data it, obviously, is quite hard to draw conclusions out of it. Therefore I recently created a PHP library sitting on top of this feature to collect all data, run some analysis and then provide some guidance and made it available from the JSMysqlndAnalytics GitHub repo (see there also for instructions for using Composer).
Using the library is relatively simple as the short instructions show. The library consists of two main[Read more...]
How To Run Your Own Web SMS Portal With PointSMS
This tutorial will show you how you can set up an SMS web site on CentOS using PointSMS.
Live from the PHP Summit conference in Munich: NoSQL in MySQL. A couple of hours ago I gave a talk about NoSQL in MySQL, contents: what is NoSQL, what is HandlerSocket, what is the InnoDB Memcached Plugin InnoDB and how to use with PHP, is this NoSQL? Slides are below.
The talk was called a night session. Night session means, its the last talk for the day. After eight hours packed with workshops everybody is a bit tired and exhausted. What else could I do but tell them[Read more...]
Take the MySQL and PHP - Developing Dynamic Web Applications course to learn to develop applications in PHP and how to use MySQL for those applications. This 4-day class helps you improve your PHP skills and combine them with time-proven database management techniques to create best-of-breed web applications that are efficient, solid and secure.
You can take this live instructor-led course as a:
Accessing Percona XtraDB Cluster nodes in parallel with MySQL asynchronous calls
This post is followup to Peter’s recent post, “Investigating MySQL Replication Latency in Percona XtraDB Cluster,” in which a question was raised as to whether we can measure latency to all nodes at the same time. It is an interesting question: If we have N nodes, can we send queries to nodes to be executed in parallel?
To answer it, I decided to try a new asynchronous call to send a[Read more...]