Posts Tagged ‘mysql’

Aug
16

I’ve not really delved into WordPress Plugins, aside from a couple custom ones here on SecondVersion.com. I’ve been pushed by several people who have been looking for a testimonial WordPress plugin. My idea is for this to be mainly for hosts running a blog or possibly programmers/freelancers.

The features I have now (or are in planning) include:

  • An admin panel, of course. For settings, editing, deleting, or adding testimonials.
  • A submit page for clients to submit a testimonial (considering hooking this into Askimet)
  • The choice of Widgets or a simple php function to display random testimonials on your blog (along with a page to view all testimonials)

What are your thoughts on this? Have any feature suggestions? Plus, I’m always looking for development ideas - maybe another WordPress plugin?

Dec
13

Hey all, been a while since I’ve written a post. I’ve been busy with work and some personal things though.

Today I come to you because… basically, I need development ideas.

What kind of development ideas?

  1. Is there some script or program that you just got to have but you can’t find it? Here’s your chance. The script would be coded in PHP/MySQL, and would be relased as a paid script, so keep that in mind when sending your ideas.
  2. Website ideas. IE: webmaster, tools, etc - anything you can think of.

If I choose your idea, it’s a script, and I develop it; once released, you will get the first copy absolutely free.

Send your ideas to me by using my contact form.

:mrgreen:

Update, 12/16/07
Contact link should work now.

Aug
21

phpMyAdmin released 2.11.0 today, I’d advise everyone to upgrade. Here is their announcement.

The phpMyAdmin Project is proud to announce the immediate availability
of phpMyAdmin 2.11.0, which will probably be the last series supporting
PHP 4.

This version supports creating VIEWs from query results
and can manage triggers, procedures and functions. It also supports
MySQL 5.0.37 query profiling and has an improved interface for servers
hosting thousands of databases and tables.

phpMyAdmin is a web administration tool for MySQL databases, intended to
handle a whole database server as well as a single database. Over the
years, it has become the most popular Web GUI for MySQL.

Improvements
————

+ [import] support handling of DELIMITER to mimic mysql CLI,
thanks to fb1
+ improved PHP 6 compatibility
+ [core] added PMA_fatalError() and made use of it
+ [doc] changed all documentation in config.inc.php
to phpDocumentor style
+ [data] support for CREATE VIEW from query results
+ [gui] dropped css/ folder and moved into root of PMA
+ [l10n] new: Sinhala, Macedonian
+ [export] YAML export (see yaml.org), thanks to Bryce Thornton
+ [upload] moved file upload functionality into own class
+ [upload] make use of cfg['TempDir'] for file uploads
+ [server] improved display of binary logs
+ [data] better error handling in tbl_create.php
+ [routines] from Patch #1649881, thanks to Mike Beck
+ [querywindow] store sql history in session
+ [querywindow] sql history now without db too
+ [querywindow] tweaks in sql history view
+ [export] Native Excel (Spreadsheet_Excel_Writer) improvements,
thanks to Christian Schmidt
+ [doc] requirement of mcrypt on 64-bit, thanks to Isaac Bennetch
+ RFE #1435922 [gui] navigation frame shows listing of databases
when none selected
+ [data] support BIT datatype (under mysqli),
thanks to Christian Schmidt
+ [display] automatic confirmation for sort by key,
thanks to Juergen Wind
+ [data] can now choose the number of insert rows
+ RFE #1704779 [gui] link documentation from login page
+ RFE #1513345 [setup] check control user connection during setup
+ [structure] TRIGGERS: display/edit/drop/SQL export
+ [browse] store browse state in session per query
+ [gui] Insert/Edit: no longer display the Go button each 15 lines
but just at the end of a row
+ [gui] Query window: use verbose server name if any
+ [auth] patch #1712514 specify host for single signon,
thanks to Thierry
+ [gui] Navigator for the db list in the navigation panel
+ [gui] Navigator for the table list in the content panel
+ [display] Support for MySQL 5.0.37 profiling
+ RFE #1743983 [gui] Replace max_characters by a configurable param:
cfg['MaxCharactersInDisplayedSQL']
+ [display] patch #1749705, Allow multibyte characters in number
formatting, thanks to garas
+ [privileges] Support password hashing on the Edit Privileges
interface
+ [gui] Export: Select All/Unselect All over the choices,
thanks to Florian Schmitz

www.phpmyadmin.net

May
25

Hello everyone.

The long and eagerly awaited release of Domain Name Portfolio 0.5.0 is now here; bringing many many new changes.

You can view most of the changes here; and download here.
Have fun!! :smile:

www.domainportfolio.us

Apr
09

Hello everyone!

Many of you who visit my site come for my open source project Domain Name Portfolio. For the past 6 months or so, you all have been waiting on me to release Version 0.5.0.

