Original mobile applications

♠ Posted by Unknown in
Many services and Web applications are also available as an app for a smartphone model to take advantage of the touch screen.
There are also games that turn it into portable console. They may be similar to 3D games on computers there 10 years. In 2000, we often had a resolution of 800x600 pixels on a 15-inch CRT, which corresponds to the resolution of smartphones.
And there are quantities of application that could run on computer, but that is not used because it must start immediately and anywhere.

Here are some examples of the amazing capabilities of today's smartphones ...


  • The iPhone has innovated with the voice interface that allows Siri to ask questions such as the address of a restaurant verbally and also get a voice response. A similar function is provided on the Samsung Galaxy S3.
  • Data transfer between computer and smartphone
  • Galaxy S3 allows a device to transfer a file to another by putting them side by side.
  • This camera has face recognition. It can give a name to someone on a photo.
  • Simply place the unit against the ear to it automatically dials a number.
  • WiFi Direct is linking multiple devices without operator.
  • Third-party software add augmented reality: the information is displayed on the places taken by the camera.
  • The classic features such as cameras, voice recorder, note taking, HD videos are they became common.
  • The Samsung Galaxy Note has a stylus and a pattern recognition software.
  • The Galaxy Beam him a pico projector to project pictures to see in the group.
  • The Fire Phone Amazon is able to recognize an object, music, text. This is used by the store to present the corresponding commercial products ...
  • With a touch screen computer and any smartphone, and of course the right software, it is possible to transfer text and images from one device to another by a movement of the fingers, as shown in the video to the right.
  • And examples of applications taking full advantage of these capabilities ...


Localized search


By taking advantage of GPS, looking for a restaurant or any service can direct you on what is nearby.

Tourism in augmented reality


Always with GPS and also using integrated webcam and of course the compass, you can view information superimposed places to which you point a smartphone.
It thus serves as a tour guide. View Augmented Reality.

One can also combine augmented reality and the search engine and reveal superimposed the image taken by the camera, a message showing them what you are looking for.

Remote control


Some ISPs offer an API that turns a mobile touch easiest to use remote than the one supplied with the box of the operator.
You have the option chain, order a recording and performing actions impossible with the standard remote control.

Butler


In other words, the control center for home appliances, including lamps. Android @ home is an application for Android that automatically manages your home. Lighting control as needed, for example. Applications will depend on developers.

Smart alarm clock


By placing the mobile on the bed when sleeping, it thanks to the accelerometer can detect your location and deduce what stage of sleep you are. He did not wake you if you are in deep sleep, but wait until you are released in to sound the alarm.

Plane Finder AR


Allows pointing his mobile to heaven to see the position, speed and weight of the nearest plane.
In addition, it displays the flight number, departure airport and the destination.
To do this the application uses the ADS-B system that team now airplanes and transmits a signal containing the data.

Translator posters


In a foreign country, point the camera on a poster, a restaurant menu written in an unknown language, and it will be translated into the language of your choice.

Rate distance


The application Accoustic Ruler is capable of determining the distance between a point and the machine (up to 25 meters), using the speaker to emit a sound, microphone to receive the echo, and calculating the time between. It uses room temperature as an adjustable parameter ...

Botany


A free application gives us the name of a tree from a photo of a leaf with a visual recognition software. It was developed by Columbia University, Maryland and the Smithsonian Institute.
The database is still local enough for now. See Leafsnap.

Robot and mobile

Control a robot

Use a mobile to control a robot, it is the specialty Cellbots. This site provides a variety of software for controlling hardware that give a "body" and moving the extended capabilities. In fact the mobile can now be part of the robot, it becomes his brain and control center. The photo at right shows an example of a tank robot able to interact with the environment through the webcam and mobile processing capabilities. If this mobile runs on Android, it's natural that it can control a colleague. In this case the Brother must be a LEGO Mindstorms NXT, a small entertainment robot to assemble and program.

Cellbots.

Examples photos.
Download Mindroid. Open source software to control a robot.

Transformed into pinball


It is an accessory and software. For $ 40, you have a miniature pinball interfaced with the program and using the smartphone screen to represent the track of the ball, with bumpers flashing.

Fly a drone


As shown in this video, with wi-fi connection and a mobile phone, it is possible to remotely control a flying machine, in this case a helicopter, receive a picture with a camera and in combination with augmented reality, driving in a semi-artificial universe.
This demonstration is carried out by the French company Parrot.

A microscope at 10 euros


This invention has won three awards, including the National Science Foundation, for a total of 510,000 dollars.

By connecting this mini-microscope that costs almost nothing to a mobile phone, it is possible to have a mobile laboratory replacing a very expensive equipment!
The device placed on a drop of blood can send the image to a remote laboratory that will analyze in real time.
This microscope has no lens, the magnification is obtained by light-emitting diodes that pass through the sample while the image is captured by the camera of the mobile. In fact we get a hologram that can reconstruct an image by computer processing can be automated, remote site returns a diagnosis after comparison with its database.
It can be used by anyone without special training.

See the website of UCLA and Lab on a chip.

Heart Rate


