Results for "Category: String Manipulation"
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.
If you're an old ADO programmer, you may be frustrated by not knowing exactly how to check for NULL. Here's a 1 second tip on how to do it in ADO.NET.
upload image(jpg) create thumbnail and store both in a database. Also can view images in database
This Project is an example of a Simple Multitier Application using a Business Rules Layer and Data Access Layer, to provide scalability to your applications. It uses SQLDataAdapters, DataSets and SQLCommands to Achieve the DataTransfer. The GUI Uses a Listview to Display the Dataset.
***UPDATED 01/22/2003*** This is the same as my VB6 program only it's been adjusted to compile in the .NET environment. It does as stated below. To retrieve a list of jobs on a given SQL Server (7.0 or 2000) and track it's progress through it's numerous jobsteps. This is typically a nice little app to have if you have many jobs that run throughout the day and you want to see if one of those steps has hung up. To make this app truly useful I added a monitoring timer that refreshes every ten seconds or so. The Restart Jobs button is not activated at this time, but the coding should be a snap someone wanting the ability to stop and start jobs from this application. This application is in it's infancy at this moment since I've been working on it for only a couple of days, but is useful even now as far as I'm concerned. Please vote if you like it...
A very small example of how you can using Access databases within your applications. I made this little demo after searching for hours on the net for an example and failing. Firstly I created A simple database in Access using 1 table called "people" with 3 columns, id, fname and sname. The app allows you to add new records to the database, remove them or change them. Excellent for beginners.
SQL Web Query using ASP.Net with VB.Net code behind. This is my first project with the new studio; I think this shows the intention of separating the presentation code from business logic. I have previously never done any ASP work so this is from a VB programmer. USES: ASP.Net, VB.Net, ADO, SQL DataAdapter and the web Data Grid. SETUP: Pretty simple really, all you really need to do is modify the connection string and you should be able to use it. For development I was using the Northwind DB from an SQL server. In the readme.txt I give more info on the setup. If anyone has a problem let me know, I hope I included all the right files. Enjoy
Professional programmers in the industry use serious project management software tools to coordinate development efforts. This is not one of those tools. Of course, it won't put you back several thousand dollars either. The main value to be had here is that Project Notebook is an excellent demonstration of data-binding in C# (something I was unable to find elsewhere). DataGrids, DataSets, Listboxes, Combo Boxes, Edit controls are all wired up together with very little explicitely-written code. Data is persisted as XML using a schema built in the .NET GUI. While all this database-related stuff is kind of dull - this is exactly the kind of thing that you would want to know about if you were writting any editting tools for game development.
UPDATED - May 17,2002 - I just added a SQL INSERT example VIA web form! Enjoy! Please leave comments and vote. Thanks! The zip file contains 6 working examples of various things dealing with the SQL Server. In the package, I also included a file that you can import into your database to use the same tables,columns and rows that I have used. Other Notes: - Examples One, Two, and Three have extensive comments. The examples following those contain no comments because they are exactly the same, except for different control names and types. - In each file, make sure you change the connection information. (Username,Password,Server..etc) I will update this with new examples, such as inserting, updating, using stored procedures and more! This took hours so please vote and leave comments!! Note: It is recommended that you know something about ASP.NET.
DataEasy_VB: is an application written in Visual Basic.Net (converted from the c# similar submission as some of you requested) which would allow the user to load any Microsoft Access file (file format '.mdb'). This application uses OleDb as a backhand communicator with the file to allow the user to : select, delete, insert and modify the database and then save all the changes to the original file. Along with the Data Grid control TextBoxs and Labels are generated automatically and dynamically at run time to allow easy and efficient data input according to the data in the .mdb file loaded. If the file has more than one table in its database, a combobox in the application will allow the user to choose which table to work on. By right clicking column headers who’s data type is either ‘integer’ or ‘DateTime’ the user can opt for either inserting Automatic numbering based on previous cell’s value incremented by 1 or insert that day’s date automatically in their respective column on adding new data. Also provided a Search and Filter capability, by right clicking the search form’s column headers the user can filter in the element (of the column clicked) he\she wants to view. Multiple filtering can be done by filtering more than one column. The user can also use a simple search, by typing in the search textbox to find data in the database. I have included a database file ‘textbooks.mdb’ file with the application so you can try the program. I hope this program will be useful in learning how to load and modify databases and link to ‘mdb’ files, your votes will be highly appreciated :).
This example showes you how to access a Microsoft Access Table using a C# class. Any feed back will be appreciate. Do not forget to vote !!!
If you're just wondering how to use MySQL with VS.NET or are having problems, give this a try.
This article tries to explain how to perform aggregate functions on your Datatable.