MySQL

Source: www.dzone.com --- 47 minutes ago
After twitter, now is Digg who decided to replace MySQL and most of their infrastructure components and move away from LAMP to another architecture called NoSQL that is based in Casandra, an opensource project that develops a highly scalable second-generation distributed database. Cassandra was open sourced by Facebook in 2008 and is licencied under Apache Licenses.. ...

Source: www.dzone.com --- 4 hours ago
Here’s an implementation of a contact form with PHP and jQuery. Usually, one would only want the message posted by the user to be sent to an email address. This script does that and also saves all these messages in the database for the admin to keep track of them. ...

Source: tympanus.net --- 5 hours ago
Here’s an implementation of a contact form with PHP and jQuery. Usually, one would only want the message posted by the user to be sent to an email address. This script does that and also saves all these messages in the database for the admin to keep track of them. The table to store this data is the following: CREATE TABLE CONTACT( pk_contact INT UNSIGNED NOT NULL auto_increment, name VARCHAR(120) NOT NULL, email VARCHAR(120) NOT NULL, website VARCHAR(120) NOT NULL DEFAULT "", message VARCHAR(300) NOT NULL, added_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, primary key(pk_contact) )type=innodb DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; We will keep track of the name, email, website (optional), the message, and the date when the message was sent. Feel free to change the limits of the fields, but don’t forget to change them as well in the PHP files. We use jQuery for the front end, and AJAX for submitting the form. All the validations are done on the server side, and the user will be notified when one of the fields is not correct. If the message is inserted into the database, an email is sent to the admin, notifying him about a new message. We provide two CSS templates for the contact form. Concerning the installation, all you need to do is run the database script (db_main_script.sql) and configure your database connection in config.php: define('DB_SERVER', 'localhost'); define('DB_USER', 'root'); define('DB_PASS', ''); ...

Source: www.techtear.com --- 6 hours ago
Con el objetivo de mejorar su performance y posibilidad de crecimiento, el sitio de votación y comunidad social Digg ha anunciado que planea reescribir totalmente su infraestructura de software, incluyendo su alejamiento de las bases de datos MySQL que han sido utilizadas desde sus comienzos. En lugar del codigo MySQL , Digg planea utilizar una base de datos de código abierto NoSQL llamada Cassandra , que fue diseñada originalmente por Facebook. Para simplificar la migración de MySQL a Cassandra , los desarrolladores de Digg construyeron una herramienta para pasar los datos de una base a la otra. Dependiendo de este éxito, la herramienta podría convertirse de código abierto para ayudar a otros programadores. Durante este anuncio, John Quinn, ingeniero de Digg, dijo que construyeron una herramienta, conocida como “transcribe” que se aprovecha de Hadoop, para importar grandes bloques de datos de MySQL a Cassandra. Vale aclarar que las bases de datos NoSQL son un nuevo tipo de bases que se diferencian de los sistemas de manejo de bases de datos basados en el SQL tradicional. En lugar de utilizar tablas y columnas, NoSQL usa diferentes tipos de almacenamientos y objetos. Para evitar problemas, Quinn aclaró que Cassandra no es la única base de datos NoSQL que se consideró para Digg , explicando que existen otros sistemas NoSQL populares como CouchDB y MongoDB. Esta decisión no fue tomada a la ligera, ya que Digg explicó que ha estado pro ...

Source: www.dzone.com --- 11 hours ago
If you are a learner (new) in PHP / MySQL and dont know how to make connection with MySQL database from php file than Here is the easiest and error-free way to make connection with MySQL database. see more with an eexample...... ...

Source: jobs.wired.com --- 22 hours ago
Interspire/Austin, TX $1,000 Referral Reward Over 40,000 customers and Fortune 500 companies (including Virgin, Dell, GE and Shell) rely on Interspire solutions to start online stores, launch content-driven web sites, and profit from email marketing. We're is a global leader in ecommerce software for business of all sizes and we're current looking for talented technical support staff who love problem solving and who think differently. We're looking for excellent technical support engineers to provide email and phone-based support to customers from our Austin, Texas office. If you're passionate about PHP, MySQL, Apache, Linux, MTAs, have excellent communication skills and thrive on resolving customer issues, then we need you! Skills and Requirements - 5+ years of HTML, CSS and JavaScript experience (expert level) - 3+ years of PHP and MySQL experience (expert level) - 3+ years technical support or customer consulting experience - 2+ years experience with Linux system administration (optional but a plus) - 2+ years experience with Windows system administration (optional but a plus) - Excellent communication skills, both written and phone skills - Strategic thinker with proven problem solving skills, with the ability to work within a team to exceed support goals and objectives - Ability to "go the extra mile" to help customers - Great typing skills - Authorization to work in the U.S. Position Responsibilities - Provide email and phone- ...