The company offers Runware interface software with a sensor, usually adapted to a hip belt, to display more comfortable heart rate. It comes with an accessory to retrieve the belt signal.
In addition to visibility, the mobile establishes statistics and make intelligent processing by combining heart rate to geographic data and on the ground.

Medical aid


With a sensor connected to the mobile it is possible for example, to test their blood sugar levels.
An application available in 2011.

Programming for Android

♠ Posted by Unknown in
Techniques and tools to make an Android application on the desktop or directly on the mobile.

Android was a startup specializing in creating software for mobile and had 8 employees in 2005. Their first idea was to turn to Samsung for funding, but the meeting did not go well. The team of the startup went to Seoul to demonstrate Android, which was a different system by running applications before a panel of engineers and officers of the Korean company who have been unconvinced. When the team left the room, the assembly to burst out laughing!

A few weeks later, Android was acquired by Google for $ 50 million. And one more laughs at Samsung, which now represents 80% of mobile sales equipped with this system.

Google has federated a quantity of mobile players around her initiative in a entity called Open Handset Alliance whose logo is displayed on the right. It includes Telfonica operators like Telecom Italia, phone manufacturers including LG, Motorola, Samsung, founders of components: Intel, Nvidia, Texas Instruments and players in the Net as eBay.

An open platform


Android, besides the operating system is a user interface and a platform with basic applications created by Google. Being open, it will allow independent programmers to create software for mobile.
The main advantage over existing systems such as Windows Mobile, and access to equipment will be complete when he was so far limited. An SDK is already available for developers.
Applications provided by Google include Gmail, Google Mobile (search engine), Calendar, Docs, YouTube, Maps ...

RenderScript is a 3D rendering API using the graphics processor and Android 3.0 available for the tablets.
However it is expected in the near future to merge Android 2 and 3, so we should be able to also use a day smartphones.
This interface which is part of the SDK is programmed in a language similar to the C compiled into intermediate code.

Dalvik is the virtual machine that interprets the object code from compiling a Java source (or other language).

To cope with the drawbacks possibly result from the lawsuit filed by Oracle against Google on Dalvik, the virtual machine for Android, which has the disadvantage of not having been produced by them, Fosdem foundation launched the draft version Android based entirely on code under GNU license GNUDroid. The project described in a conference applelée IcedRobot appears to have resulted and remained frozen.

In fact, there is a fully open source release of Android AOSP offered by Google and used by all. It was used by Nokia for its smartphones X and X + in 2014.

See diagram showing how Android is built and the system description from the perspective of its programming.

Programming tools for Android


The new version of the SDK for Android 3.0 still contains an emulator to test applications on a virtual mobile. It is applicable to both smartphones as tablets and supports larger screens. To do this, the user interface has been completely redesigned.
New components are added to the library. The applications have been rewritten for a more intuitive use.
The URL support M3U lists expected to watch TV on a tablet with a software like VLC.

Terminal IDE. Command line and Java development tools and C for Android. This will work directly on the mobile. Git is included in the IDE.
App Inventor. Abandoned by Google but maintained by MIT, who is the creator, this tool can automatically generate an application.
HELP. Another IDE to develop directly on the mobile. Compatible with Eclipse.
Eclipse. IDE now supports Android.
ARM Tools. Extension to Eclipse for programming in native code.
The SDK. Development kit. See also NDK. To program in C ++ and produce native code.
Other tools

BlueStacks. A plugin to run Android applications on Windows or iOS. This can help test their applications to replace the slow emulator, or develop more universal applications.
Mono for Android. Programming in C # with Dalvik as a backend.
On {x}. Strangely proposed by Microsoft, allows you to program a remote Android mobile with JavaScript code. In addition we connect with your Facebook account! The computer has no boundaries!
Cryanogenmod. Offers an Android fork with additional functions.
Documents

Android and Nexus One. Android vs iPhone.
Open Handset Alliance. Android committee.
First demonstration video.
Which target Android version? Usage statistics.

WebOS, a different system

♠ Posted by Unknown in
WebOS is often considered the best OS for smartphone.

Palm society that created it was taken over by HP and it is expected that webOS has a great future because HP said that the OS is the primary reason for the purchase, she wanted also the also use on netbooks and tablets, and from 2012 as an alternative system to install on each computer (she sells 60 million per year).

webOS mobile operating system
But August 19, 2011, HP announced the end of the use of its webOS smartphones and tablets. Then on 9 December 2011, the system becomes open source, thus raising its interest, but to justify the developments, several manufacturers must commit to using it.
However, August 31, 2012, the first version of open source beta is available for download. A list of compatible devices is given on the website, if you want to provide mobile that one already has a more modern system. Developers can also use this list to acquire a useful device used to webOS applications tests.

In December 2012 the own hardware interface is replaced by Codova Apache, allowing webOS run on any mobile and applications.

On February 25, 2013 it was announced that LG would acquire webOS, its fields and related patents. LG will be using it on TV, making the course less attractive to developers, its future seems uncertain on mobile where it should leave room for Tizen and Firefox OS or even Open webOS.

Development


