MySQL Backup FTP is MySql GUI Tool for Windows that runs scheduled backups of MySQL databases, runs local file/folder backup, compresses and encrypts the backups, stores them on a network folder, FTP server or in…
1. If the table's engine is InnoDB change it to MYISAM.2. Add FULLTEXT INDEX on the column that you plan to search. For example "title" in table "tbl_articles".ALTER TABLE 'tbl_articles' ADD FULLTEXT ('title')
Sypex Dumper is a software product (PHP-script), which can help you create a backup copy (dump, export) of a MySQL database, and also restore the database from the backup file if needed. Features: Friendly interfaceThe…
This example will update position field of table tb_documents with sequential numbers.update tb_documents set position =(select @rownum:=@rownum+1 rownum FROM (SELECT @rownum:=0) r)Source : http://markmal.blogspot.com/2006/04/oracle-like-rownum-in-mysql.htmlhttp://verysimple.com/2007/06/09/insert-sequential-numbers-in-mysql
Making connection to database<?php$con=mysql_connect("server","username","password");if(!con) { die('Could not connect: '. mysql_error()); }mysql_select_db("database_name", $con);?> Displaying record from table<?php$query=mysql_query("SELECT * from tablename");while($row=mysql_fetch_array($query)) { echo $row['field_name_1']; echo $row['field_name_2']; }mysql_close($con);?> Inserting record into table<!--php script & HTML form in one…
1stoptutorials is a different that most tutorial websites because you will be doing full courses. You will learn the basics in creating photoshop templates, slicing photoshop templates, dreamweaver, css , websites creation and many more.…
CakePHP is a free, open-source, rapid development framework for PHP. It’s a foundational structure for programmers to create web applications. CakePHP takes the monotony out of web development. Instead of reinventing the wheel every time…
Many people know from their own experience that it's not easy to install an Apache web server and it gets harder if you want to add MySQL, PHP and Perl.XAMPP is an easy to install…
Copy Right Text | Design & develop by AmpleThemes