Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 867 Next 30 Older Entries

Displaying posts with tag: PHP (reset)

siamang: a web-based command-line client for mysql
+0 Vote Up -0Vote Down


because i have many more important things to be doing, i procrastinated by whipping up a little web-based command-line client for mysql. what does that mean? you load the webpage, start typing in sql commands, and it presents the results to you. it is just a weekend hack at this point, and has a lot of rough edges. it does have some cool features, though, like a persistent command-line history using Web Storage.

probably the biggest limitation is because it not maintaining a persistent connection on the backend, you can’t use variables, temporary tables or transactions.

it was really born because i was getting frustrated running queries





  [Read more...]
Develop and Use Applications with MySQL and PHP
Employee_Team +0 Vote Up -0Vote Down

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:

  • Understand how HTML files are assembled
  • Understand fundamental PHP syntax
  • Have some programming experience (preferably PHP)
  • Have some experience with relational databases
  • Have some knowledge of Object-Oriented Programming

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...]
Sharding PHP with MySQL Fabric
Employee +0 Vote Up -0Vote Down

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...]
Develop Next Generation Web Applications with MySQL
Employee_Team +0 Vote Up -0Vote Down

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:

  • Use MySQL tools to connect to databases.
  • Examine database structure and contents.
  • Generate database structure diagrams.
  • Execute complex queries.
  • Manipulate numeric, text, spatial and temporal data.
  • Execute complex subqueries and joins.

You can take this 5-day instructor-led course as a:

  • Live-virtual event: Take this course from your desk - no travel required. Choose from a wide selection of events on the schedule to suit
  [Read more...]
PHP and MySQL for Web Developers
Employee_Team +0 Vote Up -0Vote Down

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:

  • Describe the LAMP architecture
  • Use the basic components of PHP to build a foundation for more complex web applications
  • Understand the basic components of MySQL
  • Use SQL query commands to retrieve data from the MYSQL database
  • Change table data using the SQL Data Manipulation Language (DML) commands
  • Retrieve data from multiple MySQL tables using Joins
  • Create web based forms that interact with the end user and the data within MySQL
  [Read more...]
ConFoo: The conference for web developers is looking for speakers.
+0 Vote Up -0Vote Down

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.

  • ConFoo 2014 will be hosted on February 26-28 in Montreal, at the Hilton Bonaventure Hotel.
  • We take good care of our speakers by covering most expenses
  [Read more...]
Installing Lighttpd With PHP5 (PHP-FPM) And MySQL Support On Fedora 19
+0 Vote Up -0Vote Down

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
+0 Vote Up -0Vote Down

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)
+0 Vote Up -0Vote Down

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.

MySQL for Java and PHP Developers
Employee_Team +0 Vote Up -0Vote Down

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:

  • A Live-Virtual event: Take this course from your own desk, no travel required. Choose from a wide selection of events on the schedule to suit different timezones.
  • An In-Class event: Travel to an education center to take this class. Below is a selection of in-class events already on the schedule.

  [Read more...]
Poll: What programming languages and platforms do you use?
+1 Vote Up -0Vote Down

What programming languages and platforms do you use for large-scale projects in your organization?

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.

MySQL and PHP as a Foundation for Web Applications
Employee_Team +1 Vote Up -0Vote Down

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:

  • Design schemas based on MySQL
  • Use include files to make code easier to maintain
  • Use PHP 5 and takes advantage of its advanced features
  • Build applications following a precise flow
  • Authenticate users in a secure way against a database
  • Handle errors in your PHP applications efficiently and gracefully
  • Writes composite queries using JOINs and subqueries
  • Use indexing efficiently in order to manipulate large amounts of data
  [Read more...]
Scalability Happiness – A Quiet Query Log
+0 Vote Up -0Vote Down

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?

Also: Why Are MySQL DBAs So Hard to Find?

The LAMP stack scales well

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
+0 Vote Up -0Vote Down

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)
+0 Vote Up -0Vote Down

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.

Java and PHP Developers, Learn about the MySQL Database
Employee_Team +1 Vote Up -0Vote Down

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:

  • Live-virtual event: Take this class live, from your own desk. No travel required. You can choose from a wide selection of events on the schedule
  [Read more...]
MariaDB/MySQL: “Commands out of sync” error (2014)
+0 Vote Up -0Vote Down

Versione italiana

If you execute mysqli_multi() and later you try to execute mysqli_query() or 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 INSERT, DELETE, or DDL.

Well, here is a function which frees all resultsets, and an usage example:

<?php
    
/**
 *	Free all resultsets from $dbCon.
 *	@param		mysqli		$dbCon	mysqli object.
 *

  [Read more...]
Database library to handle multiple masters and multiple slaves
+0 Vote Up -0Vote Down
In a large scale mysql deployment there could be multiple masters and multiple slaves. Masters are generally in circular replication. And are used for running all inserts, updates and deletes. Slaves are used to run selects. When you are dealing with multiple mysql instances running in a large scale environment, it is important to take care of lags between masters and slaves. To handle such
Installing Apache2 With PHP5 And MySQL Support On Debian Wheezy
+0 Vote Up -0Vote Down

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.

Zend 6 & Timezones
+0 Vote Up -0Vote Down

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...]
PHPTek
Employee +1 Vote Up -0Vote Down

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 Boogiebot

But 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 Chicago

And 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...]
UTF 8 in MySQL+PHP+HTML
+0 Vote Up -0Vote Down

This little guide will describe the steps you have to take to use utf-8 in a complete web application using MySQL and PHP. The Database You have to specify the utf8 character set on all tables and text columns in your database. This will ensure that MySQL stores and retrieves the values encoded in UTF-8. [...]
MySQL is Better Than Ever for the Web
Employee_Team +1 Vote Up -0Vote Down

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:

  • Live-virtual event: You can take this course from your desk - no travel required. Choose from a selection of events already on the schedule.
  • In-class event: Travel to an education center to take this course. Below is a selection of of the events already on the schedule.

 



  [Read more...]
Installing Apache2 With PHP5 And MySQL Support On OpenSUSE 12.3 (LAMP)
+0 Vote Up -0Vote Down

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.

Learn to Develop Your New Applications on the MySQL Database
Employee_Team +2 Vote Up -0Vote Down

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:

  • Use MySQL tools to connect to databases.
  • Examine database structure and contents.
  • Generate database structure diagrams.
  • Execute complex queries and stored routines.
  • Manipulate numeric, text, spatial and temporal data.
  • Execute complex subqueries and joins.

You can take this course as a:

  • Live-Virtual Event: Take this course from your own desk - no travel required. Choose from one of the many events
  [Read more...]
Making use of PHP mysqlnd statistics
Employee +1 Vote Up -0Vote Down

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
+0 Vote Up -0Vote Down

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.

PHP Summit presentation: NoSQL in MySQL
Employee +2 Vote Up -0Vote Down

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.

NoSQL in MySQL from Ulf Wendel

(PDF download)

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...]
Learn to Develop Dynamic Web Applications with MySQL and PHP Training
Employee_Team +0 Vote Up -0Vote Down

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:

  • Live-virtual event: Take this class from your own desk, choosing from many events on the schedule to suit different time-zones.
  • In-class: Travel to an education center. Some events already on the schedule include:

  [Read more...]
Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
+2 Vote Up -0Vote Down

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...]
Previous 30 Newer Entries Showing entries 31 to 60 of 867 Next 30 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.