A development environment is included, which allows OpenEmbedded cross-compilation and thus the creation of a mobile application for various processors, while a development tool performs them on a desktop computer. This includes an emulator.

WebOS includes node.js and therefore the production of fully portable application, running on the desktop even when they do not use the mobile sensors. But if one has a computer touch screen, it facilitates the testing of an application.
Node.js allows for completely different design applications with HTML interface 5 and interacting with a server and therefore multiple sources, which facilitates the mashup. The Node modules can be written in native language and are usually worn on every major OS, which brings webOS speed of Objective C language of iOS applications and the same as the Java portability of Android.

Qt is also included in the platform.

All those who have already tried the OS say amazed by the fluidity of the interface compared to other mobile, including iOS and Android. In fact, recruiting engineers who have worked on webOS, Google was able to recover a lot of ideas that contribute to the quality of the OS and that is now found in Android 4.

Tizen, against Android, iOS and Windows 8 ...?

♠ Posted by Unknown in

Why this new operating system for mobile?


One might say, another OS again. But besides the fact that Tizen replaces two, we also see the decline of Symbian, WebOS, lack of interest in QNX, which reduces the number almost four.

Tizen Kane, it is terrific!
The creation of Tizen Intel has deep reasons: the loss of a partner, which Nokia turned to Microsoft, and interest new partners disappointed with Android but do not want a system designed for Nokia and Qt its platform.

History


The system Moblin was created by Intel in 2007.
Maemo is also a system for smartphones based on Debian, launched by Nokia in 2005. In 2009 he goes to the Qt environment. Nokia mobile Many have used this system.
In February 2010, Intel and Nokia join forces and create Meego, which is the merger of Moblin and Maemo. GTK is abandoned in favor of Qt.
One smartphone will use this system, the Nokia N9.

After the break the de facto partnership with Nokia, which turned to Windows Phone, Intel found a new strong partner for mobile manufacturers Samsung.
Embarrassed by the trial Apple pseudo-Android patents, encouraged by his government, the firm needs a new operating system. With many other manufacturers it supports the Tizen system.

Many things happened behind the scenes, as Tizen also has the support of the Linux Foundation will host the project and merge it with its own system, LiMo.

Tizen vs. Meego


What has changed between Tizen MeeGo and justifies a new name (in addition to the merger with LiMo)?

Tizen used as primary interface HTML 5, and it does not act as a language tag, but also an amount of API produced by Intel, Mozilla and many other publishers to exploit the potential of all materials existing.
These APIs avoid the programmer to use different native libraries for each type of material as was the case with Meego. Programming is simplified.
But if one goes to HTML 5, what will he Qt?

One reason for the creation of Tizen, Intel (as for manufacturers), was to release Qt, a tool to Nokia, which was the basis of the Meego interface. However, it will still work on Tizen even if it is not included by default. In the worst case it could turn to a third party editor.
In fact it would be essential that the Linux applications run, possibly with a re-compilation, so that the system provides an alternative to Windows 8.

That said, the privileged framework will WAC, a tool developed by Intel applications to interface with all hardware.

On a more technical level, Tizen Meego to resume on file system, Linux and hardware tools and other intermediate drivers.
But Meego applications will not be supported, mainly because Qt is not integrated with Tizen. However, third parties working on the implementation of Qt on Tizen.

Tizen 1.0


The first stable version provides the following functions:

WebRTC. Communication protocol with the browser to various media.
Window-based interface graphics framework Enlightenment (EFL) Linux, lighter than GTK (Maemo) or Qt (Meego).
Cairo 2D graphics library.
HTML 5 supports the full specification to date.
Tizen mobile API used by HTML 5 applications.
Extended location features.
Wi-Fi Direct allows mobile phones to connect to each other without an access point.
We can test this first version that does not unattractive, on the local machine with the emulator included with the SDK download developer.tizen.org or simply with the browser. Development tools are also already available in the SDK.

Tizen vs. Windows 8


Tizen is a competitor to Android and iOS, but it goes further. Tizen to be universal and will work on:


  • Smartphone.
  • Tablet.
  • Netbook.
  • Vehicles.
  • Televisions.

We see that it will be as a competitor to Windows 8 on tablets and at least netbook. But why should the manufacturer choose Tizen rather than Windows?

Contrary to what is going on desktop software like Office, Photoshop, etc ..., Microsoft with the Metro interface has the advantage of mandatory compatibility. There is no need to use Windows for applications since we start from scratch with this new platform. Developers can both wear them on Tizen instead of Windows without additional effort.
If the information that has leaked is proven, Microsoft should receive a percentage, of the applications running on Metro which will all be uploaded to the App Store.
And the percentage by which one talks is 30%. Publishers hesitate to give 30% of their revenue to Microsoft.

He can spend it for Metro which is spent for IBM with MCA who was to succeed ISA (long before PCI): Partners can all turn to a free system that offers the same benefits.

Tizen vs. Android


Android is based on Linux and open-source sytem, ​​in some versions at least. Beyond the backend, it is essentially a Java machine. Native applications are written in this language and run on Dalvik the virtual machine.

