Elastic Theme Editor | Change the way you think about WordPress themes
Top 20+ MySQL Best Practices
Database operations often tend to be the main bottleneck for most web applications today. It's not only the DBA's (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. In this article, I'll list some MySQL optimization techniques for programmers. Before we start, be aware that you can find a ton of useful MySQL scripts and utilities on Envato Market. Most MySQL servers have query caching enabled. The main problem is, it is so easy and hidden from the programmer, most of us tend to ignore it. The reason query cache does not work in the first line is the usage of the CURDATE() function. Using the EXPLAIN keyword can give you insight on what MySQL is doing to execute your query. The results of an EXPLAIN query will show you which indexes are being utilized, how the table is being scanned and sorted etc... After adding the index to the group_id field:
Free Address Book Script ( PHP + MySQL )
Ver 1.18 ( Security patch applied ) This is a free Address Book PHP script with a MySQL database. This script allows users to search, view, add, edit, and delete address entries from a web browser. Each user can have a different login username. It's very easy to add/remove fields to/from the script. You can customize Address Book Script online and/or manually. To manually customize it, please see Customization Quick Guide. To customize online, use Address Book Builder, which guides you through the steps of building a custom version of Address Book Script. Ajax Fileup Addon for Address Book Script Monday, August 12, 2013 Address Book Script: Converting a Text Field to a Date Field To convert a text field to a date field, open web/codelib/asc/df.fl. The following example is a typical text field definition: (example) 'last_name'=>array( XA_CLASS=>'CVText', XA_CAPTION=>RSTR_LAST_NAME, XA_SIZE=>24, XA_REQUIRED=>false, XA_MIN_CHAR=>0, XA_MAX_CHAR=>36, XA_SEARCH_OP=>'s%', XA_LIST=>'(sp)(sr)(fd)' ), <? <!
Got my first part-time consulting contract, now what? « Bhavin Gandhi's Blog
I can’t believe, it had been a whole week since I wrote my last blog. This week was really busy with lot of sleepless nights and lot of ice tea. Working full-time and consulting part-time is not an easy task. I would not recommend you to consult a business part-time, if you can’t keep up with all of your appointments in your outlook calendar. Anyways, I am not here to tell you how to manage your time well (at least not in this blog). Before I start, I would like to thank my readers to read my blog and sending their replies through e-mails and comments. I do management consulting on part-time basis, so most of my views would be helpful to part-time consultant instead of those full-timers. Communication, communication, communication: This is the key element of every consulting business. Leverage technology: If you are a part-time consultant like me, then you want to be transparent about your progress with your clients. I hope my article was helpful, and I am eager to hear your feedback.
Getting Started with CRUD In PHP
It has become a common necessity for website owners to collect data and manage it properly. Creating a MySQL CRUD class allows you to conveniently create, read, update and delete entries for any of your projects, indifferent of how the database is devised. CRUD allows us to generate pages to list and edit database records. So, in this tutorial I will show you how to build a simple CRUD web app, that will empower you with the basic functions of database management. In this article I will discuss following things:- • Creating the database • Creating the table • Make connection to the database • Insert records in table • Update records table • Delete records from table The tools I will be using are:- • XAMPP • Dreamweaver CS5 (you can use Notepad++ or any other IDE) Before continuing with the tutorial I would like to discuss the following definitions: • What is CRUD? What is CRUD? CRUD stands for create, read, update, delete. What is database? What is table? What is XAMPP? Code of Index.php file
Put icon inside input element in a form
TCPDF - PHP Class for PDF
It appears that you are using AdBlocking software. The cost of running this website is covered by advertisements. If you like it please feel free to a small amount of money to secure the future of this website. <div style="font-family:helvetica,arial;font-size:small;padding:0 4px 0 4px;background-color:#FFFFCC;color:#003399;border:1px;border-style:solid;border-width:1px;border-color:orange;"><form action=" method="post"><div><input type="hidden" name="cmd" value="_donations" /><input type="hidden" name="business" value="paypal@tecnick.com" /><input type="hidden" name="lc" value="US" /><input type="hidden" name="item_name" value="Tecnick.com" /><input type="hidden" name="no_note" value="0" /><input type="hidden" name="currency_code" value="GBP" /><input type="hidden" name="bn" value="PP-DonationsBF:btn_donate_SM.gif:NonHostedGuest" /> It appears that you are using AdBlocking software. PHP class for generating PDF documents skip navigation menu
TUTORIAL: How to install PHP and MySQL on IIS
With the apparent increase of interest in individuals desiring to install PHP and MySQL on computers running Windows operating systems, I thought it would be beneficial to provide a set of instructions to help make this process as easy as possible. In this article, I’ll be providing some basics of IIS installation and then move to the installation of PHP and MySQL. Some essentials you will need to get started:IIS (preferably IIS 5 or IIS 6)The PHP windows installer file The PHP binaries fileThe MySQL Windows installation file(links will be provided for the downloads shortly). Optional:phpMyAdminMySQL Administrator Let’s get started. Since you are installing on a Windows computer, you will most likely be using IIS for a web server, however, it is not required. Some things to know about IIS. If you haven’t already done so begin by installing IIS. It really shouldn’t matter whether you install PHP first or MySQL first. Then go to your web browser and type: . mysql>
How to write a FaceBook Application in 10 minutes
Writing F8 apps is where it’s at right now. Everybody knows it. The userbase is huge and now we have a (free) API to. Everything is good….but the documentation. I spent a day writing my Sudoku Facebook application yesterday. I already had the sudoku javascript widget ready to go - the time was spent wading through pages of documentation and downloading toolkits that (as it turns out) I didn’t need. As far as I can tell, Facebook allows you to create applications that appear to the user in 2 different areas. 1 - The profile. 2 - The ‘Canvas page’. Ok, thats it for the overview. 1. <script type=text/javascript> var iRandom; function Restart() { iRandom = Math.floor(Math.random()*10)+1; alert('OK, I am thinking of a number between 1 and 10'); } function Guess() { var yourGuess = document.getElementById('myGuess').value; if (yourGuess>iRandom) alert('Too High.'); if (yourGuess<iRandom) alert('Too Low.'); if (yourGuess==iRandom) { alert('Well done! Ok, now log into Facebook. 2. 3. 5. 6.
