 |
 |
 |
 |
|
|
Browse | Submit A New Snippet
Snippets by category: Databases
| Snippet ID | Title | Creator |
| Snippets | ||
| 6 | JQuery - Simplified database queries | joker |
| A function to perform database queries on MySQL servers. Takes one argument; The SQL statement. | ||
| 13 | Database Abstraction Layer | tim_perdue |
| MySQL database abstraction layer so you don't have to hard-code mysql() all over your code. Someone can take this and create a Postgres or interbase version as well. | ||
| 29 | PHPMyGeneric | riedel |
| A set of PHP3-scripts to adminstrate MySQL databases over the web. Idea: Encode GUI specs in MySQL tables. Features: Generates GUI to MySQL databases automatically. Uses MySQL and CGI realms for user authentication. Search databases by up to two fields. Sort by any field. You need to activate track_vars in your PHP.INI file. This snippet contains serveral ascii files concatenated one after another and separated by 'BEGIN' and 'END' tags that are not part of the PHP code. | ||
| 31 | get insert ID from PostgreSQL | mcrbids |
| Mysql has it, why doesn't PG? This lets you do the same thing. | ||
| 53 | MySQL Database Optimizer | nirvani |
| This optimization script can be ran safely without shutting down the MySQL server. It is handy for optimizing tables in a MySQL database. Optimization helps prevent corruption and increases the speed on you indexes. Personally I use this script to optimize the tables that run my forum at http://www.smackdown.com/. I run this using the CGI version of the php binary (that is php configured --without-apache). This program has also been tested and known to work with php 3.0.16 and php 4.0.1 pl2. Note: don't forget to change your HOST, USER, and PASSWORD to your own settings in the "CONFIG" section of this program. Enjoy, -jeremy brand (AKA: Nirvani) jeremy@nirvani.net http://www.nirvani.net/jeremy/ | ||
| 60 | MySQL Database Monitor | pgatt |
| This will check the status of all of your MySQL tables in all of your databases. Extremely easy to use. If an error is found, it will repair the table and send you a warning. If it cannot repair the table, it will send you an alert (to your cell phone / pager). | ||
| 78 | Database Abstraction Layer for oracle. | yavorsh |
| Oracle database abstraction layer so you don't have to hard-code oci?() all over your code. This is a port of tims database.php file. It's not completly functional as some functions couldn't be ported to oracle, I think I managed to get the ovaral usability of it. Bug come it plenty so just mail me about it ;) | ||
| 1354 | class for database connection and database selection | ramsonphp |
| uses of constructor in class for database connection and selection | ||
| 320 | Postgres recordset to XML | mcm99c |
| This function translates a Postgres Query Result into an XML DOM object. Please check requirements for using this function. | ||
| 108 | MS SQL & php4 : a complete example | phactor |
| Tested in W98/WinNT/WinNTserver! Shows a complete forms-to-php (self posting) MSSQL query. Notice the stored procedure ALSO works, but for some reason won't show the COMPUTE avg(price) figures in reptq1 (which I've internally replaced with 'xxx') | ||
| 135 | PHPdbView | tudor |
| Outputs the contents of an entire database in HTML tables. Take care not to use it for huge databases. | ||
| 940 | ORACLE Session handaling mechanism. | imatyssik |
| If you want to store you sessions in the oracle DB and speed it up with Packages and stored procedures. Also locking is handaled correctly, not like other implimintations. Emulates file locking and implise correct session bihavier. | ||
| 941 | oracle smart php session handaling. PL/SQL | imatyssik |
| This is a small package to handle sessions in oracle. Strong usage of PL/SQL, so php does not do much. Very quick and scalable. Enjoy! | ||
| 146 | Another Database Abstraction Layer | xzilla |
| A "thin" abstraction layer that is class based. It allows all connection information (host,un,pw,db) to be defined in the library rather than in your php scripts. This is done so that if you need to run different databases in production vs development, or if you have database information changes (host,password,or even database name) you only have to update this central file, all of you php scripts can stay unmodified. | ||
| 147 | uploader | aidanpeiser |
| this script can help you get your data base up and running, you can upload html and discriptions ,then you can easly edit your script or delete it from your data base! | ||
| 165 | Parsing an Oracle Stored Procedure | anudit |
| This is a class designed for parsing an Oracle Stored Procedure. Most if us use Stored Procs as a kind of an Abstraction Layer between the Database and the Presentation Layers. Writing PHP code to run a stored proc neeeds quite a bit of work. This class is designed to make that easy for you. It only asks that you write your procs in a way that the returned resultset is always a REF CURSOR. At the end of the listing I’ve written examples of how to use the class | ||
| 169 | PHP-odbc_group_check | jeremy_brooks |
| PHP4 odbc-based scripts to 1. protect a PHP page with user auth info stored in an odbc db (encrypted password, login attempt logging, IP logging, last/current login date, etc) and 2. sets view permissions on a per-page basis (i.e., users in groups 4 and g can view this page, etc). Written for Windows/Apache, but only has a few lines (path to log files and includes/requires) that are plaform-specific. Latest version at http://www.datapriority.com/GC/GC.html . Bug fixes/suggestions are welcome! | ||
| 181 | Prev Next Button for Database | berni |
| This little Script build the prev- , Pages- and next- Button for a given Select-Statement. More Infos can be found at : http://www.php-resource.de | ||
| 1218 | Sortable Table Using CSV Files | sallyje |
| This table will read data from a csv file and create a sortable table. By clicking on the heading the table will be sort/reverse sort | ||
| 185 | PostgreSQL Abstraction Layer 1.0 | cemux |
| Easy way to access database and store fetched results. Database connection and query operation implemented in a separate class to play with multiple query results simultaneously over the same connection. | ||
| 192 | cmysql_mset | markitos |
| A simple mysql class to connect to mysql server, search in a Database and run SQL statement. | ||
| 194 | README | markitos |
| README file class CMySQL_MSet | ||
| 195 | How to test | markitos |
| How to test class CMySQL_MSet | ||
| 209 | Dynamic PHP | alanl |
| I searched for a day to find an example of running some PHP that is embedded in the middle of a string that was read from a database. I couldn't find anything, so I wrote this instead! What it does is find any occurances of <?php blah; ?> in a string, pull out the php code, run it and shove the result of the php back in the string. Restrictions on usage (tech not legal!) are: . The php must be a single function call; . The function must return its output, not print it. For example, I've used it on a dynamic web site that's essentially text article based. The articles are in a database and sometimes the writers need to link to other articles. Originally, they just hand wrote the <A> links, but that lost the context variables when the users followed the links (the site doesn't use cookies). Now the authors use "<?php link_article(article_id, "channel name", "link text"); ?>" instead, and the context variables are passed on the links. | ||
| 235 | PostgreSQL database abstraction layer | tmchow |
| This centralizes all the database connection info such as host, port, etc. It is class based and provides an abstraction layer above the php postgres api. Same class an be used to connect to multiple databases on different servers and on different ports. It is a modification of xzilla's original abstraction class with more functions, support for transactions, and error checking. | ||
| 245 | PHP3/4 PostgreSQL Abstraction Class | xonic |
| This is a database abstraction class for use with PHP3/4 and PostgreSQL (see TITLE). This class uses internal error handling (e.g: if a query screws up, it won't be outputted thru the server, so end users won't see ugly SQL error messages. Also, all functions are interrelated to one and other resultId's connectionId's and the like are all handled internally by the class, so one you execute a query, you can find out the number of rows returned in one function call with no parameters. Who would wanna use this class: 1) People who do not want sql error output to the browser 2) People who want customized error handling 3) Developers who want a well designed database abstraction class. Who wouldn't want it: 1) People who don't like to handle errors (but if you design you database / query's well, you should have no problem. Anyhow, enjoy! (im working on a even better version) | ||
| 248 | Basic Logging / counter | tom_g |
| This is a basic logging counter program I have been using. I appreciate any and all comment on my code as I am relatively new to php and imagine there is always a better way to do something. Thanks for any tips. | ||
| 1234 | PHP Code Generator | mknebel |
| Fill in the fields you want and generate add/edit/delete script in php/mysql instantly. Free online use! Other FREE utilities include mail from generator, and more! | ||
| 257 | 4 Column Spreadsheet | neilm |
| This script simulates a spreadsheet using any MySQL table with 4 columns (fields). The first column must be an auto_increment integer named "id" but the rest you can rename using the config variables. | ||
| 258 | mycnfOptions | salmon |
| Inspired by Perl DBI's built in support to read MySQL options from the standard ~/.my.cnf, I thought I would be nice to have the same support in PHP. That's what this class does. It reads options from any specified group in ~/.my.cnf and returns an associative array. Read the top of the file for more info. | ||
| 260 | M4Cache | erebos |
| Caching system, fast and flexible | ||
| 268 | sql_parse() | lemming |
| small but usefull function to parse a var to be valid in a sql query-string. | ||
| 295 | Paging.php | pylem |
| Simple classe to display a large recordset in a paging format. Customize to your needs. | ||
| 296 | mysql2xml class | rumblefiz |
| this is nothing major but i needed to convert a mysql resultset to xml so here is the class. it is basic but use as you wish. | ||
| 298 | SQL Apostrophe checker | pauljbroderick |
| Checks the string parameters in a SQL query for single quotes and replaces them with 2 single quotes where necessary. This is required for MS-SQL where you may need to have an apostrophe in a string. | ||
| 308 | Entity object | pwargn |
| Object that map a table row in the object world. - Create object from DB (using table and key). - Create an HTML fragment for read only display of read-write (form). - Re-create object from POST variables in the page called by the form. - Save object to DB. | ||
| 348 | mysql duplicate record finder | tsmith |
| Simple loop to find duplicate email addresses. The original problem was to clean the data from a 8000 record database of users. The users had been id'd only by email address and this had not been enforced as unique, so a lot of duplicate records existed. This script loops though and finds teh duplicates. | ||
| 356 | How to split the result into pages, like 'limits' in MySQL? | neilc |
| Ever wanted to split the results from your ORACLE query into pages, like the 'LIMIT' functions on MySQL. Well, in this tutorial I explain just how to do that with out sacrificing ordering the results. I also explain the queries in detail. | ||
| 370 | myCSV-dump for PHP | jodelking |
| "myCSV-dump" converts a simple CSV-flatfile-database into an MySQLdump, so that you can import it easily into your MySQL-database. Great timesaver when upgrading from flatfile to SQL-databases! | ||
| 376 | columns 2 variables. | owenborstad |
| Sets a series of variables named from the column names to their values from a row. | ||
| 383 | MySQL sample | dark_zero |
| Conect to database MySQL | ||
| 1221 | mySQL next and prev builder thingy | rzilavec |
| Pass it a mysql database link, an sql statement and a total results to show. Then access the sql results plus total results, next and prev all created for you. | ||
| 399 | PHPDBI: PHP MySQL Database Interface | joeli |
| A class for MySQL Database. Very similar syntax to Perl DBI. Sorry for no documentation. | ||
| 406 | A mySQL Table to HTML Table Snippet | hachiihcah |
| A General case table display snippet that allows for paging, sorting by column, and customizable HTML formatting. Brought to you by www.hachisoft.com | ||
| 418 | uploading/downloading images in oracle using PHP | grk2kin |
| This snippet will help in understanding the uploading/down loading the images into databases. You can upload any file.But it is limited to .gif files only when down loading. You can make chages to the code so that it will work for diffrent image types. | ||
| 447 | Repair | schnuffie |
| This little script crawls through a MySQL server and tries to repair all tables. Easyly costomizable, clear output with all errors, waning etc. | ||
| 1282 | Hit Counter | robelctg |
| Unique Hit Counter (IP Based) Azizul Islam (Bangladesh) Demo: http://www.samren.org http://www.samren.org/admin | ||
| 483 | MySQL Field Name and Row-based Results from a Select Query | esammons |
| This functions takes an SQL statement and returns the result in an array in the following format: $Result[fieldname][row] This helps prevent having to remember the order of fields in a select query result | ||
| 484 | car rental online reservation script | markl |
| this is a car rental online reservation script utilizing freesql.org's (http://www.freesql.org) mysql server. | ||
| 506 | phpInsertUpdate | jmayoff |
| Automatically insert record to or update a record in a MySQL database, based on fields in a form. Replaces long, complicated INSERT and UPDATE queries. | ||
| 533 | Simple table update in while loop | zeropaid |
| an easy way to update a row in a while loop. | ||
| 545 | cfquery for postgres | initsoy |
| small function which takes some simple parameters and returns a query much in the form a CFQUERY would in cfml. Used to help aide CF developers move towards PHP. Currently only designed for postgres but would be nice to convert to multiplatform. | ||
| 551 | postgres table display | initsoy |
| displays a diagram of a postgres db and list of tables and sequences. A good quick a dirty view of a DB from a web page. | ||
| 557 | MySQL Searching Class | smckone |
| Search a mysql database without writing a query. | ||
| 1322 | RC4PHP | raul_ionescu |
| Raul's Classes for PHP. Contains database abstraction classes with pagination support for SQLite, MySQL and MSSQL. | ||
| 584 | DB Variable Dump | funktion |
| Takes the data in a table row and places it into variables of the field names. eg. $myrow["Id"] is now $Id Useful if you have a lot of fields and are using heredoc syntax which doesn't support array variables | ||
| 613 | Mysql Class. | khaine |
| Easy to use mysql class that has basic database access with error checking. | ||
| 642 | Database Abstraction Library for 4 Databases | matto |
| Plug this include into your pages, configure the essentials (DB type: MySQL/Postgres/ODBC/Oracle; access data), and you can use simple db manipulation functions. Error printing can be turned off for a specific host; Oracle error logging provided. Instructions inside. Please feel free to improve. | ||
| 644 | IBDbObject | sumba |
| A caching Interbase 5.x/6.x database abstraction layer. Support for transactions, multi-querying. Stores the resultsets in associative and numerical arrays for easy handling. | ||
| 651 | MyDBObject | sumba |
| Database abstraction layer for MySQL. Caching of the resultset in both numeric and asscociative arrays. Enables you to jump both forwards and backwards in the resultset. Basic XML-output of the resultsets. Debug and logging functions. | ||
| 1266 | mydbackup | phfeenikz |
| This is a backup script for MySQL using the mysqldump command. It was designed to be used with crontab to automate a database backup. It can be configured to switch on certain command line options that control the output of the backup. | ||
| 684 | parse a CSV line | cveld |
| If you want to get the different arguments out of a comma seperated value line then this snippet is your right choice. it understands quoted arguments and escaped quotes. | ||
| 1188 | Class dbMySQL | rk_maciel |
| Classe de manipulação de banco de dados MySQL via PHP | ||
| 749 | MySQL Database Abstraction Class | simon622 |
| Use this class to separate database processing from application logic. Supports persistant and non-persistant connections, error handling and logging, action instance logging and tracking, to debug any troublesome code. Will format and return a tabulated dataset of any query, or will return just the result resource for use. | ||
| 1318 | Backup And Restore Postgres Database | parxal |
| This is a script made with php for backup and restore a postgres database. Like pgdump. | ||
| 1319 | Save and restore files In Postgresql database (Php Class) | parxal |
| A class to save and restore files in postgresql database. in the end of the class there is an exemple. | ||
| 1279 | PHPRunner | xlinesoft |
| PHPRunner builds visually appealing web interface for any local or remote MySQL database. Your web site visitors will be able to easily search, add, edit, delete and export data in MySQL database. Advanced security options allow to build password-protected members only Web sites easily. PHPRunner is simple to learn so you can build your first project in just fifteen minutes. | ||
| 798 | Poor Man's ISQL (MySQL Style) | rodneyj |
| Much like Yurko's "SQL Terminal" above, this lets you run raw SQL against the database using a web interface. I use frames for this so standard editbox functions, like "undo typing," etc. are preserved between requests. It also allows the output to be sent to an excel spreadsheet so that ad hoc queries can be mailed rather quickly to your screaming accounting and marketing people (you know how they love their spreadsheets). This app is usually the first thing I build in order to get used to a new webserver/database environment, and thus was one of my first php scripts when confronted with a php project. It's a good tool, especially if you're not at your desk and need a quick way to get at the back end data. Also included is the approximate execution time of the query, very useful when you are tuning the database. I tend to use long variable names in lieu of heavy commenting and I have a reverse indenting style because it seems to be more readable when word-wrap is turned on. You'll also notice that I don't really care about the aesthetics of the resultant HTML. I apologize in advance if this perturbs anyone. | ||
| 805 | EasyDatabase | umutphp |
| Handling several databases at he same time easily | ||
| 1179 | MSSQL SERVER stored procedure from php | deathrocker |
| hi, just a want to contribute with a little code for to call stored procedure from ms sql sever in php, using parameters and exporting the result query to Excel file. in spanish: hola solo queria contribuir con un poco de codigo que llama a un procedimiento almacenado de sql server desde php y exportando el resultado de la consulta a un archivo en Ms Excel. espero sea de mucha ayuda. | ||
| 1090 | Session MySQL | mincdamon |
| MySQL Database session management | ||
| 869 | set up page numbering based on rows in database | cribs |
| The only variable you will need to change is to set the total number of rows you want to display on a single Web page. This script will retreive the number of rows in the database table, divide the number of rows in the table with the total number of rows to show. If there is any remaining data to show it will add one page to the total number of pages. Set the minimum number receive data for each page and set the maximum number to stop data for each page. Set up the display for the page links that will show at the bottom of the page. I have designed a sample template page to show you how to include the script into your PHP script. | ||
| 886 | Distance from Latitude - Longitude using Haversine Formula | spock42 |
| This code provides the mysql formula to locate and/or compute the distance between two zip codes given that you have a database of zipcodes and latitude/longitude. I couldn't find a good version of this anywhere else and getting the () right in mysql was a bit of a bear. Hopefully someone else will have a shorter project starting with this. | ||
| 901 | Page MySQL Results | kosmidis |
| A Class for paging MySQl results (included an example on how to use it) | ||
| 903 | Connect to Mysql and select db | kosmidis |
| a Class for OO programing to connect to mysql and select a specific db | ||
| 912 | Create and Delete tables in an existing database | panosa73 |
| A very simple Create and Delete tables snippet. Requires some knowledge of mySQL. Tested with PHP 4.0.6. | ||
| 932 | cleverSql | doleg |
| A smallest tool for remote MySQL administration! Cool interface fits only 6 kb!!! | ||
| 944 | MYSQL query Simplified | leonardburton |
| This script is used when you have more than one table where names are stored. I created it so that I could get names of accounts, vendors, or payment types for a ledger program that are associated to a number. You pass to it a number as $acct and what type of name you want (i.e. Vendor, Account, Payment Type) as $type. | ||
| 1166 | Online Bible (brazilian portuguese) | bobfrank |
| Bible in portuguese. Scripts PHP/MySQL with cookies to save versicles. | ||
| 980 | PSQL_DAL for PostgreSQL DB | jorch |
| Another query interface for PostgreSQL databases. Handles connection parameter settings in several different ways. This moment class has only one method (dal_query) wich makes actual query work and returns 2 dim array containing resultset in easy-to-use array form. (see manual= put PSQL_DAL.php file into your web site and view it with ?help switch (PSQL_DAL.php?help)) | ||
| 1160 | DB_eSession class securely stores PHP sessions in a MySQL DB | toplay |
| DB_eSession is a feature packed PHP class that stores session data in a MySQL database rather than files. It is powerful, designed with security in mind, and yet easy to utilize. The code contains lots of comments, it comes with full documentation, and examples of how to use the class including a basic authentication login/logout process. It includes member functions useful (to webmasters) for monitoring or viewing, deleting, and altering sessions validity like in the case of locking one or more sessions upon detection of unauthorized use. This custom MySQL database session handler class might just be what you're looking to implement on your web or intranet site. See the list of features below: General features: Stores session data in a MySQL table using PHP's built-in session handler. Built-in handling of session expiration and cleanup. Supports the changes of session related configuration settings (inc. PHP5). Allows for normal or persistent MySQL database connections. Access to opened MySQL resource connection to use in your script. Accepts a passed database resource link to use as the DB connection. Supports session ID's between 12 and 32 characters long. Custom or changeable database, table and column names. An option to create new session ID's (you supply, class or PHP builds). Can initiate buffered output (using ob_start) within the class. A session_start() automatically initiated within the class. Can send 'Cache-Control:' header output within the class (fixes IE6 bug). Ability to retrieve a specific sessions expiration date and time. Retrieve current session life setting in seconds or minutes. Retrieve a numeric total of the number of active and inactive sessions in table. Facility to make assignment and retrieval of session variables easier. Ability to create manual URI's and links that includes session name and ID. The ability to retrieve what the MySQL server version number is. An adequate form of encryption/decryption methods/functions are included and used automatically when libmcrypt is not installed. Security features: Standard user inactivity time-out handled automatically. Absolute user logoff time-out capability (session will be terminated no matter what after a number of designated minutes/seconds have elapsed). Ability to lock and unlock a particular session or all sessions. When a session is locked, it is immediately not available for use. User to session verification using IP address and browser information. Security level (code) clearance for each session/web page. Encrypt/decrypt as desired each session field. Encrypt/decrypt an extra session field to compare against original (to detect against possible tampering). Encrypt/decrypt the whole session data in the table (essentially obscuring session variable names in table). Can be used in combination with per session field encryption, resulting in double encryption security. A new encryption Initialization Vector is created every time values change. Ability to manually delete a particular session or all sessions. The users IP address and web browser is recorded as part of the session for tracing information. Other features: Support for multiple language error and warning messages. Support of a default language as well as current active language settings. Basic or detailed (with SQL syntax) error/warning reporting. Buffered error and warning messages. Option for class to stop execution or not upon encountering an error/warning. Class can display errors/warnings automatically or control in your script. Can select font color and size separately for error and warning messages. Code has lots of comments and formatted within 82 characters wide. Full documentation (only provided in English) is included. Code use examples provided, including a basic authentication (login/logout) process. SQL text file provided for creating the MySQL session table. The class code is too big to fit in this snippet area. I tried once and the source code got truncated. You can download a full package file of zip/tar/sit at: http://www.code.dearneighbor.com | ||
| 994 | Postgresql trigger: last modified time | sxooter |
| This is an unltra simple trigger written in plpgsql, the standard procedural language of postgresql. It updates the lm (last modified field) of a table every time a record is inserted or updated. Requires plpgsql. | ||
| 1253 | Advance Flash Guestbook | shinici |
| Flash guestbook with avatar, using php and mysql. feel free to download and contact me | ||
| 1011 | database viewer | joee563 |
| This is a simple url driven database viewer/editor. Note: this assumes you use a field called id as the index, if you're clever, i'm sure you can figure out how to change it to whatever you need. | ||
| 1019 | ODBC (Access) -> MySQL Conversion | jfarrell |
| Running this script will take the selected ODBC datasource and place all the data into a MySQL database. Please be sure to have the MySQL database setup and ready before running this script | ||
| 1021 | Previous, Next and page numbers for a database listing. | hurgh |
| I could not find a script that i liked here that would suit what i needed, so i wrote my own and decided to put it here for anyone else that might need some help with this. It uses the MySQL LIMIT function so if you dont have a MySQL database or one that has the LIMIT function then this will not work for you. Please leave my little credit note in the code. Thanks If you would like to discuss this code you can do so at my forums, just make a topic in the Chit Chat.... -|- Hurgh -|- ________________ Website: http://www.hurgh.org/ Forums: http://forums.hurgh.org/ | ||
| 1030 | Access Style DLookup function for MySQL | bjlevine |
| Small but handy function to emulate an Access-style DLookup function. | ||
| 1278 | PHP & MySQL Code sample for utilizing dynamic drop-down val | tshriram |
| Dear Sir/Madam, Good Morning, I am new to PHP & I need some help. I am working on one online Data Entry form in which some fields contains drop-down values and I want to populate those values directly from MySQL tbl. I have total 7-8 fields in same way. & Some reason, it's not giving me correct output. Also, if I try to run this simple piece by itself, it does give me values and when I include in HTML file, it doesn't work for me: the code I'm copying below: When you've time, can you please advise me on this? Thank you very very much in an advance. & Have a nice day! | ||
| 1038 | automatic form generator | cerebis |
| a function to display a form to insert values into a database table, automatically generating the form from the table, without the programmer explicitly have to name every field. Other options include default values, hiding fields and more. Fully commented(ish!) Insertable into your own pages completely transparently. | ||
| 1314 | deeMySQLParser | deeco |
| a mysqldump parser..returns table structure of a dump in a nice associative array. | ||
| 1276 | CMysql - MySQL class with nested query functionality | forge137 |
| A utility class I've written and refined over a few years to simply MySQL database access in PHP. Most notable feature is the two sub-classes that make it easy for one to do 2 and 3 nested queries on a MySQL database. Code snippets provided within the class. Hope it's usefull to you as it's been to me :-) | ||
| 1273 | MySQL database abstraction class | mwk5v |
| This is a simple class I wrote to simplify my interactions with a MySQL database. I wrote it to return my results as a simple array, rather than a complex mysql object requiring the mysql_fetch_* functions to use. Maybe someone will find it of use. | ||
| 1224 | CSV to table Simple form :) | duppie |
| With this code u can display a CSV file in a table. | ||
| 1070 | Upload image file into mysql. | zs_strong |
| Upload image file into mysql. | ||
| 1071 | VERY SIMPLE MYSQL VISITOR-COUNTER | drucifer |
| MAYBE NOT THE OBVIOUS WAY TO GET THERE BUT ONLY TAKES FIVE MINUTES TO GET GOING. | ||
| 1074 | Connection interbase client | gkmciftci |
| connection to interbase server with Borland 5.02 api | ||
| 1076 | PHP Database Info | sethtrain |
| Choose you database and then your table. This scripts provides you with information about the fields in your tables. | ||
| 1077 | PHP SQL query tester | sethtrain |
| Test your queries with this script that returns the results in table form. | ||
| 1093 | MySQL Dataset | xhadow |
| This is a PHP Class that connect to MySQL, retrieve the tables and return it as dataset/recordset object. Examples provided at the end of the script | ||
| 1099 | order by date difference in mysql | himadrish |
| We can used this function to work with form objects. When ever we want to change the logic just change this function. | ||
| 1100 | ODBC connection | himadrish |
| Used this to make a connection through ODBC, you can connect oracle, sql server, access, mysql using php, vb etc. | ||
| 1102 | Hafizan | alien3dx |
| A php and mysql template to speed up php and mysql program developement | ||
| 1108 | clsPaging() - paging class for mysql recordsets | zubfatal |
| A simple class to page a MySQL recordset. | ||
| 1110 | Displaying records in 3 columns | mihey |
| Very easy way for displaying records in 3 columns (horizontally & vertically) | ||
| 1112 | PHPwithDotNetSqlClient | himadrish |
| The files are helpfull with working with .Dot Net SQL-Server client. The above also be integrated with SQL-Server. Development projects under technology in PHP+.Dot Net Sql Client OR PHP+Sql-Server will be get maximum benifit from this codes. all the best. For any query, pls do not hesitate to mail me at himadrish@yahoo.com. Regards, Himadrish Laha | ||
| 1122 | Check And Repair MYSQL | alexku |
| This script checks for errors in your database tables and then repairs them when they are found. It performs a check on all the tables then if it finds an error the script attempts to repair it. If the repair fails it tries to repair it with a better repair method that takes longer and may result in extra rows appearing in your table. If that repair fails then it uses its last resort and tries to rebuild the table. After it is done Checking and Repairing the table it will Optimize the table. The script documents every step that is taken and then display the check and repair log on the screen. This script only requires you to configure 5 things. | ||
| 1311 | phpMySQLAutoBackup - automated MySQL backup | seiretto2 |
| phpMySQLAutoBackup automates the backup of your MySQL databases. Exports your database (data and structures), compresses it into gzip format and emails it to you. Schedule it to run every day/week by adding it to a cron job, or use the excellent phpJobScheduler. Download free from: http://www.dwalker.co.uk/phpmysqlautobackup/ | ||
| 1127 | MySQLPagedResults | nsanden |
| This is class creates 1,2,3... links and previous/next links which will page through any records from a mysql database table. It can easily be modified (one line) to use with any database however. | ||
| 1142 | Php Private Chat | kakchan |
| Hello this script is very usefull when you need unlimited chat on your web site, is very easy to install, create 4 file and put the follow code into them... this script is fully open source you can modify it as you needed but notify me before. remember to change db settings with your own settings Database Dump: # # Table structure for table `chat_private` # CREATE TABLE `chat_private` ( `chat_date` int(10) default NULL, `chat_psw` varchar(20) NOT NULL default '', `chat_msg` text NOT NULL ) TYPE=MyISAM; | ||
| 1356 | Micro Database Browser | phptoys2 |
| Micro Database Browser is a simple PHP script which can list your available databases, tables and displays data stored in it. It's purpose to give you an easy installable product to verify your actual DB status without installing professional database management tools. | ||
| 1362 | Flash Client for MySQL Administration | tufatmarketing |
| Flash Client for MySQL Administration | ||
| 1363 | Flash/XML RSS 2.0 Viewers | tufatmarketing |
| A set of simple RSS readers with fresh designs and animation. These will read RSS 2.0-compliant XML feeds. 100% of the Flash source code is included. | ||
| 1365 | Advanced Datagrid component for Macromedia Flash | tufatmarketing |
| Enhance the Macromedia Datagrid component (Flash 6 and Flash 7 versions included). NOTE: This software also goes by the name <b>Advanced DataGrid</b>. | ||
| 1368 | Easy Content Management for PHP/MySQL | tufatmarketing |
| Create a content-managed website quickly, with no programming! Similar to site-builders like Geocities. EasySite is the only layer-based CMS of its kind. That means that all content areas & menus are DHTML layers which can be positioned anywhere! | ||
| 1375 | PDF Report Generator for MySQL | tufatmarketing |
| Create PDF reports from MySQL tables, using a customizable, Flash 7-based layout builder. | ||
| 1377 | PDF Converter for HTML and Postscript | tufatmarketing |
| This is a PHP equivalent to the popular Perl script by the same name. 100% FREE for commercial AND non-commercial use! Render pages as PDF documents or PostScript files. Options available for FPdf generation, form processing, PDFLib support, and many more! | ||
| 1389 | The opposite of mysql_fetch_assoc | lunlun |
| The mysql_fetch_assoc "converts" a row from a table into an associative array. The mysql_insert_array "converts" an associative array into a row in a table. | ||
| 1393 | Nitobi Grid V3.2 | nitobi |
| Display & edit tabular data in various web browsers with Ajax-powered Nitobi Grid V3. With minimal coding, Grid delivers responsive, interactive dataset editing in a dynamic user-interface. Available for ASP.NET, JAVA, PHP and classic ASP. | ||
| 1394 | XML VIN Decoder | jpereira |
| The XML VIN Decoder is software that decodes car and truck information from the VIN number. Such things as comprehensive features, options, colors, warranty, etc are decoded for each vehicle from 1981 to present. | ||
| 1416 | MySQL and PHP Chache class | halityesil |
| MySQL and php chache class unsid : User manuel id key string example session_id() only method (update check delete read) id : chache id sid : chache sid $obj = new pg_chache(unsid,[ id,[ sid ]]); Write method $out = $obj->write(unsid , yourstatus, yourchache ); Read method $out = $obj->read(id, sid, unsid); Update method $out = $obj->update(id, sid, unsid, yourstatus, yourchache); Check method $out = $obj->check(id, sid, unsid); Delete method $out = $obj->delete(id, sid, unsid); | ||
| 1417 | MySQL Abstraction Class | undefined |
| Database abstraction class Version 0.3 | ||
| 1422 | Myref class library | usefulclasses |
| http://www.usefulclasses.com/index.php?aid=myref&prc=readArticle This PHP class library is designed for PHP-programmers and Web-designers to make their management of select, checkbox and radio lists easy and comfortable. Every PHP-programmer faces the task of outputting a large number of lists (references) like either “select” element or “checkbox” and “radio” on the HTML-page. The core is that generally there are many such lists on the page and it takes a lot of time and efforts to work with the large amount of lists and references. Every list is actually stored in a separate table of a database and is extracted from it by its own specific request. If there are many of lists, the page code becomes too complicated to cope with. Moreover, if the system has been developed for a long time, it suddenly becomes clear that every reference should work in several languages at the same time, for example, in English, Russian and German. And program code becomes more and more inexplicable and complicated with every such upgrade of the page. So, we need a perfect tool for the comfortable work with any reference and it should work with all system references at once and provide them with a single API. This tool is Myref class library which solves two main tasks: it gets lists from database for further output on the HTML-page and provides administrative script for inputting the references into the database. | ||
| 1425 | better pagination | apollyonus |
| I found a tutorial that did basic pagination, but wound up with 3 lines of page numbers at the top & bottom of the page. (yikes!) This pagination script is similar to google's. | ||
| 1429 | Mysql Class Interface | lawliet |
| MCI will help manage mysql database common task, Its flexibility can manage big application by adding subclasses depend on your needs. | ||
| 1444 | DB (ActiveRecord style) class | dom111 |
| A database wrapper with functions similar to that of Ruby on Rails' ActiveRecord. It is not a true ActiveRecord implementation, but it does off very similar functionality. Included in this class is the main DB class and a record class. Available under the Creative Commons Share Alike license. There are more functions that enable a bit more customisation, but the basics are all in there... Any questions, suggestions, comments are much appreciated. <code> // initiate the main DB class $db = new DB('mysql://user:pass@server/db'); $users = $db->table('users'); $users->find(); // returns an array of all records from the users table $users->find_by_name('test'); // returns any rows where the name field == test $users->find_by_name_like('%test%'); // returns any rows where the name field LIKE '%test%' $users->create( 'name' => 'test', 'email' => 'test@test.com', 'enabled' => 1 ); // creates a new row in the users table with the specified data $id = $users->lastId(); // return the last insert id $user = $users->find($id); // find a user where id == $id $user->name = 'not test'; // set the name to not test $user->save(); // save the record $posts = $db->table('posts'); $posts->find_by_date_after(date('Y-m-d H:i:s', strtotime('yesterday'))); // find all posts from the past 24 hours $posts->find_by_title_like('%php', array('order' => 'date DESC', 'limit' => 1)); $posts->find_by_user_id_and_title_like(array(12, '%php%')); // find all posts by a certain user with title LIKE '%php%' </code> There are a few more functions, but most can be found by looking through the code itself. | ||
| 1455 | MySQL INSERT generated from all $_POST vars | qalimas |
| Generates a MySQL query from all fields on an HTML page. To add a new colum to insert data into, simply add a new field (make sure the field name is the same as teh column name in the MySQL table) and it does it all for you. I wrote this when I got tired of INSERT into whatever (id, name, date)VALUES('', '', '') and decided I wanted something to just generate it for me. | ||
| 1472 | vijayanand | testtesttesttes |
| test | ||