Android faces claims for breach of "patents" very questionable in practice but recognized by the US government, from Oracle for Java, Apple and Microsoft.
Also manufacturers are concerned that Google now owns Motorola, favors its own smartphones. It will compete with the company that provides them with their operating system.
The fee they do not pay Google for its use, they pay to Microsoft.
So many reasons that may push them to Tizen.

The site: Tizen.

Tizen replace Bada


The system Bada Samsung (Bada means "ocean" in Koreen) is based choice on Linux or RTOS (with BSD code), but Samsung has announced that he was working to merge with Tizen instead. This means that applications made for Bada, ave its SDK, also work in Tizen. The SDK itself will be replaced by or merged with Tizen software. Bada SDK has interesting capabilities such as integrating Webkit in a native application ...

Now it happens that Bada has already some hearing in the global market: it represents 2% of the smartphone OS used ... We could consider that it is the market share of Tizen whether users can upgrade their mobile with this system ... The new OS will operate the native Bada applications and add them a broad set of HTML 5 applications.

In June 2012, Samsung became a member of the board of directors of the Linux Foundation. For this the company has to pay $ 500 000 per year. She joined IBM, Intel, Oracle, Fujitsu, NEC, and others. Google is a member only "Gold". The interest of this news is that it confirms Samsung's involvement in Tizen, Linux-based, and also that Android. She may have other Linux-based projects, but its involvement in Tizen is clear.


Similar or complementary projects Ces autres systèmes peuvent remplacer le système fourni avec le mobile, ou éventuellement un mobile sans système.
  • Sailfish. Based on Linux with Wayland and code Sea (the two projects merged), it uses the Qt platform. This is the OS Jolla tablets and phones.
  • Plasma active.A mobile version of KDE.
  • Firefox OS. Mozilla, based on web standards, it is designed for mobile cheap.


Programming and mobile technology

♠ Posted by Unknown in
Article is under Construction !!!!!!!!!!!!


Mobile phones, smartphones, tablets and all mobile computers. A new area for webmasters and programmers and a key in the coming years.

How to build a website for mobile? According to the announcement by Google on the issue, there is no difference between a site made for desktop, mobile or both.
It is not necessary to have a particular extension (as .mobi) or to place the pages in a specific sub-domain.
It is entirely possible to make a mobile site accessible with just a dedicated stylesheet. We just provide a display on screens of different sizes which is facilitated by a fluid layout, like the theme or Cryonics Encyclopedia for Wordpress (usable on a static site).
However if you want to install a specific sitemap to Googlebot-Mobile, it must contain only the pages that appear on mobile.

Tizen


The new free operating system compared to Meego, Android, Windows 8.

WebOS


Often considered the best mobile OS, it has had mixed fortunes before switching to open source. It is available for download.


Android


This programmable system in Java tends to win in front of iOS.

Android application model. An overview of the structure for an Android programmer.

Original mobile applications


They show how to take advantage of their capabilities. It connects the different types of materials to give them some intelligence.


Nokia, Blackberry and the principle of differentiation


Where discussion of the will to differentiate desired by the two firms, to what it earned in terms of competitiveness, and the validity of the principle itself, especially in the field of computing.

History of the iPhone.


Apple does invented the mobile has touch screen? It's not as safe as it claims ...

Apple against Android. The patent war against Apple and Samsung.

Inspiration Apple


How Apple is inspired by the design of other companies to design his own. These are "tributes," the firm at the apple.

Frameworks for mobile


Based on HTML 5 and JavaScript, they interface with mobile OS and attempt to provide an interface identical to that of native applications.

Native HTML 5 vs  Titanium


Which platform to choose for a mobile application? By-side comparison of the three options.

Choices made by some actors and experience

Statistics on mobile


Systems and uses.

For desktop programming, web or mobile

♠ Posted by Unknown in
Article is under Construction !!!!!!!!!!!!

Of classical programming Web programming and programming of mobile.
Languages, algorithms and web technologies with the best free development tools.

Algorithms

Coloring algorithm, the bridge
The interest of the algorithms is gaining in importance optimize resources is increasingly important on new platforms and applications are becoming more varied, see the amazing graphics algorithms, for example.
The algorithms source codes are available in Scriptol, PHP, C ++, JavaScript, Java.

Defining the word algorithm.

Classification.
History.
List of algorithms.

List of graphics algorithms to transform images
Show the astonishing progress made in the field of graphic design to avoid working days by automatically performing the transformations.

Binary search.
Enhance photos and videos.
Mogo and UCT algorithm.

Languages


Go programming language
List of programming languages
All languages ​​with an interpreter or compiler, and historical languages ​​in alphabetical order.

List dates from 1946 to today.
Comparison of popular and new languages
What language to choose, depending on your project?
History and evolution of languages
Adopted to design a programming language, innovations in recent languages.

List of programming languages ​​attributes
All features they may have and date of the first implementation in a language.

The programming paradigms
Different way of programming and therefore to design languages.
5 amazing but totally ignored languages
Although they incorporate impressive features, they were not interested programmers. Before creating a language, one must consider that experience.
Quotes about programming languages.
What the authors and programmers think of languages.

