Content
Archive for the ‘PHP and MySQL’ Category
PHP and MySQL are core pieces of software primarily used for web development. They are often paired with Linux and Apache resulting in a configuration called LAMP (Linux Apache MySQL PHP).
PHP and MySQL are not only solid, but open-source which is easy on developers, and they are relatively simple which is wonderful for developers.
PHP is a double-redundant acronym, standing for Personal Home Page Hypertext Processor
by php-love
When trying to optimize the performance of your MySQL database, the first thing you try is often the most futile:
Table Optimization.
We put this first because it’s often the first “fix” people arrive at when trying to fix performance problems, but we think it’s almost never the solution, so we want to get that out of the way first. Generally speaking, most Mysql tables are created in a very optimum way. 5-10 years ago that wasn’t necessarily the case, however these days most problems are caused at the application-level or table-desgin-level (aka. Improper use of tables or improper table structure). It might be worthwhile to skip this article, but it’s a good idea to keep Table Optimization in mind, just don’t assume that’s going to be some magical fix. (more…)
Tags: index, magic, magic fix, mysql, optimize, performance, php, the rule
Posted in Hardware, Performance, PHP and MySQL, Programming, Servers, Software, Web Development | Comments Off
by php-love
MySQL is the subject of a common debate: How to pronounce it properly. The proper pronunciation of MySQL is:
“My S-Q-L”
Many people use the short-hand version
“My Sequel”
This is 100% wrong, and the only correct way to say it is the first way – “My S-Q-L”.
Okay, if you are frustrated with what I’ve said, just calm down and realize the sarcasm. Nobody cares how you pronounce it, there is no “correct” way, just say it how you wanna say it.
Tags: mysql
Posted in Glossary, PHP and MySQL, Programming | Comments Off
by php-love
I love lamp.
LAMP programming has been around for many years. Although there are many variations, it normally stands for:
Linux Apache Mysql Php
Through the years, there have been many variations. For a long time, until PHP became popular, the P stool for Perl. Some people might argue that the P stands for Python. Eh, not really, PHP is much, much more widely used. (more…)
Tags: apache, lamp, linux, mysql, php, programming
Posted in Frameworks, Glossary, Linux, PHP and MySQL, Programming, Servers, Web Development | Comments Off
by php-love
If you’re problem is your SQL, chances are you’re going to go about fixing it the wrong way. What is the “wrong way”? Trying to optimize Mysql settings is often a sign that you’re heading in the wrong direction. What should you do? Look at your SQL. Yes, just look at it.
That’s assuming you know what SQL is the problem. If you aren’t quite sure, try looking into Mysql’s Slow Query Log. Also use “mysql -e” or “mysqladmin processlist”. Maybe even make a cron to monitor this so you can go back and look at the logs. Bottom line: figure it out yourself, that’s not for this article. (more…)
Tags: join, mysql, performance, sql
Posted in Code Snippets, Frameworks, Linux, Performance, PHP and MySQL, Programming, Software, Troubleshooting Tips, Web Development | Comments Off
by php-love
A SLD or “Second Level Domain” is all often called the “domain” or “base domain.”
Most of the time when people buy a domain, they are buying a Second Level Domain. To get even more specific, they are buying a SLD + TLD combination.
When a ccSLD – or “country code Second Level Domain” – is used, then a user will actually be buying a third level domain.
ccSLDs can make it difficult for developers to deal with domains, in the sense that many developers have to parse out URLs for many reasons, but there is no hard set rule on how to parse a domain out. You just have to have a comprehensive list of all ccSLDs and their corresponding ccTLDs in order to properly distinguish the users “base domain” from their “domain extension.”
Tags: domain, parse, tld
Posted in Domains, Glossary, PHP and MySQL, Servers, Web Development | Comments Off
by php-love
How do I use PHP’s parse_url() function to separate out the base domain from the domain extension?
How do I use PHPto extract the domain from a URL?
How do I extract the domain when it is using a ccSLD, or “country code second level domain”, such as .com.au and .co.uk?
PHP’s parse url function is quite handy, but not all powerful, and it cannot distinguish between domains and subdomains. (more…)
Tags: domain, parse, php, tld
Posted in Code Snippets, Domains, Glossary, PHP and MySQL, Programming, Web Development | Comments Off
by php-love
“Deprecated” is a term used in programming to describe when a function or other feature should no longer be used.
Because of the fact that the term “deprecated” is fairly industry-specific to programming, we choose instead to call it “decapitated”. We think this is a more accurate description.
“Deprecated ” is often used in PHP because of he numerous iterations PHP has gone through. PHP describes many functions as deprecated because they were used in PHP 4 but were dumped in PHP 5. PHP also has many significant upgrades between version – subversions that have many more differences than average. PHP 5.3 is a great example of this, but there are many more significant sub-versions. (more…)
Tags: decapitated, deprecated, html, Javascript, mysql, php, programming
Posted in Android, Frameworks, Glossary, HTML and CSS, JavaScript and AJAX, PHP and MySQL, Programming, Troubleshooting Tips, Web Development | Comments Off
by php-love
Tags: simple, simplify, the rule
Posted in Android, Code Snippets, Domains, Frameworks, Glossary, Google, HTML and CSS, JavaScript and AJAX, Linux, Personal Computer, PHP and MySQL, Programming, Security, SEO and Rankings, Servers, Troubleshooting Tips, Web Development, Windows | Comments Off
by php-love
There are a variety of web frameworks out there. Some are called “Platforms”, and are usually more complex. Here are a few examples:
- CodeIgniter
- Zend Framework
- Joomla
- Plone
- Drupal
- CakePHP
- Yii Framework
- Symfony
- PHP Nuke
So which one is right for me? (more…)
Tags: application, develop, framework, php, platform, simple
Posted in Frameworks, HTML and CSS, JavaScript and AJAX, Linux, PHP and MySQL, Programming, Servers, Web Development | Comments Off
by php-love
Some people ask “How do I use PHP and MySQL to create a mobile app?”.
You might be asking this because you are a programmer who wants to streamline their apps as much as possible and put some of the workload on your server. Maybe you are new to programming and want to use your newly honed PHP/MySQL skills. Or may you are a business manager who doesn’t want your programmers to waste a bunch of time learning new languages. (more…)
Tags: android, app, integrate, mobile, mysql, php
Posted in Android, Google, HTML and CSS, JavaScript and AJAX, PHP and MySQL, Programming, Troubleshooting Tips, Web Development | Comments Off
