Results for "Category: String Manipulation"

This code gives a dump(backup) of your local or remote database. I use this in combination with vb to backup my remote database. If you are interested in the vb_code to do so... let me know....

how to do subselects in mySQL

Hi folks I have searched many sites for storing a picture into a database and retrieve the same. But I got some tutorials when I searched the web. Using the tutorials I have a made one for me. It was implemented using Php and Mysql. I will tell you want is the job of each files. 1). index.php This files links all the files in the project. 2). store.php This does the job of storing the picture into the database. 3). viewadd.php This file shows the entire picture stored in the database. 4). getpicture.php This file actually gets the file from file in the form of picture 5). mdbc.inc.php This is a class file for Mysql feel free to use. I got this over net. Here is the table description Id - > has the picture id Description -> has the picture description bin_data -> picture data filename -> picture file name filetype -> picture file type. Like gif or jpeg etc link -> you can store the link incase if you want to use this for ad exchange showno - > no of time ad show etc clickcount -> no of time the ad being clicked etc Query for the table. CREATE TABLE ads ( id varchar(15), description varchar(255), bin_data LONGBLOB, filename varchar(50), filesize varchar(50), filetype varchar(50), link varchar(255), shownno integer(5), clickcount integer(5), unique(id) ); If you want to see a site where I have implemented please have a look at the site http://www.asksathia.com/ Feel free to change anything in the code. If you developed a better version than this please send me the source code so that I may update myself. It took me much time when commenting the code of ease of understanding. Please vote for me. Regards Imthiaz Rafiq [email protected] Msn id: [email protected] Yahoo id: imthiazrafiq ICQ: 24294947 URL: http://high-flyer.da.ru/

A quick and dirty search script for pulling catalog items from a MySQL database. Supports the use of 'And' or 'Or' or 'Not' between keywords. by Kevin Clevenger.

Web based database(MySQL) management tool http://brutus.snu.ac.kr/~smkim/mysql by SooMin Kim

This code teaches you how to connect and use a MySQL database thru PHP 3/4. Great for beginners! I update it, so the version on this page has no comments because the PSC butchers it alot, so if you would like an explanation of the code go here http://www.moddingcentral.com/~oblivion/ I dont think this is allowed but its for the better. If you want to copy and paste the code then do it thru this the PSC page.

This is a page I wrote that works like a recordset. Yet I know this is not the most effiecient way to do it but it works. If you have a better way of doing this I would be interested in seeing it. You will have to change the database, Tables, and Fields to suit your needs. Requirements: PHP and mySQL

This is to teach you how to connect to your mysql database and select a table. I have made it very clean and added comments to help you understand the process.

Dbfunk is a set of generic databae functions for your PHP scripts. It includes simple to use functions to insert, edit and update, delete or view database table content. The functions pull out table fileds directly, so you only need to specify table name, whatever the structure is, dBfunk will manage it for you. A sample application is provided to show function usage.

This code will search trough an MySQL database and display the number of results as you want. You can say i want a limit of 25 results. If there are more results this script will print : 'Previous' 1,2,3,4,5,etc. 'Next'. I quarante you that this code works for 100%! If you want to see this code alive you can visit one of the sites i.ve made : http://www.yipee.nl, this site uses this code on several pages. If you like tjis code, please vote for me.

View, Edit any table in a MySQL database. Code is parameter driven, so you select what tables and what columns to display. Primary keys are always needed but those are hidden.

one of my friends ask me to make a gbook, whitout mysql, so i made this code. the code checks your email and password fits together and if it dont you get and error msg, if do it writes to the gbook.

This script takes the contents of a MySQL table and dumps it to either a dynamically-generated MS Word File (file with ending '.doc') or a dynamically-generated MS Excel File (file with ending '.xls'). You can place this script on any Unix/Linux or Windows Server running PHP & MySQL, but you have to access it using a browser on a Windows computer with Word or Excel installed on it. This script does not use COM objects and does not support multiple Worksheets in Excel. It can be used not only for creating complete dumps of MySQL tables (as Word or Excel files), but can be very easily modified to support just about any kind of select statement you'd like to use.

Tom’s Corkboard is PHP package I designed to provide a forum environment with a different vibe. Posts appears as though they are new 'sticky notes' on a Corkboard by the 'fridge or in the office. To preview the code in action, visit www.tomgroves.net.

Free Guestbook, you can download it to use with your website, it is free. but please leave my name anywhere of the page. this is the PHP code working with MySql Database. PHP Recordset paging. as I try to search the net for long and I can not find one of recordset paging in php so, i decided to write my own and work for all user. just edit it. not so hard I just write a function so, you just give the total row and dipslay per page, and page number. that's all want to test check out at: http://www.kindcam.org/freeware/guestbook/index.php

GrantMySql script allows user to manage users and rights of MySql database from Web browser in easy and simple manner. It is useful for novices as well as for advanced users. If you do not know line syntax of MySql or need often to change or give rights for MySql database, this script is ideal for you.

This article is for people who are interested in how PHP deals with uploaded files and databases. It walks through the steps of creating a database-driven picture repository, and includes the code to set you on the correct track. It starts out with how PHP deals with forms, then progresses to files, it deals with PHP's interaction with MySQL, and finally ends putting it all together to build a simple picture repository. The tutorial is 11 pages and is in PDF format.

phpReportGenerator is a PHP class which generates customizable report on any given MySQL query. You need to just pass the query as a resource id and then change the various look-n-feel parameter of your table like text color, header color, table border, size and many more. then finally call Generate Report. Thats all. This class will be very handy for rapid application development where you need not to point out details of writting table generation script, positioning and parsing. The class will do everything for you by default. Very Handy snippet. Hope you will vote for me. A usage.php file is included to demonstrate how to use this class.

This class is used for easier database usage. It can connect, query and close from mysql. Very easy, and very simple!

PHP Datagrid with MySQL support add, update delete feature. Ideas taken from ASP Datagrid developed by (Omeya Ambre). I have convert ASP code to PHP, I have tried to find PHP Datagrid on Net but could not find anyone which fulfill my requirement. At last, I decide to convert Omegya Ambre Asp code to PHP and some more feature including header color, cellcolor, bordercolor defination facility I am trying to improve it more. I am not responsible for any damage caused by this script. Enjoy and Vote for this.