Portal with 3 level accounting to write/read mysql db by KCP
2009-08-13 06:43:00 We need: - a portal with three different level of access - the ability to present data from a db depending on which account the user login - the ability to modify some data into the db (Budget: $250-750, Jobs: Joomla, PHP, SQL)
mysql Chinese error fix by kitlee
2009-08-07 02:59:00 I need a quick langauge fix on application developed using c#.net and mysql (hosted on xampp) it has language issue that can not send chinese data from c#.net application to mysql correctly; my... (Budget: $30-250, Jobs: .NET)
DreamCoder for MySQL Enterprise
2009-06-04 11:02:00 Click to enlarge DreamCoder for MySQL Enterprise 4.8 DreamCoder for MySQL is a tool for developing and managing MySQL databases. This product can increase the productivity and quality of development teams and database administrators (DBAs). In the DreamCoder for MySQL you will find different modules and utilities to manage and develop in MySQL. You ...
DreamCoder for MySQL Enterprise
2009-06-04 10:55:00 Click to enlarge DreamCoder for MySQL Enterprise 4.8 DreamCoder for MySQL is a tool for developing and managing MySQL databases. This product can increase the productivity and quality of development teams and database administrators (DBAs). In the DreamCoder for MySQL you will find different modules and utilities to manage and develop in MySQL. You ...
EMS SQL Manager for MySQL
2009-04-18 11:34:00 Click to enlarge EMS SQL Manager for MySQL 4.4 EMS SQL Manager for MySQL is a high performance tool for MySQL Database Server administration and development. SQL Manager for MySQL works with any MySQL versions from 3.23 to 5.2 and supports all of the latest MySQL features including views, stored procedures and functions, ...
EMS SQL Management Studio for MySQL
2009-04-18 11:31:00 Click to enlarge EMS SQL Management Studio for MySQL 1.2 EMS SQL Management Studio for MySQL is a complete solution for database administration and development. With components that focus on all critical database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering databases and managing database ...
EMS SQL Query for MySQL
2009-04-18 11:00:00 Click to enlarge EMS SQL Query for MySQL 3.2 EMS SQL Query for MySQL is an utility that lets you quickly and simply build SQL queries to MySQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables ...
Free PHP/MySQL cPanel hosting
2009-01-04 22:09:00 Just today, a friend of mine started offering FREE PHP/MySQL hosting. The only thing you need to do is to be active in forums. You don’t have to write 10 posts every day, but a couple of posts per week should be enough. Hosting has all PRO features. You will have cPanel and Fantastico included in ...
By: Tutorials007.com
El creador de MySQL confiesa que la versión 5.1 contiene bugs críticos
2008-12-02 18:30:00 El 27 de noviembre, hace menos de una semana, Sun Microsystems lanzó oficialmente MySQL 5.1.30, la nueva y largamente esperada versión del popular sistema de bases de datos de código libre. A pesar de que desde la compañía han declarado que estamos ante un producto que está listo para ser adoptado en entornos de producción, su creador, Michael Widenius, ha sorprendido a propios y extraños tras alertar que contiene errores críticos. MySQL 5.1 ha llegado 3 años después de que en octubre del 2005 apareciera la versión 5.0. Un tiempo, a priori, más que suficiente para desarrollar un producto en condiciones y limar todos o casi todos los bugs graves que se vayan encontrando por el camino. No es eso lo que ha hecho Sun, al menos desde el punto de vista de Widenius, quien ha advertido que la compañía ha cometido una irresponsabilidad al liberar la base de datos en su actual estado ya que no cumple con los estándares de calidad que han venido marcando a las anteriores versiones finales de...
Bad Luck with Steadfast.net?s MySQL Server
2008-10-22 17:40:00 Today when I went to check this blog at about 3:30pm PST I figured out that it took very long for it to respond and it can’t connect to the database. I then checked other websites but also the same. Later on I figured out that’s because steadfast’s mysql2 database server was down as their ...
By: my personal blog
MySQL Database Connection
2008-07-14 23:14:00 The script that follows provides for an example way to use PHP to connect to a MySQL database through the use of a PHP Function. The code that follows I will call db.php <?php function connect($sql) { // The following values should all be adjusted to suit your MySQL install. $host="localhost"; $user="root"; $pass="password"; $db="users"; if(!($connect=mysql_connect($ho-st,$user,$pass))){ printf("Error connecting to the database"); email_error("Server Connection Error", mysql_error()); } if(!($dbselect = mysql_select_db($db, $connect))){ printf("<p>Error connecting to the database</p>"); email_error("Database Connection Error", mysql_error()); } $result=mysql_query($sql); if (mysql_errno() == 0){ return $result; } else { email_error($sql, mysql_error()); $result = "Null"; } } ?> Being the ever vigilant system administrator we want the site to alert us of failed connection errors, which may be hack attempts. To do so we can get the web server to send out via it'...
How to add new user accounts to Mysql
2008-06-04 13:06:00 Since I did this over and over again, adding new user accounts can sometime be a pain for people that don’t know anything about Mysql. Here is a small example on how to add a new user with full privileges: First you will need to connect to mysql as a root user shell>mysql -u USERNAME -p After you’re logged into mysql you can add an username easy: mysql> GRANT ALL PRIVILEGES ON *.* TO 'some_user'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; Now to explain a little about this command. The user that we just created has also grant option and you can add other users with this this user if you don want grant option you don’t have to use WITH GRANT OPTION mysql> GRANT ALL PRIVILEGES ON *.* TO 'some_user'@'localhost' IDENTIFIED BY 'some_pass'; So this is it I hope I am of some help for some people
By: We Blog City
Motores de almacenamiento de MySQL y tipos de tablas
2008-06-03 05:36:00 Recientemente estuve buscando varias opciones sencillas para consultar tablas de otro servidor y acceder a su informacion en otro, habia varias opciones, las logicas eran Replicacion de Datos, pero implicaba tener configurados esquemas de Master/Slave y dado que solo queria algunas tablas y no toda la base de datos la descarte, la otra era Row ...
on-line forms (Flash post to MySQL) II by melanie99
2008-06-02 01:29:00 Would like on-line forms made in Flash that will post to save to a MySQL database table for each form - need MySQL database created. Forms will go into existing web site already in Flash. Forms to put... (Budget: $30-250, Jobs: Flash, PHP, Website Design)
First B2B Processes More Than Two Million Complex Transactions Using MySQL
2008-05-29 20:47:00 One of The UK's Leading Providers of Business-to-Business Electronic Trading Standardises upon Sun's MySQL Open Source Database
MySQL Query Browser and Hosted Databases
2008-05-29 18:58:00 Does your website rely on a MySQL database? Are you tired of using a web application my phpMyAdmin in order to run some custom queries and accomplish some simple tasks? I used to hate using phpMyAdmin to accomplish simple tasks like querying a database, creating a table or doing some basic maintenance work. However, these re15 Zoom(s)
PHP & MySQL Web Development All-in-One Desk Reference For Dummies (For Dumm
2008-05-28 04:05:00 PHP & MySQL Web Development All-in-One Desk Reference For Dummies (For Dummies (Computer/Tech)) (Paperback)By Janet Valade Buy new: $34.99$23.0936 utilised and new from $18.74 Customer Rating: First tagged “mysql” by K. VanDonsel “book worm” ...
How to Back Up Wordpress without using MySQL & PHPmyadmin
2008-05-27 22:14:00 When I originally created an article on Dollars Blog about moving wordpress blogs a while back, it was about using PHPmyadmin and MySQL. While you still need to know how to create databases and... [[ Visit the link to read more ]]
By: Dollars Blog
Sam?s MySql Tutorial eBook
2008-05-27 18:22:00 MySQL is an open-source relational database management system that is rapidly growing in popularity. Known for its speed, reliability, and ease of use, MySQL has proven itself to be particularly well suited both for beginners and for experienced developers to create sophisticated database-backed Web sites and applications. The rest..
MySQL 2008 Conference Presentation Notes, Slides, Files and Videos
2008-05-27 13:21:00 The conference was held in April 2008. Here are the resources for the conference that you won’t want to miss. Whether it’s a pdf, ppt, photo, video, or any kind of notes presented during the conference, you can find it here in the MySQL forge. It took me quite a while to get to this main ...
PHP MYSQL Website Coding by mmurf100
2008-05-27 00:27:00 Hi, I have a website template designed and I need a php coder to design the backend of the website. The main requirements are as follows: The site is a recruitment website with the ability to do... (Budget: $750-1500, Jobs: PHP)
PHP / MySQL / Ajax Ninja Required
2008-05-26 18:02:00 Today I am putting out a request for a expert PHP/MYsql - Ajax developer who can create amazing sites / apps without making me feel I am babysitting a monkey. We have a number of projects in development and can offer a good rate of pay along with long term work. In return we need top ...
MySQL Down
2008-05-26 17:38:00 MySQL is down. It's so sickening. Skai Chan @ http://sillydumb.com
By: Dear Dreams
Quick PHP scripts FIX after Data migration on Mysql by jpservicez
2008-05-26 00:06:00 Php scripts not working after migration to Php/mysql 5.xx.x. Need someone to check the scripts and Mysql and make necessary modifications. Scripts works fine in displaying data from Mysql but can't post to DB possibly permission issue... (Budget: $30-250, Jobs: Linux, PHP)
mySQL Date Format to Unix Time Format at Bali Web Design Blog
2008-05-24 17:29:00 This material is taken from Bali Web Design Blog, http://design.ebali.web.id/bali-webdesignseo-blog-1.html. Wanna convert mysql date format into unix time format? Here is the code function mysqlToUnix datetime if datetime parts explode ' ' datetime datebits explode ' ' parts 0 if 3 ! count datebits return 1 if isset parts 1 timebits explode ' ' parts 1 if 3 ! count timebits return 1 return mktime timebits 0 timebits 1 timebits 2 datebits 1 datebits 2 datebits 0 return mktime 0 0 0 datebits 1 datebits 2 datebits 0 source guru forum This material is taken from Bali Web Design Blog, http://design.ebali.web.id/bali-webdesignseo-blog-1.html.
mySQL Date Format to Unix Time Format at Bali Web Design Blog
2008-05-24 17:29:00 This material is taken from Bali Web Design Blog, http://design.ebali.web.id/bali-webdesignseo-blog-1.html. Wanna convert mysql date format into unix time format? Here is the code:function mysqlToUnix ( datetime) if ( datetime) parts explode( , datetime) datebits explode( , parts 0 ) if (3 ! count( datebits)) return 1 if (isset( parts 1 )) timebits explode( : , parts 1 ) if (3 ! count( timebits)) return 1 return mktime( timebits 0 , timebits 1 , timebits 2 , datebits 1 , datebits 2 , datebits 0 ) return mktime (0, 0, 0, datebits 1 , datebits 2 , datebits 0 ) source: guru forum This material is taken from Bali Web Design Blog, http://design.ebali.web.id/bali-webdesignseo-blog-1.html.
5 Steps to MySQL Replication on Windows
2008-05-23 20:32:00 In establishing a high-availability web application you need to consider multiple levels of availability and redundancy. In this first installment discussing MySQL replication I am referring to omni-directional replication. In my follow-up on the subject, next week, we will be covering bi-directional replication or creating what is otherwise known as multi-master replication, and yes I am doing this on Microsoft Windows. As previously discussed in my post on the hardware upgrades for the Poscribes website, I am introducing multiple levels of redundancy to ensure availability not only with load-balanced web servers but also replicated databases and ultimately fail-over internet connectivity (still working on that one!). Why Windows? Well, doing it with Linux is the norm these days and I just wanted to see how easy it would be. In this situation I am using MySQL 5.0.51b-community-nt to replicate between my primary or master database running on a single 2.8Ghz Intel Xeon CPU with 1....
Sample multiple-table UPDATE capability for MySQL
2008-05-23 00:54:00 Sample 1: UPDATE member, grouprate SET member.mem_type=grouprate.gr_gr-oup WHERE member.mem_grouprate=grouprate.-name Sample 2: UPDATE items,month SET items.price=month.price WHERE items.id=month.id; Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1 [, col_name2=expr2] … [WHERE where_condition] [ORDER BY …] You can also perform UPDATE operations covering multiple tables. However, you cannot use ORDER BY or LIMIT with a multiple-table UPDATE. The table_references clause lists the tables involved in the join. Its syntax is described in Section 12.2.7.1, “JOIN Syntaxâ€. ...
By: Warung Digital
Zmanda, herramienta de backup para MySQL
2008-05-22 09:23:00 Zmanda ha desarrollado una herramienta open source de recuperación y backup para las bases de datos MySQL: Zmanda Recovery Manager (ZRM). Con ello se facilita la gestión de entornos críticos y de alto volumen transaccional. ZRM funciona sobre servidores con plataforma Linux, Windows, Solaris y Mac OS X. ZRM también incorpora una consola (Zmanda Management Console, ...
By: Xperimentos
how to backup mysql databases automatically
2008-05-21 23:57:00 Backing up mysql databases is a real headache and if you have more than one website than you will have to spend some more time in backing up all your databases daily and you have to backup your databases daily in order to have the recent backup because you cannot rely on your webhost.I have ...
By: TheTechPedia
How Do I Get Meta Data From MySQL Using PHP?
2008-05-20 19:40:00 I know you’ve all asked that question before, right? Well maybe not, but I recently had the need to detect what the DATATYPE for arbitrary columns in arbitrary tables were inside a MySQL database using PHP. Turns out that it isn’t all that hard to get. The main thing about using this method is that we ...SHARETHIS.addEntry({ title: "How Do I Get Meta Data From MySQL Using PHP?", url: "http://www.franzone.com/2008/0-5/20/how-do-i-get-meta-data-fro-m-mysql-using-php/" });
MySQL and SSL
2008-05-17 14:04:00 I have been setting up a few mysql servers with SSL support for replication . I used the script provided in the the official mysql documentation for creating the ssl certificates cause I needed to do it on more then one server and it made more sense to use it then actually creating each certificate one ...
By: PatchLog
Hyperphp.com - 350MB/15GB/PHP MySql/
2008-05-16 04:55:00 ???????????????????????????????-????????????????? ????????? 350 MB ???? 15 GB ??? 5 ????? 5 ???? 5 ???? 5 ?MySQL??? PhpMyAdmin???? ??????VistaPanel Control Panel???????????????PHPbb?SMF?M-edia Wiki??????????????Zend encoder??????? ?????????????? Disk space usage stats Bandwidth usage stats CPU time usage stats MySQL query stats ??????????????????????? (??????) ??????http://www.pipomaggi.hype-rphp.com/ ??????http://hyperphp.com/index-.php ???? MyHosting247 - 5GB/20GB ???????PHP??? Runhost.net - ?? PHP + MySQL ?????? 200GB? FancyFreeHosting - 2GB/500GB ?????PHP, MySQL? Venom-Hosting - 3GB/5GB?????cPanel, PHP, MySQL? 10GBfreewebhost - 10GB ??????? PHP, MySQL????? dump.ro - ?????1GB?????? FileFlyer - ?????????????????????? My5GB - ?? PHP/MySQL ?????????
Hyperphp.com - 350MB/15GB/PHP/MySQL
2008-05-16 04:55:00 ???????????????????????????????-????????????????? ????????? 350 MB ???? 15 GB ??? 5 ????? 5 ???? 5 ???? 5 ?MySQL??? PHPMyAdmin???? ??????VistaPanel Control Panel??????????????? PHPBB?SMF?MediaWiki ?????????????? Zend Encoder ??????? ??????????????? Disk space usage stats Bandwidth usage stats CPU time usage stats MySQL query stats ???????????????????????? (??????) ??????http://www.pipomaggi.hype-rphp.com/ ??????http://hyperphp.com/index-.php ???? MyHosting247 - 5GB/20GB ???????PHP??? Runhost.net - ?? PHP + MySQL ?????? 200GB? FancyFreeHosting - 2GB/500GB ?????PHP, MySQL? Venom-Hosting - 3GB/5GB?????cPanel, PHP, MySQL? 10GBfreewebhost - 10GB ??????? PHP, MySQL????? dump.ro - ?????1GB?????? FileFlyer - ?????????????????????? My5GB - ?? ...
Head First PHP & MySQL (Paperback)
2008-05-15 06:05:00 Head First PHP & MySQL (Paperback)By Lynn Beighley Buy new: $29.69 First tagged “mysql” by Lynn Kyle “Lynn” Customer tags: php, programming, mysql, head first, web development Technorati Tags: php, programming, ...
MySQL Data Types and Properties
2008-05-13 11:54:00 Have a look at the following line of code from the post Storing and Retrieving Data from MySQL Database. CREATE TABLE phno( name varchar( 50 ) , phnum varchar( 20 ) ) As I told you we have to declare the column data types while creating tables depending on the values we want to store. MySQL has wide variety of data types, out of which I’m stating some of the important ones below: CHAR: For storing character and string data, faster than VARCHAR. VARCHAR: For storing character and string data. Slower but efficient in storing variable length string as only the needed memory is used no matter how much we allocate. INT: For storing regular integers. Same as INTEGER, other related data types are TINYINT, SMALLINT, MEDIUMINT, BIGINT. FLOAT: For storing floating point values, it is 4 bytes long. There is also a DOUBLE which is 8 bytes long. DATE: For storing YYYY-MM-DD date values. ...
Storing and Retrieving Data from MySQL Database
2008-05-12 13:58:00 You may first want to read Installing, Configuring and Testing MySQL Database Server on 'localhost', About MySQL, Databases and SQL Commands. Now that you have installed MySQL database server and have learnt some SQL commands to query MySQL, its time to use our knowledge to do what database servers are used for, storing and retrieving data. To make for a nice example, we’ll create a simple Phonebook Application which would store phone numbers and names of peoples. It’d be able to illustrate the storage and retrieval of data from database quite well. OK let’s first start with the datable design. We’d need to create a database first and table in that database. One table is enough because we only need to store name and phone number which should be stored in the same table. For the table we should have two fields (column), one for name and the other for phone number. Both can be of data type (MySQL) VARCHAR as we don’t nee...
About MySQL, Databases and SQL Commands
2008-05-12 08:52:00 In the last post we ‘created a database’ from our script as an example to test the working of MySQL. Actually a database is a set of tables for storing data. The tables in a database may be logically related with each other. MySQL supports unlimited number of databases and for each application you may use a different one To understand relation between a database and tables consider an example of a database oriented Note Keeping application. Since it needed user authorization we can store user information such as username and password in one table, upgrading that system to multi-user capable is also possible because a table can store any number of rows (i.e. different set of username & password, in this case). We’ll also need a second table for storing note data. Thus we’re using a database having two tables to store data related to a single application. The following image illustrates this relation quite well: MySQL da...
Installing, Configuring and Testing MySQL Database Server on ?localhost?
2008-05-12 08:39:00 Here we go with another installation and configuration post for out local server; this time for MySQL, the well known and widely popular free database server. [You may want to read Installing Web Server on your PC, Installing Apache and PHP on your PC and Configuring Apache Web Server and PHP] In this post, we’ll learn to set-up MySQL server on our own local server and see how we can connect to it from our scripts. Since the last few posts we have been having problems implementing data storage/retrieval from files, we thought it was the right time to start using database for that purpose. However before we can use database connectivity from our scripts, we need to install a database server, we’ve chosen My SQL. In spite of MySQL database server being free, it has proven itself time and again as the best database server around. Its free too so there is no point in us looking for anything else. OK, let’s start by first downloading ...
Data Browser allows you to manipulate MySQL database in a Snap!
2008-05-12 05:33:00 Here’s a desktop based data browser that allows you to manipulate MySQL database in a snap. The most amazing part is how quickly you can bring in any RSS feeds from blogs/social network sites as a database table, almost as fast as my finger snapping. Watch as David, the CTO of the company, explains how ...
Beginning PHP and MySQL: From Novice to Professional, Third Edition (Beginn
2008-05-09 08:05:00 Beginning PHP and MySQL: From Novice to Professional, Third Edition (Beginning from Novice to Professional) (Paperback)By W. Jason Gilmore Buy new: $31.0125 used and new from $26.50 Customer Rating: First tagged “sql” by Robert Beasley “snobert” Customer tags: php(3), web programming(2), open source(2), apress(2), mysql(2), programming(2), web development(2), sql, web design, technology (more…) Technorati Tags: php, web programming, open source, apress, mysql, programming, web development, sql, web design, technology
By: Code Zapper.com
Free PHP and MySQL Beginner Ebook
2008-05-09 01:31:00 This is a very good ebook for beginners who are willing to learn PHP and MySQL. You can learn both language from Novice to Professional.To get this free PHP and MySQL ebook, please click here.
MySQL Data Wizard
2008-05-06 18:28:00 Click to enlarge MySQL Data Wizard 8.4 Data Wizard for MySQL is a powerful Windows GUI utility for managing your MySQL data. It provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. Data Wizard for MySQL allows you to generate ASP.NET and PHP scripts for ...
mysql 5 procedure calls for creating member registration
2008-05-05 21:57:00 http://mustafaturan.net/tr/mysq-l5_procedured_function_calls2_f-or_membership.html ## Coder Mustafa Turan ## ## http://mustafaturan.net/ ## ## Delimiters $$ ## ## members(m_ID, m_name, m_email, m_pass, m_acode, m_status, m_datetime) ## DROP PROCEDURE NewMember$$ CREATE PROCEDURE NewMember(# yeni kullan?c? # IN N_m_name VARCHAR(14), IN N_m_email VARCHAR(55), IN N_m_pass CHAR(32), IN N_m_acode CHAR(6), OUT N_m_err TINYINT ) BEGIN DECLARE name_exist TINYINT; DECLARE email_exist TINYINT; SET name_exist = 0; SET email_exist = 0; # get m_ID to name_exist # SELECT count(m_ID) INTO name_exist FROM members ...
By: Techno Surprises
Problem transferring a mysql database with rsync
2008-05-05 11:51:00 A little more then a year ago I wrote a post presenting three different methods to transfer a mysql database. The third method suggested in that post was copying the mysql database files directly from one server ( or location ) to another. This involved locking the tables with a read lock or even shutting ...
By: PatchLog
php/mySql/ajax project - web portal by nicusornicolae
2008-05-04 00:03:00 This project is a private project for Adriana. Thank you. (Budget: $1500-3000, Jobs: AJAX, PHP, XML)
MySQL GUI Navicat MySQL Manager
2008-05-03 07:19:00 Click to enlarge MySQL GUI Navicat MySQL Manager 8.0.27 Navicat is an ideal solution for MySQL administration and development. This is an all-inclusive mysql front end provides a powerful graphical interface for databases management, development and maintenance. Easy installation and intuitive interface make it an irreplaceable tool for mysql on the web or ...
My5GB - ?? PHP/MySQL ?????????
2008-05-02 10:16:00 MY5GB.com ???????????????5GB?????????20GB-????????????????????DNS?? ns1.my5gb.com / ns2.my5gb.com, ?? Account settings ????????My5GB ????PHP?MySQL???????????5??????-?5?????????? ? FAQ ???????????????? My5GB ????????(function)??????My5GB ??????????(support)????????????-?????? Live Support ???????????????? support ticket ????????????? My5GB ?????? ??????http://freegroup.my5gb.co-m/ ??????http://www.my5gb.com/
MySQL LOAD DATA LOCAL INFILE returns Column count does not match value coun
2008-04-29 22:32:00 Finally back after a long time! Here is a quick tip to get everyone started, and I will put more up as soon as I get some free time. Scenario: I have a comma-separated value list (*.csv) file that I would like to import into my database. However, I put in the code: LOAD ...
PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide
2008-04-28 18:48:00 # Publisher: Peachpit Press (December 29, 2007)# Language: English# ISBN-10: 032152599X# ISBN-13: 978-0321525994Product DescriptionIt hasn't taken Web developers long to discover that when it comes to creating dynamic, database-driven Web sites, MySQL and PHP provide a winning open source combination. Add this book to the mix, and there's no limit to the powerful, interactive Web sites that developers can create. With step-by-step instructions, complete scripts, and expert tips to guide readers, veteran author and database designer Larry Ullman gets right down to business: After grounding readers with separate discussions of first the scripting language (PHP) and then the database program (MySQL), he goes on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications. This guide is indispensable for intermediate- to advanced level Web designers who want to replace their static sites with something dynamic. ... |
|
 |
|
 |