I have some big news regarding the future of Domain Name Portfolio. It’s home will change, it will soon be DomainPortfolio.us. The site will be completed, and launched, once Version 0.5.0 of the script is ready.

What changes have been made to Domain Name Portfolio so far?

  • Improved the is_valid_email function.
  • Improved the sanitize function.
  • sanitize() function calls cleaned up. There was no need to specify ‘true’ as a 2nd parameter (for stripping \r\n). As it defaults to true.
  • Changed ver_check function to only grab the latest version, not do an actual check against the current & latest versions. Both latest version and currently installed version are shown in admin.
  • clean() on $_POST vars etc removed. The value is now passed to clean() via the sanitize() function.
  • The iif function introduced in 0.4.2 deprecated. No longer used.
  • Removed the ‘img’ folder.
  • Renamed several folders and files:
    ‘inc’ => ‘includes’,
    ‘tpl’ => ‘templates’,
    ‘funcs.php’ => ‘functions.php’,
    ‘funcs_admin.php’ => ‘functions_admin.php’,
    and several others
  • Changed url params for pagination/sort:
    ‘p’ => ‘page’,
    ’s’ => ’sort’
  • ‘atomic’ font replaced with ‘rubbfont’ for captcha.
  • Added ordering of domains in admin..like it is on main index.
  • Added a new database field - ‘issite’. Setting this to yes when adding or editing a domain, will cause it to be linked on the index & search pages.
  • Added a new database field - ‘description’ for both domains and categories. Which will allow you to give a domain or category a description.
  • You can now add domains in bulk!
  • You now have categories!
  • You now have search!
  • Both the ‘blue’ and ‘default’ templates are gone.
  • The editing/deleting of domains/categories share the same files using ‘modes’ (edit.php & delete.php).
  • Optimized code.
  • Added a referer check on POSTs
  • If your server does not support GD, or has freetype, you’ll see this image on the contact form:
  • Revamped Installer
  • Changed table structure of config, and how it is handled
  • Added a custom error handler
  • Improved MySQL Database class
  • All files are now in *nix format, using tabs - no more tabs to spaces (sorry windows users)
  • Improved template class.
  • Code cleanup (Laziness of using the ternary operator mostly; in cases where an if statement would be easier to read/follow).

0.5.0 promises to be the best yet, you all will love it ;)

Stay tuned.

May
22

After a while of trying to keep this project “hush hush” it got out on NamePros a while back. So, I bring to you my latest project, Domain Name Portfolio.

Latest Version: 0.9.0 as of August 21st, 2007

See the changelog for details.

What is it
?

Domain Name Portfolio is a FREE PHP and MySQL based application to help domain owners better organize their portfolio. It allows you to list your domains with their expiry, registrar, price, status, and category. Also allows visitors to your portfolio to contact you about a given domain.

Features (short list):

- List your domains along with a category, registrar, expiry, price, and a status.
- Domains are sortable by domain, category, registrar, expiry, price, or status.
- A quick and convienient contact form is provided for anyone interested in a domain.
- Captcha to help deter spam, and bot emails.
- Secure admin area to add, edit, delete, and set site options.
- Categories
- Domains have their own details page.
- Add domains in bulk.
- Search domains
- Custom template engine.
- Support for MySQL & MySQLi
- Nice clean template.
- Quick and easy installation.
- …and many more!

Requirements

Tested on:

Linux / Apache
PHP 4.3.11 - 4.4.7 & 5.2.x (5.2.4 and later recommended)
MySQL 4.1.21 & 5.0.x (5.0.45 and later recommended)

To use the new captcha feature, you’ll need GD (2.0.35+) w/FreeType(2.3.5+) support.

License

Licensed under the GNU GPL (v2).

What’s new?
You can view changes in the changelog.

Where can I get it?

Project Page: http://www.freshmeat.net/projects/dnport
Home Page: http://www.domainportfolio.us/
Demo: http://www.domainportfolio.us/demo/

This software is considered to be in BETA/Production Stable condition. You may encounter a bug or two. If you have any problems, ideas, or suggestions, post them here, PM me, or contact me at http://www.domainportfolio.us/contact.html

Enjoy!

Feb
01

Hey everyone,

Must say..has been quite some time since I’ve posted here. As usual, things are busy busy busy. Not long ago (about eh, 3 months - when I first got the idea) I started on a project originally called “SVs Domain Portfolio”. It turned out okay I suppose (stopped messing with it after 1 week), never did much with it after that until about 1 1/2 months ago. To keep it short I ended up re-coding the entire thing. And it turned out good, and I’m still working on it. I’ve added to some project places but for now will not give out links. It’s still in the development/Pre-Alpha stage. Once I release a BETA I will let you all know. Stay tuned, it may be sooner than you think ;)

Thanks,

-SV