background preloader

PHP Editor Review - PHP IDE

PHP Editor Review - PHP IDE
Learning SQL Using phpMyAdmin Structured Query Language is a non-procedural language used to define, manipulate and retrieve data. It was developed by IBM (System/R project) in 1974-1979. The specific data architecture addressed by SQL is called the relational architecture. In this article, we will use MySQL, a popular open-source implementation of SQL that is deployed by most Web host providers. To be able to do the exercises in this guide, you will need an access to a MySQL server. This guide will show you the SQL syntax, sometimes by asking you to enter statements, and sometimes by letting you see how phpMyAdmin generates SQL statements based on your actions using the interface. We will use a geographical information system as an example. The table creation is accomplished with the CREATE TABLE statement, in which we give the new table's name. CREATE TABLE cities ( id int(11) NOT NULL auto_increment, city_name varchar(50) NOT NULL default '', latitude varchar(15) NOT NULL default '', Joins

Switching to Linux Windows Bill Gates made his money with the brilliant and evil idea of applying monopoly capitalism to computer software. In the early days of computers, only the hardware cost money and the software was freely shared. I liked Windows 98. If you've ever been selfish, it's easy to understand why a corporation (a legal entity designed to maximize profit without compassion) would want to control your computer and make money off you. Windows 2000 and ME were bigger than 98 without being more useful. Vista is the G.W. I don't use Mac because the hardware is very expensive and I'm on a tight budget. Learning Linux The word "Linux" is derived from Unix, an open source operating system that predates Microsoft, and Linus Torvalds, who in 1991 released some kind of Unix/GNU doodad that is hard to explain technically but that evolved into the sophisticated Linux operating systems we have today. "Distro" is short for "distribution," which means a version or flavor of Linux. Distros Puppy More Links

Cursor (databases) In computer science, a database cursor is a control structure that enables traversal over the records in a database. Cursors facilitate subsequent processing in conjunction with the traversal, such as retrieval, addition and removal of database records. The database cursor characteristic of traversal makes cursors akin to the programming language concept of iterator. Cursors are used by database programmers to process individual rows returned by database system queries. In SQL procedures, a cursor makes it possible to define a result set (a set of data rows) and perform complex logic on a row by row basis. A cursor can be viewed as a pointer to one row in a set of rows. To use cursors in SQL procedures, you need to do the following: Declare a cursor that defines a result set.Open the cursor to establish the result set.Fetch the data into local variables as needed from the cursor, one row at a time.Close the cursor when done. To work with cursors you must use the following SQL statements

Build a CMS in an Afternoon with PHP and MySQL You're now ready to build the Article PHP class. This is the only class in our CMS, and it handles the nitty-gritty of storing articles in the database, as well as retrieving articles from the database. Once we've built this class, it will be really easy for our other CMS scripts to create, update, retrieve and delete articles. Inside your cms folder, create a classes folder. Inside that classes folder, create a new file called Article.php, and put the following code into it: This file is quite long, but it's fairly simple stuff when you break it down. Everything after these lines of code — up until the closing brace at the end of the file — contains the code that makes up the Article class. After starting our class definition, we declare the properties of the class: $id, $publicationDate, and so on. Next we create the class methods . The first method, __construct(), is the constructor . $this-> means: "The property of this object that has the name "". 5. getList() $numRows $order 6. insert() 1.

BitTorrent FAQ and Guide Welcome! If you are new to BitTorrent, this site should help clear up a lot of commonly asked questions. If you would like to contribute a question (and presumably the answer as well), please use the contact page and send me a note. Disclaimer: I am a Windows user, and so by default the answers will tend to apply to Windows if not otherwise stated. Alternative Site This FAQ is also available in a different form at btfaq.com. Table Of Contents Use these links to jump to specific parts of this document, or just page down if you'd prefer to browse the whole thing. What is BitTorrent? BitTorrent is a protocol designed for transferring files. One analogy to describe this process might be to visualize a group of people sitting at a table. How does BitTorrent compare to other forms of file transfer? The most common method by which files are transferred on the Internet is the client-server model. BitTorrent is closest to Usenet, in my opinion. Where can I download the BitTorrent program? Mac OS X

