Results for "Category: String Manipulation"

The following procedure acts similar to strtok in C++. Call it once with your string (S), and then everytime you call it from there on out, you can break your string apart with tokens! Included is a function StrMid() and an overload for StrMid that simulate the Mid() function in Visual Basic.

This program was made to show you how to convert number bases easily and efficiently. The program supports binary, octal, decimal, hex, and ascii(base 256). Please vote on my code.

This shows how to Encrypt a string, and also how to then Decrypt that string, its a little incomplete as all characters(only symbols) arnt set, easy changable to any key you like!, rate what you think please! marty.

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.