Results for "Category: String Manipulation"

This simple code plots a bar graph based on total results of a selected field on a selected table from a selected database. See a demo at http://www.industriavirtual.com.br/codedemo/rsgraph/default.asp If you like the code, please VOTE!!!

only change to your database name. yazi.mdb to yourdb.mdb ( find and replace in notepad )

It can make, edit, delete news articles. It has a rich text editor (from htmlarea) and supports multiple users. In this new version there are some bug fixes and you can now make news templates so you don't have to type out the same thing all the time, the new version also includes a general connection string found in conn.asp.

This code pages a database recordsets in a very cool way, like the good seaches on the web. The ideia I designed was to show all pages, but not all of them (imagine in a case of 1000 pages). So, it shows only ten pages placed in the point you are only, and a link for the last and first ones... It helps who does not have the patience to see all pages, and also for the ones who does.

I may be reinventing the wheel here, but so far I have yet to find a built in Delphi function that will convert a string to proper case. I found this code somewhere on the web a while back, lost it, and managed to recreate it last night.

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 imthiazrafiq@gmx.net Msn id: imthiazrafiq@gmx.net 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.