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 中文
Showing entries 1 to 30 of 850 Next 30 Older Entries

Displaying posts with tag: PHP (reset)

Installing Apache2 With PHP5 And MySQL Support On Fedora 20 (LAMP)
+0 Vote Up -0Vote Down

Installing Apache2 With PHP5 And MySQL Support On Fedora 20 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a Fedora 20 server with PHP5 support (mod_php) and MySQL support.

Install Apache2, PHP5 And MySQL Support On CentOS 6.5 (LAMP)
+0 Vote Up -0Vote Down

Install Apache2, PHP5 And MySQL Support On CentOS 6.5 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a CentOS 6.4 server with PHP5 support (mod_php) and MySQL support.

Use MySQL API Extensions to Create Dynamic Web Pages
Employee_Team +0 Vote Up -0Vote Down

To create dynamic web pages, you can use PHP, a server-side, HTML-embedded scripting language. PHP is available for most operating systems and can access the MySQL database. PHP provides MySQL API extensions, MySQL Improved Extension and MySQL Functions.

To learn more about using MySQL and PHP, you can consult the MySQL and PHP reference manual. You can also take the MySQL and PHP: Developing Dynamic WebApplications training course.

Through a hands-on approach, this 4-day instructor-led course

  [Read more...]
Deprecated mysqli Functions
+0 Vote Up -0Vote Down

Having noticed the release of PHP 5.5.10 last week while I was speaking at UTOUG, I checked the deprecated mysqli functions web page. There weren’t any deprecated by 5.5. Unfortuantely, there were six mysqli functions deprecated in 5.3 and removed in 5.4. Unfortunately, many of my posted code examples use 5.2 or 5.3 where they would have worked. The deprecated mysqli functions are:

  • mysqli_bind_param
  • mysqli_bind_result
  [Read more...]
On rumors of "PHP dropping MySQL"
Employee +1 Vote Up -0Vote Down

Over the last few days different people asked me for comments about PHP dropping MySQL support. These questions confused me, but meanwhile I figured out where these rumors come from and what they mean.

The simple facts are: No, PHP is not dropping MySQL support and we, Oracle's MySQL team, continue working with the PHP community.

For the long story we first have to remember what "PHP's MySQL support" includes. There key part are four extensions which are part of the main PHP tree:

  • ext/mysql
  • ext/mysqli
  • ext/pdo_mysql
  • ext/mysqlnd

The first one, ext/mysql provides the mysql_* functions. This is the classic interface taught in many (old) books and used by lots of (old) software. mysqli is "mysql improved", this is a younger

  [Read more...]
MySQL Image Architecture
+0 Vote Up -0Vote Down

The LinkedIn MySQL DB Development group posed a questions on how to handle images. Naturally, the argument always goes: Should images be deployed in the database or the file system? I believe they should be stored in the database because the cost and time associated is too high with regard to managing files, a file naming schema, and backing up the file system discretely from the database.

Since there’s a significant difference between the backup of transactional data and image data, they should be placed in different databases. The imagedb database is where you would place the images and large text descriptions, as shown in the MySQL Workbench ERD:

The imagedb ERD

  [Read more...]
MySQL Connectors, a Real Plus for Developers
Employee_Team +2 Vote Up -0Vote Down

MySQL Connectors provide connectivity to the MySQL server for client programs. APIs provide low-level access to the MySQL protocol and MySQL resources. Both Connectors and the APIs enable you to connect and execute MySQL statements from another language or environment. Oracle provides a number of these, enabling developers to build database applications in the language of their choice. Among those developed by Oracle are drivers for JDBC and ODBC. Any system that works with JDBC or ODBC can use MySQL. And you can find many more, including drivers for PHP, Perl, Python, Ruby, Tcl and even Eiffel!

To get a head start on developing with MySQL, take the MySQL for

  [Read more...]
ConFoo 2014 is at our door steps
+0 Vote Up -0Vote Down

ConFoo, the conference for web developers, is hosting its fifth edition. It will take place in Montreal at the Hilton Bonaventure on February 26th – 28th. These five days are packed with great technical talks and semi-private trainings on your favorite technologies.

It’s definitely a conference for IT professionals, wether you are a developer, integrator or project manager. With its 150 talks, you are sure to find a presentation that will help you grow your core skills. Among them you can find :

  • Mobile development
  • Cloud computing
  • Project management
  • Databases and big data
  • Development with PHP, Ruby, Java, DotNet, Python and Javascript
  • Web security

Meet the experts who crafted your

  [Read more...]
Correcting mysql.sock connection error
+0 Vote Up -0Vote Down

I write this post over to have a quick access to this tutorial than to promote the blog. The problem For Several times this has happened to me, always install a new server, or personal machine. I install mysql , and time to connect: The solution Simple and easy, look for the configuration file, my.cnf, make sure it is the same configuration file. Make a backup of it, to avoid any problem. My use is as ubuntu /etc/mysql/my.cnf Edit the uncompensated you will get the following lines: Ensure that the… Continue Reading →

Continue reading Correcting mysql.sock connection error

Related posts:
  • Corrigindo erro de conexão com
  •   [Read more...]
    MySQL - An Excellent Choice for a Low Cost Embedded Database
    Employee_Team +1 Vote Up -0Vote Down

    MySQL is an excellent choice for a low cost embedded database. Over 3,000 ISVs, OEMs and VARs choose MySQL for this purpose and benefit from significant cost savings when compared to using a competing database product.

    The MySQL for Developers training course teaches you how to plan, design and implement applications using MySQL. Expert Oracle University instructors teach you through realistic examples, interactive instruction and hands-on exercises.

    This course brings you lots of interesting facts. For example, the 'libmysqld' library is effectively a MySQL server in its own right. it is shipped as part of the standard MySQL installation. Developers with C/C++ ability can embed this library

      [Read more...]
    A book every php developer should read
    +0 Vote Up -0Vote Down
    Once upon a time, a long long time ago, when there was no Solr and lucene used to be a search engine api available for php developers to use, they used to struggle for using lucene. Most people reverted back to Mysql full text search. And some ventured into using sphinx - another free full text search engine. Then came Solr and php developers were thrilled with the ease of use over the http
    This Week in Website Performance
    +0 Vote Up -0Vote Down

    This Week in Website Performance is a weekly feature of the Monitis.com blog. It summarizes recent articles about website performance. How to make yourweb site better, how to improve your users experience when they come to your website and how to optimize the overall experience. Why? Because your friends at Monitis.com care.


    Improving website performance – 10 tips

    Author: palepurple.

    Discussed in this short article are 10 useful tips for a LAMP (Linux/apache/mySQL/PHP) based website. This is a nice round up of various tips seen in many similar articles. It’s a great way to get started if you are getting into performance optimization on this platform, or maybe it’s time

      [Read more...]
    MySQL, Best of Both Worlds with SQL and NoSQL
    Employee_Team +1 Vote Up -0Vote Down

    We are announcing the new MySQL for Developers course. This training:

    • Takes advantage of both SQL and NoSQL
    • Shows you how to plan, design and implement applications
    • Brings you realistic examples, interactive instruction and hands-on exercises using Java and PHP
    • Covers MySQL 5.6 features including optimizer improvements
    • Helps you prepare for the MySQL 5.6 Developer certification.

    You can take this course as a:

    • Live-virtual event: Take this course from your own office; no
      [Read more...]
    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...]
    Showing entries 1 to 30 of 850 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.