websitetoapps.com

phpmysqlscript.com

PHP MySQL Script: Detecting user's screen size and resolution

http://www.phpmysqlscript.com/2012/03/detecting-users-screen-size-and.html

A 5 Day Course. Detecting user's screen size and resolution. If you're developing a site, you should carefully consider how your web pages appear on different kinds of screens. Today people access website on devices with different types of screens, you should account for some factors that affect the way your web pages appear on these devices. Php if(isset($ COOKIE["device resolution"]) $screen res = $ COOKIE["device resolution"]; else / cookie is not found set it using Javascript {? Thank u so much.

phpmysqlscript.com

PHP MySQL Script: Kill a blocking (long running) sql statement

http://www.phpmysqlscript.com/2012/03/kill-long-running-blocking-sql.html

A 5 Day Course. Kill a blocking (long running) sql statement. You can use the command line tool mysqladmin to view processes which returns the processes with their IDs. Then use the kill option of mysqladmin to kill your blocking process by its process ID. Get process ID of blocking process */ mysql/bin mysqladmin -uroot -p processlist /* kill it */ mysql/bin mysqladmin -uroot -p kill PreceessID. If you are using mysql client tool and already logged in as root user. Subscribe to: Post Comments (Atom).

phpmysqlscript.com

PHP MySQL Script: Export data to CSV from MySQL

http://www.phpmysqlscript.com/2011/12/export-csv-directly-from-mysql-query.html

A 5 Day Course. Export data to CSV from MySQL. Many times I get request from client for data dump. I use mysql database, and in mysql it is quite. Easy to create CSV files directly from MySQL with just one query! Let's say you want to export the email and name fields from your member table to a CSV file. Here is your code:. SELECT email, name INTO OUTFILE '/tmp/data dump member.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY ' n' FROM member. Subscribe to: Post Comments (Atom).

phpmysqlscript.com

PHP MySQL Script: MySql Commands

http://www.phpmysqlscript.com/p/mysql-commands.html

A 5 Day Course. Basic Tutorial Examples to Learn MySQL. Just make sure that you have installed MySQL database server with xampp and have a valid username and password to access. So developers get ready to learn MySQL within couple of hours. End of the tutorial you can do:. Create and Drop Database. Create, Alter, Truncate and Drop Table. Select, Insert, Update and Delete rows. Group by, Order by, Having, Union, Distinct. Add, drop index, Explain command. Database backup with mysqldump or mysqlhotcopy.

phpmysqlscript.com

PHP MySQL Script: MySql Slow Queries

http://www.phpmysqlscript.com/2012/03/mysql-slow-queries.html

A 5 Day Course. MySQL has a slow query log which can be enabled if you want to identify the queries that are causing problems for a website or application. Checking slow queries is one of the most important steps in optimizing and tuning mysql. This article shows how to identify those 'slow queries' that need special attention and proper optimization. First let’s check on the server if slow query logging is enabled on MySql. Enable the slow query log. Mkdir /var/log/mysql touch /var/log/mysql/log-slow-qu...

phpmysqlscript.com

PHP MySQL Script: A 5 Day Course

http://www.phpmysqlscript.com/p/5-day-course.html

A 5 Day Course. A 5 Day Course. A basic working knowledge of HTML is presumed. Some conceptual knowledge of how web servers and web browsers (clients) interact using HTTP. A working knowledge of at least one scripting/programming language or evidence of strong capabilities in relevant areas of mathematical/logical reasoning. Comparison with dynamic content alternatives (Perl, CGI, ASP, JSP, Servlets , CGI, etc). PHP tools and set up (web browser/server, editor, libraries, etc). Create a basic PHP Script.

phpmysqlscript.com

PHP MySQL Script: Basic Examples to Learn MySQL

http://www.phpmysqlscript.com/2012/03/basic-examples-to-learn-mysql.html

A 5 Day Course. Basic Examples to Learn MySQL. Just make sure that you have installed MySQL database server with xampp and have a valid username and password to access. So developers get ready to learn MySQL within couple of hours. End of the tutorial you can do:. Create and Drop Database. Create, Alter, Truncate and Drop Table. Select, Insert, Update and Delete rows. Group by, Order by, Having, Union, Distinct. Add, drop index, Explain command. Database backup with mysqldump or mysqlhotcopy. Usually /va...

phpmysqlscript.com

PHP MySQL Script: How to Redirect a Web Page

http://www.phpmysqlscript.com/2011/11/how-to-redirect-web-page.html

A 5 Day Course. How to Redirect a Web Page. This post describes how to properly redirect a web page using an HTTP 301 status code and Location header. The 301 status code is used to indicate that a page has permanently moved. 301 redirect is the most efficient and Search Engine Friendly method for webpage redirection. PHP redirect tells the browser (or a search engine bot) that the page has been permanently moved to a new location. Subscribe to: Post Comments (Atom). Sunday, November 27, 2011. This post ...

phpmysqlscript.com

PHP MySQL Script: SQL injections

http://www.phpmysqlscript.com/2011/11/sql-injections.html

A 5 Day Course. What is SQL Injection? SQL injection is defined as a technique that takes advantage of non-validated input vulnerabilities and inject SQL commands through a web application that are executed in a back-end database. Programmers use sequential SQL command with client supplied parameters making it easier for attackers to inject commands. Attackers can easily execute random SQL queries on the database server through a web application. How does it work? How to retrieve any data? SQL injection ...

phpmysqlscript.com

PHP MySQL Script: Interview Quesions

http://www.phpmysqlscript.com/p/interview-quesions.html

A 5 Day Course. It stands for "Hypertext Preprocessor". It is an open source server-side scripting language that helps developer to create dynamic content with the help of database like mysql. What is a Cookie? A cookie is a small text file that created on your hard disk when your browser accesses a website that uses cookies. The stored information can be used by browser to rember all its features like logins, preferences, language settings, themes, among other common features. Define("VERSION",1.0);.