Programming languages ​​of open source
Their popularity based on the number of new projects.

Examples of instructions or simple algorithms in all languages ​​...

Hello World program in 200 programming languages
The simplest program in all languages.

Sieve of Eratosthenes
The algorithm written in major programming languages.

Fibonacci
The algorithm in all popular programming languages.



Programming languages and dataAsm.js - AspectJ - Basic - C - CIL - C++ - C++11 - C# - Dart - Eiffel - Go - Java - JavaScript - Julia - JavaFX Script - Pascal - PHP - Python - QML - Rexx -Ruby - Rust - Scala - Scriptol - Swift - Tcl - TypeScript - HTML - XML - XAML - XUL - SQL

Technologies

Web applications and mobile become the main axis of IT development today, as these areas tend to merge.

Shall develop the technologies for these platforms: frameworks, development tools, interfaces systems ...

Sheets for the main of them with a description and links to tools or essentials.


Technologies and programming platformsAjax - API - Cassandra - CLI - Codes HTTP - Cookie - Cover Flow - Dalvik - DFA - .NET - JavaFX - JNA - JSON - LLVM - Modern UI - MySQL - NaCl - NoSQL -Protocol Buffers - Qt - REST - Servlet - Web 2.0 - WebGL - Webkit - WinRT - Wysiwyg

  • Programming Evolution


  • The language scripts in HTML has become a universal programming language. It is interesting to follow the evolution of programmer tools in time ...

RSS, scripts and formats

♠ Posted by Unknown in
Article is under Construction !!!!!!!!!!!!


RSS is an easy way to webmster promote a website while it allows the user to be informed of new items from different sites. The two major formats are RSS 2.0 (Really Simple Syndication) and Atom 1.0.
You can display a feed on a page of your site with just a PHP function that is provided on this site or atom size 2.0 ..

Ara RSS publisher
Editor and File Generator automated RSS to generate and edit online the flow of your site.

RSS Reader in PHP
A PHP function to display a RSS 2.0 thread in a Web page. Consideration of multiple channels.
Several demonstrations.

PHP API RSS
PHP class to generate RSS 2.0 feed.

Promoting a web site with RSS
How this file on your website or blog can help considerably to make him known.

15 applications RSS
Besides promoting a site, RSS is used for many things, sometimes very original.

What syndication format to choose?
RSS 2.0, RDF and Atom 1.0, which is better?

Tags RSS and Atom formats
Comparative table of size-specific tags.

Atom reader
PHP function to display an Atom feed. Demos and download.

How to make a universal feed reader
Compatible with the three 2.0 formats, 1.0 and Atom.

Universal player
An application.

RSS and SQL
Create a stream from a database. The example uses a SQL database.

Load a remote file with cURL
Use the Internet file transfer library to load an RSS feed on another site.




Thank you !

Scripts PHP, C ++, or JavaScript

♠ Posted by Unknown in
Article is under Construction !!!!!!!!!!!!


Command line cripts for creating website, or updating and management. Remote scripts using HTTP or FTP.
The source code of the scripts is Scriptol or PHP, in the first case the product code PHP or C ++ compilation.

The section also provides JavaScript scripts in this language.

JavaScript and HTML 5

Advanced Explorer


Modern version in JavaScript and HTML 5 File Manager, formerly in Java, works with Node.js.

Advanced Explorer vs. Explore
Defects in Windows Explorer never corrected.

graphics scripts

Thumbnail Maker


PHP script that generates thumbnails from images preserving the proportions to create a gallery. PHP functions produce quality images.
Generator image gallery

Automatic generation command line tool for image gallery.

Picture gallery generator GUI

Version with GUI.


Scripts HTML

Bioloide


Interface to upload your site to launch more easily optimize and test scripts.
Several scripts are included in the archive.

Outline

Creates an HTML page from a text file.

Canonical

Generate a generic canonical tag in PHP.

How your pages are seen by browsers and robots?

A tool to put online to test HTTP request returns.

Webmaster tools

List in a special folder.


Scripts FTP


PHP FTP Synchronizer


Automatically updates your files to your website from a local version, comparing dates or content. Various acceleration options are available. Free under the GPL.

The FTP protocol is used to exchange data between computers and send files on a remote server. Demo scripts to send or receive a file using this protocol.
Check FTP (zip)
Tests downloading to a ftp server. Type "solp ftpcheck" or "php ftpcheck.php" for options.
Sends a file to the server, and then deletes it.
File Management
 

Backup


Perform automatic backups using an archiver and a simple and efficient script.

Incremental Backup

This version allows updating an archive.

Synchro

Create an incremental backup of a directory's contents, possibly to update a website. Requires PHP.
Search and replace

Seeking a text in a file or group of files. Optionally performs replacement.

Propagator

Updates the contents of a file set by copying a tag in a page on other pages in the same directory and subdirectories.



Other Scripts 


Dictionary Maker


Set of scripts to create a dictionary.

C to C ++ Converter

Converts files in a project in C, C ++ language. Program written in Python 2.0 language.

PHP Apollo