Radoop - Radoop - Big Data analytics made easy The Basics of C Programming" The previous discussion becomes a little clearer if you understand how memory addresses work in a computer's hardware. If you have not read it already, now would be a good time to read How Bits and Bytes Work to fully understand bits, bytes and words. All computers have memory, also known as RAM (random access memory). For example, your computer might have 16 or 32 or 64 megabytes of RAM installed right now. float f; This statement says, "Declare a location named f that can hold one floating point value." While you think of the variable f, the computer thinks of a specific address in memory (for example, 248,440). f = 3.14; The compiler might translate that into, "Load the value 3.14 into memory location 248,440." There are, by the way, several interesting side effects to the way your computer treats memory. int i, s[4], t[4], u=0; for (i=0; i<=4; i++) { s[i] = i; t[i] =i; } printf("s:t\n"); for (i=0; i<=4; i++) printf("%d:%d\n", s[i], t[i]); printf("u = %d\n", u); s[1000000] = 5;

Using MySQL - Introducing SQL This is the first in a series of MySQL workshops designed to introduce MySQL and SQL statements to a novice developer. What is MySQL and why are we using it? MySQL is a powerful Relational Database Management System (RDBMS) which we will use to learn the basic principles of database and data manipulation using Structured Query Language (SQL) statements. SQL is a database language that is used to retrieve, insert, delete and update stored data. This is achieved by constructing conditional statements that conform to a specific syntax (i.e. the strict order required of elements for a statement to work). Although it is assumed that most people reading this know what a database and SQL are (if not necessarily how to use them), there follows a little recap that it does no harm ;-) How does MySQL work? MySQL is a database server program and as such is installed on one machine, but can 'serve' the database to a variety of locations. A Local Client - a program on the same machine as the server.

Windows CMD Commands PHP Security Guide Binary Creativity - Things You Need to Know before Interviewing for a Game Programming Position Things You Need to Know before Interviewing for a Game Programming PositionMatt posted in Getting into Games on August 11th, 2006 For quite some time, the game industry was an exclusive club that didn’t allow any new blood because every opening required applicants to have 2+ years of experience and 1 shipped title. I don’t think there has ever been a better time to get into the games industry right out of college than now. Because next gen team sizes are increasing drastically, people with experience are harder to find, so more and more companies are recruiting right from colleges. Regardless, of what college you go to, you can still get a job in the games industry provided you have a certain proficiency in the following areas. Math – This is an important area to video game development. Physics – You should be very familiar with all the projectile equations. C++ – Although some places still use C over C++, C++ is pretty much commonly accepted as the standard for game programming.

Building Dynamic Websites | Harvard Video Course Since 2008, Academic Earth has worked diligently to compile an ever-growing collection of online college courses, made available free of charge, from some of the most respected universities. We proudly build on the precedent set forth by MIT OpenCourseware, believing that everyone deserves access to a world-class education. To facilitate this goal, we have curated links to over 750 online courses and 8,500 individual online lectures, giving students of all ages unparalleled access to college courses they may otherwise never experience. Whether supplementing existing coursework, or learning for the sake of learning, anyone with an internet connection has the freedom to learn at their own pace from world-renowned experts, without the burden of rising tuition costs. To access this collection of free online college courses, simply select your area of interest from the menu below.

Codecademy Labs Domain Name System Created in collaboration with Paul Devine. The domain name system stores and associates many types of information with domain names, but more importantly, associates domain names (computer hostnames) to IP addresses. DNS is a system vital to the smooth operation of the Internet. The goal of this diagram is to explain what DNS is, how it works, and how it’s governed. The diagram knits together many facts about DNS in hopes of presenting a comprehensive picture of the system and the context in which it operates. Hugh Dubberly created this diagram in conjunction with a study: “Internet Navigation and Domain Name System.” Download PDF

Related: