Projects tagged ‘export’ and ‘php’

Live Glossary is a web based application, which allows users to view, create and edit a Glossary. It also has an administrative portion from which the administrator can accept or reject additions or ... [More] edits, populate the glossary with delimited data from a csv file and export a pure HTML version of the Glossary. [Less]

With Pownce shutting down, I needed a way to save a local copy of the files I'd posted. Since there's only a week until the big shutdown, I needed to act fast. The best available wrapper for the ... [More] Pownce API is written in PHP, so...PHP it is! Given more time, I probably would have done this in Ruby or Python and make it runnable on the command line. Fortunately, PHP is available on basically every platform under the sun, so it's relatively easy to run this (if you're a geek). This code also uses the Zend framework and Blueprint to make it pretty, so grab that as well. (I haven't copied it here.) [Less]

This plugin is currently in developmentAboutThe MySQL Workbench Doctrine Plugin is a plugin developed for MySQL Workbench which is a tool for developing MySQL databases with a graphical interface. ... [More] The plugin helps you to generate database schemes for the Doctrine framework which is e.g. used in the very famous PHP Framework Symfony. InstallationPlease read also the Wiki article how to configure Workbench before using Doctrine Plugin. WindowsTo use the plugin with Workbench 5.1.x or 5.2.x copy the Doctrine plugin file to %APPDATA%/MySQL/Workbench 5.1/modules/To use the plugin with Workbench 5.0.x copy the Doctrine plugin file to %PROGRAMFILES%/MySQL/Workbench 5.0/modules/Changelog0.3.9 (KW) + [imp] foreignAliases now considering the cardinality one or many. if one is found, a singular foreignAlias is created, if many is found a pluralized foreignAlias is created 0.3.8 (JM, KW) + [add] added mapping of type YEAR -> integer(2) see http://code.google.com/p/mysql-workbench-doctrine-plugin/issues/detail?id=12 + [fix] removed the renameIdColumns function that worked with the (bad) Workbench default primary key and associative table naming conventions to be used with the Doctrine "detect_relations" option see the plugin Wiki page see http://code.google.com/p/mysql-workbench-doctrine-plugin/issues/detail?id=11 see http://code.google.com/p/mysql-workbench-doctrine-plugin/issues/detail?id=15 + [fix] removed binary flag for columns -> not supported by doctrine 0.3.7 (KW, JM) + [fix] changed conversion of INTEGER from integer to integer(4) + [fix] changed conversion of BLOB types from clob(n) to blob(n) see version 0.3.5 notes + [add] added DEC and NUMERIC to output decimal + [fix] now allowing DECIMAL, DEC, and NUMERIC to be specified with optional precision and scale + [imp] improved the save-to-file routine to work for previously saved files that do not exist anymore (file deleted, renamed, or moved) + [imp] restructured and simplified the supported types code 0.3.6 (JM) + [oth] changed conversion of INT from integer to integer(4) see http://code.google.com/p/mysql-workbench-doctrine-plugin/issues/detail?id=10 0.3.5 (JM) + [fix] type mediumtext | mediumblob -> clob(16777215) see http://code.google.com/p/mysql-workbench-doctrine-plugin/issues/detail?id=9 + [add] type longtext | longblob -> clob type tinytext | tinyblob -> clob(255) type text | blob -> clob(65535) 0.3.4 (JM) + [fix] multiple column unique indexes see http://code.google.com/p/mysql-workbench-doctrine-plugin/issues/detail?id=8 + [add] preparation for cross database joins (works with MySQL and PostgreSQL and maybe others) please switch the function getCrossDatabaseJoinsFlag() return value to "on" and restart MySQL Workbench (may cause problems with symfony) see http://www.doctrine-project.org/blog/cross-database-joins 0.3.3 (JM) + [add] support for I18n schemes with *_translation tables see http://code.google.com/p/mysql-workbench-doctrine-plugin/issues/detail?id=7 + [oth] replaced code indent tabs with spaces 0.3.2 (Karsten Wutzke) + [oth] small change in handling version information 0.3.1 (JM) + [fix] changed simple type "INT" to doctrine "integer" see http://code.google.com/p/mysql-workbench-doctrine-plugin/issues/detail?id=6 0.3 (Karsten Wutzke) + [fix] types BOOLEAN, BOOL, and INTEGER now working (aren't simpleType) + [add] lowercasing for default TRUE and FALSE keywords + [imp] default NULL, TRUE, and FALSE detected case-insensitively now (WB doesn't uppercase default values as opposed to all data types - which are keywords, too) + [add] added version info to module ID and menu items, like this plugins with different versions can be used at the same time (starting with this version and one old) + [imp] file export: added simple functionality to append ".yml" extension to file paths not ending with ".yml" + [imp] removed some unnecessary prints + [imp] shortened changelog entry types [improvement] to [imp] and [other] to [oth] 0.2 (Karsten Wutzke) + [add] foreignAlias for relations + [fix] exception thrown in relationBuilding on some tables with foreign keys where the column and referenced columns list has zero length + [imp] replaced all string.len() calls with the length operator #s + [add] function string.endswith() + [imp] eased the code of function exportYamlSchemaToFile (eliminated double if) + [add] functions to test if a (table) name is plural or singular + [fix] reanimated functionality for (English) plural table names + [add] functionality to adjust special (English) table names ending with "ies" to convert "ie" to "y" ("Countries" -> "Country") and more + [add] data type conversion of integer types and CHAR, BOOLEAN, and BOOL: TINYINT -> integer(1) SMALLINT -> integer(2) MEDIUMINT -> integer(3) INT -> integer INTEGER -> integer BIGINT -> integer(8) BOOLEAN -> boolean BOOL -> boolean CHAR -> string + fixed option + [add] option for CHAR columns + [imp] removed using the table name capitalization function (ucfirst) from function buildTableName(), like this tables retain their original names and the default Workbench naming convention "_has_" still gets handled correctly + [imp] replaced "\r\n" line endings with "\n" only + [imp] using lowercase for default null values + [imp] restructured MySQL plugin init code for easier understanding 0.1alpha9 + [add] function to save to file + [add] print version name on execution in debug window 0.1alpha8 + [fix] changed behavior of table renaming (thanks to Francisco Ernesto Teixeira) taBleNaMe -> Tablename ->[fix]-> TaBleNaMe 0.1alpha7 + [oth] changed the license from GPLv2 to LGPLv3 + [fix] removed plural correction of table names (deprecated in Doctrine 1.0) 0.1alpha6 + [fix] some conversion from workbench type to Doctrine type BIGINT -> INTEGER DATETIME -> TIMESTAMP + [fix] decimal (precision + scale) + [fix] enum handling 0.1alpha5 by quocbao (qbao.nguyen@gmail.com) + [fix] some conversion from workbench type to Doctrine type + [fix] removed generate_accessors [deprecated] 0.1alpha4 + [add] tables_has_names -> TablesName ->[fix]-> TableName + [add] rename columns "idtable | table_idtable" -> "id | table_id" 0.1alpha3 + [add] convert underscores in tablenames to CamelCase 0.1alpha2 + [add] nested set support for tablenames ending with _ns 0.1alpha1 supports: + [add] indexes [fulltext, unique, index] + [add] index length + [add] collation + [add] character set + [add] engine [MySQL, InnoDB] + [add] relations + [add] foreign key constraints + [add] table name fixing + [add] column flags [binary, zerofill, unsigned] + [add] autoincrement + [add] not null + [add] default values + [add] decimal precision + [add] column length [e.g. varchar(255)] [Less]

phpMyDumperphpMyDumper is a php class, that can be used for exporting databases and tables from MySQL. This is useful if you want to do automatic backup of your database using a cronjob and you for ... [More] any reason do not have access to the mysqldump command. TodoVersion History1.10: (2009-10-28) Support for UTF-8 connections New option to dump AUTO_INCREMENT in table structure when used with older MySQL versions Reports progress information when creating sql file New example of how to use the stream feature Dumps MySQL server version 1.00: (2009-03-13) Based on MySQLDump 2.0 by Daniele Viganò, creativefactory.it Based on Thors code changes in MySQLDump 2.01 at coders4fun.com Uses SHOW CREATE TABLES to get table structures Adds AUTO_INCREMENT in table structures Adds option to format dump file like phpMyAdmin export Adds options to dump DROP TABLE and CREATE TABLE statements Adds options to dump data and expanded INSERT statements Optimized the code for dumping INSERT statements [Less]

I wanted to grab an RSS feed from every city in the USA for the computer gigs postings. Since most of these jobs were telecommute it didn't matter where the job actually was and this allowed me to ... [More] peruse all of craigslist.org with ease. You can use it to track any query you'd like. [Less]

Live Glossary is a web based application, which allows users to view, create and edit a Glossary. It also has an administrative portion from which the administrator can accept or reject additions or ... [More] edits, populate the glossary with delimited data from a csv file and export a pure HTML version of the Glossary. You can check out the main project page at http://www.zwongo.com/projects.php [Less]

mySQLmobiAlly is a small portable PHP application which helps you connect to any MySQL database and modify them using SQL query lines. I made this script a year ago. As I started over my coding, I ... [More] decided to rebuild it. Here is Build2 of mySQLmobiAlly. These are the spacialities: 1. It is a stand alone single-file script. You can put it in any place of your server. 2. Its UI is optimized to be accessed through a cellphone broswer. So you may use it for accessing your database on the fly. 3. It uses SESSION global to store your setup, thus saves airtime cost, unlike build#1. 4. It can execute several SQL lines (seperated by “;”) atonce. So it can be used to import a DB from an .SQL file. 5. For SELECT statements, it can view results in a record-by-record basis. 6. It can create .SQL files, then export and save one table of your DB or the full DB in it. 7. It can even connect to a remote database and copy all its data to your database. 8. In short, it can perform all sorts of DB operations using SQL commands, if your username is assigned with proper permissions. [Less]

This project aims to create an XML standard for web forums data as well as a suite of exporters and importers for common software to allow the transportation of data between installations. The SVN ... [More] trunk is currently considered completely unstable and in some cases there's not even finished code. If you want to take a look at the most recent snapshot of code though, feel free. The download section has some alpha versions of some of the code. Feel free to download it, test it out, and give some feedback. [Less]

Simple class for exporting Python data to PHPUsage example #python code export_data = {'a':[1,2,'text', (1.4,2)], 1:'c'} print PhpExport().export(export, var_name='php_variable')reuslt: ... [More] $php_variable = array("a"=>array(1,2,"text",array(1.4,2,),),1=>"c",); ?> [Less]

.gadget-title { margin-bottom: 2px; } function resizeIframeHandler(opt_height) { var elem = document.getElementById(this.f); if (!elem) return; if (!opt_height) { elem.style.height = ... [More] undefined; } else { opt_height = Math.max(10, opt_height); elem.style.height = opt_height + 'px'; } } gadgets.rpc.register("resize_iframe", resizeIframeHandler); gadgets.rpc.register('set_title', function(title) { var elem = document.getElementById(this.f + '_title'); if (elem) { elem.innerHTML = gadgets.util.escape(title); } }); SummaryGD Star Rating plugin for WordPress allows you to set up rating and review system for pages and/or posts and comment in your blog. Also includes the widgets for displaying votes and rating statistics for all posts and pages with votes. Ohloh users [Less]