This free program transforms your PHP scripts into executable for Windows. Not updated for recent versions of PHP.

XP Look

Give to old programs the look of new software in XP.
Vista Look

Give to old programs the look of new software in Vista.
XML scripts.

SpeedyMake

An alternative to make with an XML file.
Formula 1. Display the results of a competition. Automatic calculations.
Visitors. (Zip archive). For a site without statistics system, know the number of visitors to a page. Does not depend on JavaScript but requires PHP.
Href. (Zip archive). Converts a site names list in a text file, links in an HTML page.
The scripts are open source under the GPL or OSS license.

Introduction to SQL: What is SQL?

♠ Posted by Unknown in
SQL (Structured Query Language) is a relational database language. It allows:


  • Creating database and the tables.
  • The addition of records in rows.
  • The interrogation of the database.
  • Updating.
  • The change in structure of the table: add, delete columns.
  • Rights management of database users.

The best known version on the Web is MySQL, a free implementation that is used especially with PHP, but SQL is the language of many other database software including PostgreSQL, Oracle, DB2, Access and SQL Server .. .

The main controls are:


  • CONNECT to connect to a database.
  • CREATE to create a new database or table.
  • INSERT to add data.
  • SELECT to query the content.

It is possible to SQL procedural programs with iterations and conditions.

You can access a database by placing orders as is done in PHP, or visually software such as phpMyAdmin running on the server or locally with Wamp Server as well as many other local servers software.

In this tutorial, we will use MySQL with PHP and phpMyAdmin interface.

A word about SQL injection


Unfortunately this feature is to form sentences to make requests can promote if we are not careful the malicious code injection, something we should be warned before you write the first line of code.
How does an injection? This can be explained by an example. The user enters text in a form and one should look for the text in the database with SELECT, which we will see the definition in the tutorial.
Suppose the user enters the word "orange". The control built with the form data will this shape.

SELECT * FROM stock WHERE fruit = orange 
This line will look in the stock of fruit he has it as orange. Now suppose the user enters the following:

"Orange DROP stock."

Here are the new query:
SELECT * FROM stock WHERE fruit = orange; DROP stock
The processor that interprets the commands based on keywords that are found in the query DROP and clear the stock table. This is a SQL injection. To prevent this kind of attack, we always put the data in single quotes:
SELECT * FROM stock WHERE fruit = '$data' 
Quotation marks are the data are interpreted as data, not as commands.

A universal language


SQL commands are close to natural language, that was the purpose of language whose principles were laid by Edgar F. Codd, and taken up by IBM SEQUEL (Structured English Query Language), later renamed SQL. However, the first commercial version based on SEQUEL was by Relational Software, has since become Oracle.

ISO SQL-92 or SQL-2 was defined in 1992 and is commonly used.
However, new standards have succeeded, not necessarily implemented on all software.
ISO SQL: 2006 standard for managing the XML files, including import XML data into a database or export its content in XML.
It is especially these standards that make the difference. Whatever the software used, MySQL (or MariaDB), PostgreSQL or Oracle, or even managers said as NoSQL Cassandra, one will find the same syntax, with minor differences.

Configure PHP and create the development environment

♠ Posted by Unknown in
To start this tutorial based on SQL examples, a work environment must be defined.

Using Wamp Server or EasyPHP or equivalent software, the key is already done:


  • Apache is installed locally.
  • MySQL is installed on your computer.
  • PHPMyAdmin is ready for use if needed.
  • PHP is configured to include the mysql extension with which they work.

The scripts that we will have to be stored in the www subdirectory of the server software directory. To start a script, open the dropdown menu of the software in the taskbar and click on localhost and click on the project folder.

The examples we give are intended to run on a server. So you need to check that the configuration of your hosting is ready to run scripts.

For this download a small script as infos.php (check that no files already has that name):


<?php
phpinfo();
?>
Then run the program:
http://www.example.com/infos.php
With the URL of your site. If the program does not work, either PHP or phpinfo are not supported. Then see the documentation for the host or change of accommodation.

Otherwise check that the PHP version is at least 4 and PHP mysql extension is included. Each extension has its own descriptive table with the name of the extension above. Then erase infos.php.

If the mysql extension is included we can put the examples online, otherwise it will be sufficient to test locally.


Programming the Web with PHP and MySQL Tutoriel

♠ Posted by Unknown in
According to Article famous O'Reilly Web 2.0, the SQL language was to popularize and become as common as HTML on websites, which seems to happen, few sites currently do not use the language in a script or CMS. Blogs based on Wordpress, for example, record the items in a MySQL database.
So a webmaster should know the language, and this tutorial is intended for that.
Tutoriel SQL
    Configure PHP and create the development environment
    SQL to learn by doing, it is best to install a local server that can run both PHP scripts and SQL queries.
    What is SQL and SQL injection?
    Database Language Overview.
    The tables in SQL
    The first notion to know SQL is addressing the concept of table. A table translates the data in a form usable by the program and by the language database query.
    First PHP and MySQL program
    All steps in the use of a database are described, from creation to the query through the addition of data. For that one has simple examples in PHP on a MySQL database. These examples work locally or on a web hosting.
    Create a SQL command interface
    It will perform query directly.
    SQL tutorial on one page: User Management
    The study SQL commands to create and manage a file registered members can see most of the SQL commands in action.
    DESCRIBE TABLE and SHOW commands
    Show the structure of a database and its tables.
    The commands to change the SQL table structure
    List of commands to change the table structure and change the columns.
SQLite
    SQLite PHP Tutorial
    Alternative to MySQL that can run locally or online.
Applications
    FluxBB: Show Titles recent discussions of a forum on the home page.
    phpBB: Latest posts of a forum on the home page.
    Show titles last Wordpress tickets.
Scripts
    How to test the integrity of tables in a MySQL database
    Works directly on Wordpress, phpBB and FluxBB.
    Generate a table directly from a form.
    To facilitate the development phase.

Purchase of a site risk

♠ Posted by Unknown in
It was in 2005 but over the long term that this study is interesting. On Sitepoint, a user proposing to sell his site for $ 50,000, and showed its Adsense statistics, impressive figures: $ 300 per day for a month for a site of this one page!

According to the author, Google was contacted three times and has always approved the site (this was long before the arbitration was banned in June 2007).

The author gives the figures:


  • Alexa Rank: 99000.
  • PageRank: 5.
  • Daily unique visitors: 9000.
  • Income: $ 300 per day. Verifiable.

Question: Should I buy the site?

Traffic comes from other sites, mainly a banner on another very important site.

Now look at the Alexa site traffic over the past three years, especially in late 2005 and early 2006:




Since the peak traffic at the end of 2005, so by the time of the announcement, it has steadily declined.
In February 2008, the figures are:

Last Alexa rank: 763.283 for a traffic 0.00015%
Decline over the last three months: - 150.789
Number of visitors per day estimated ~ 100

And PageRank is now 3.

conclusion


The traffic of a site may come primarily from links from another site, which will disappear after the sale.
What we are reassured, the site has not been sold, it is still owned by Lumicorp Inc. It's happy.

Acquire and use a domain name

♠ Posted by Unknown in
The domain name is registered for one or two years in a registry, the official index for extension type. It is possible to register the domain at the registrar for a longer term in the registrar account only.
There are several "registries" extension managers, managed by different organizations in a TLD, the top-level domains.

The dictionary will give you the definition of terms such as registrar, TLD, redirects, delegation, etc ...

The choice of domain name


A domain name should be easy to remember, and therefore either be short or correspond to a common formula.
But how is formed a domain name and its extension, the TLD, are of importance on the results of search engines.

If your hosting is shared, so if you are hosted by a vendor space, know that all extensions are not always accepted .... Com, net and org are not a problem. Other extensions like info, biz, fr, etc. had can not be supported for a particular cause or a premium offer.

The extension or TLD (Top Level Domain) is taken into account by search engines, including Google. A site in FR arrives in a better position to search in French (or in France).

The name must have more than one letter. ICANN banned domain names in the same letter if there were some exceptions: I.NET, Q.COM, Q.NET, X.COM, Z.COM and G.COM, the latest being Google.

Before bringing a domain name, see the section on SEO and positioning.
See also Article The value of a domain name.

Selection extension


It is generally preferred .com extension, because it is supposed to extend default by Internet users. But be aware that just as .net, .org, .name, .jobs, .tv, .cc, .com is under the jurisdiction of the USA. So the field can be seized by US authorities (just ask the registrar), even if you live on the other side of the world and make hosting your website.
So before starting an activity such as online gaming especially, think about this. Even if your activity is legal in your country, it may not be in the USA!

We took the habit of using extensions country because they have meaning, for example me (me, actually Montenegro) co (commercial, in fact Colombia).
But some are dangerous. For example Nigeria (domain ng) with a long history of misuse of names, such diversions are made by the management body itself, the Nira.

7 Extended appeared January 29, 2014: .bike, .clothing, .guru, .holdings, .plimbing, .singles and .ventures.
Many more are coming. On 10 June 2014, the .uk extension is available to replace .co.uk.

Domain Name and Brand


In fact we must avoid having a brand name in a domain name and a social name or a surname. But one area filed prior to the filing of a trademark can not be questioned by the possessor of it and even the brand name may be challenged.

Judgments in different cases. (JDN)

DNS - Domain Name Server


To change the DNS, and to manage by your host (and not by the Registrar):
- Your host should provide you with a Primary DNS and Secondary DNS. (Eg dns1.scriptol.fr and dns2.scriptol.fr).
- Go to the administration panel at the registrar and enter the two DNS.
- Go to the administration panel at the host and enter your domain name.
It takes at least 24 hours for the redirect becomes available.

Some sellers (not listed here) proposed the "park" your domain name is reserved, but not associated with your host or IP address. Some registrars (not listed) are paying the DNS change. This is equivalent to the parking.

DNS Report is a web service that verifies that the DNS are correctly configured and that the field is carried on accommodation.

URL forwarding (rerouting, score) on a site


To reroute the domain name, the DNS must remain in management by the registrar:
- Go to the redirection administration panel at the registrar and enter the URL of your site, for example: http://www.example.com/.
- Wait at least 24 hours.

If the domain is redirected by the use of frame, it will appear in the browser's URL field, not the target. It will not be taken into account by search engines.
It is possible if one has a small hosting space to redirect the domain to another by a rule of .htaccess file (unix) specifying a 301 or 302. In this case the source domain will be ignored only the target will appear and will be taken into account by search engines.

Transfer registrar


The domain transfer from one registrar to another is by application to the new registrar.

A transfer is permitted under certain time within a period of one or two years of the deposit of the name. When the domain renewal proposed by the current registrar, it too late for a transfer to another registrar.
Some registrars refuse the transfer of a domain to another registrar (not listed below), but it is not legitimate according to the rules of ICANN.
It should start by checking the status in the whois database. It can be: ACTIVE or REGISTRAR-LOCK. We can also meet CLIENT TRANSFER PROHIBITED which is equivalent to LOCK.
OK does not mean ACTIVE. A status not "active" makes the transfer impossible, but you can change the status in the admin panel.
You will be contacted by the two registrars if the email address of the contacts is yours and you must answer within 5 days.

Conditions to check for transfers:
- Domain created there are more than 60 days and not renewed within the last 46 days.
- Domain expires in 30 days for some registrars, but there is no delay in this direction for ICANN. The transfer may even be beyond the expiration date.
- Email addresses valid contacts (check the whois database).
- Domain unblocked status "active" and not "lock". This does not apply to EN, EU, BE.

View transfer regulations by ICANN.
Also the way in the domain type, and lower references.

The owner of transfer rules are similar, but should instead check email contact owner.

Contacts

Four contacts are defined for a domain and appear in the whois when the information is not hidden.

Contact owner (owner-c)

It gives the name, address and email of the owner or domain name holder. It has full authority over the area and only may allow the transfer of ownership.

The administrative contact (admin-c)

It has the ability to change the registrar (not owner) and the information associated with the domain, including DNS and other contacts. It is he who is contacted by email when changing registrar.

The technical contact (tech-c)

It can change the DNS, so associate the domain accommodation. It may be the registrar itself. It manages the DNS problems.

The billing contact (bill-c)

It receives the bills and can not change when the domain.

The main registrars


A domain name is essential for the future of a website is a component of SEO.

The recording conditions are different depending on the types of areas. For example when changing registrar for com, net, org the recording time is extended, but for the US and UK we start from scratch on the date of transfer.

The following registrars all offer free DNS management, A-Record or redirection.

Bookmyname. Common extensions plus a few foreign ccTLD as .us.
- Redirect email if DNS is managed by them.
- Payment by credit card only.
Gandi com, org, net, be, biz, info, name, and had fr.
- 5 redirects explicit emails and catch-all.
- Blog hosting.
- Payment by credit card, check, money order.
OVH. Com, org, net, be, info, in, be, and many other fr.
- Budget accommodation.
- Payment by credit card, check, money order.


The second market


Next to the registration and management of domains, many derived activities have developed ...

Resales areas Sedo, Afternic, BuyDomains, DomainNameSales. (Afternic and SmartNames were bought by GoDaddy).
Expired domains, recovery: NameJet, SnapNames, Pool.
Parking monetized: InternetTraffic, Yahoo, Sedo.

Advice


Besides the main registrars, many offers are available (though endangered), but check some points.

Parking

By park means to a blank page or a publicity list. In both cases it should be avoided. The page will be seen as undesirable or unnecessary by the search engines that will long before the scanner again.

Multiple domains

Since taking into account the canonical attribute, if the URL of all pages is defined by the attribute, there is no downside to using multiple domains for one site.

Renewal at risk

A domain name is renewed after a year or two years, less a period of 1 or 2 months.
A record of more than two years offers no guarantee, you will not be saved to the Internic for more than a year or two and if the registrar disappears, you lose the bet.
You must renew the registration exclusively from the original registrar and no one else. A scam example is "Domain registry of America" ​​that asks you to renew a domain purchased at her hand, which in the best case later force you to transfer the domain home.

Transfer impossible

There are a number of tricks that are used to prevent applicants from leaving the house, and transfer their domain to another registrar, cheaper. Suppliers in the above list does not resort to such practices.

Customer poaching

The company Domain Registry of America was sentenced in the US following a complaint from Register.com. However, it continues to send to the owners of the name of an official-looking letter inviting area to pay to renew their domain with their services (less advantageous terms) into thinking that this is part of the renewal process normal domain.

Statistics and new extensions

How many registered domain names?
In the month of June 2012 amounts in millions of names registered by extension were:

YearCOMTKDENETUKORGCNINFOEUBIZFR
201411321.315.615.510108.86.13.72.62.7
2012103  14.8 10 8.2 2.2 
201087 13,7138,58,37,66.33,221,5

The Germans are the most US fans with 30% deposits before the Netherlands and France. Cn lost 5 million recording in 2011 following the severe conditions optention. Tk is free.

Since 2012 registrars can with some average conditions, create their own extension and suggest areas for registration under the new extension.