ranking Sort Sort   |   date Sort Sort   |   member Sort Sort
Syndication

« Previous 1 2 3 Next »
2
Date Submitted Thu. Nov. 18th, 2010 2:22 PM
Revision 1
Beginner slim_IT_TN
Tags Class | DB | mysql | PHP
Comments 0 comments
PHP Mysql DB Class Test 1
1
Date Submitted Wed. Nov. 12th, 2008 9:57 AM
Revision 1
Beginner nostromo
Tags mysql
Comments 0 comments
Cuando concatenamos varios campos con CONCAT( Campo1, Campo2,... ) si algún valor es NULL no se realiza la concatenación, para concater campos (aunque algunos tengan NULL) usaremos COALESCE que devuelve el primer valor que no sea null de la lista.
Asi le pasaremos una listca con el nombre del campo seguido de "", si el campo estava lleno, devuelve el campo, si es null devuelve el segundo, es decir ""
1
Date Submitted Mon. Oct. 13th, 2008 11:10 PM
Revision 1
Beginner jmardones
Tags mysql
Comments 0 comments
this snippet show how to set up passwords in a mysql console.
5
Date Submitted Wed. Aug. 13th, 2008 11:34 PM
Revision 1
Scripter Fordiman
Tags easy | mysql | PHP
Comments 0 comments
My previous entry on an easy to use SQLite interface for XUL/JS got me thinking: how many times have I had to write functions that were just wrappers for a little SQL?

Below is the fruits of that little query (excuse the pun). Forgive the dbXXX functions; my implementation depended on a small portion of a larger mysql library that I've grown accustomed to coding with.
7
Date Submitted Wed. Oct. 3rd, 2007 8:23 PM
Revision 1
Helper explode
Tags mysql | PHP | Time | tracking
Comments 1 comments
Well after searching the internet for something similar to this, I didn't come up with anything...so I made my own! This simple script will track your members' time spent on your website. Please feel free to give comments/suggestions/feedback.
7
Date Submitted Tue. Sep. 4th, 2007 11:34 PM
Revision 1
Helper explode
Tags excel | mysql | PHP | query
Comments 1 comments
This is a cool function that lets you save MySQL query data to an Excel spreadsheet. This is good for taking a backup or if you want to change a lot of information fast, then re-upload it.

I will use the config.php and class.mysql.php files from MySQL DB Class with Extras, so please look at those also.
7
Date Submitted Tue. Sep. 4th, 2007 11:27 PM
Revision 1
Helper explode
Tags mysql | PHP | query
Comments 2 comments
This is a little function that you can use to print out results of a query. It will dynamicly generate the table for you (like phpMyAdmin). This is a nice little checker that is fast. It beats logging into phpMyAdmin and typing in your query there.

I will use the config.php and class.mysql.php files from MySQL DB Class with Extras, so please look at those also.
7
Date Submitted Tue. Sep. 4th, 2007 3:05 PM
Revision 1
Helper explode
Tags Class | mysql | PHP
Comments 0 comments
This is my MySQL database class that I use for all of my sites. Some included features are:
- Get execution time
- Error reporting (screen and email)
- SQL stats
7
Date Submitted Tue. Sep. 4th, 2007 2:13 PM
Revision 1
Helper explode
Tags mysql | PHP
Comments 0 comments
I made this script to delete any unneeded files from the server that weren't being used by the database. Of course you can expand this a lot more, but I cut it down a little to put it up here.
8
Date Submitted Sun. May. 20th, 2007 4:51 AM
Revision 1
Scripter SecondV
Tags "mysql class" | Database | mysql | SQL
Comments 0 comments
This class is a MySQL database access wrapper. It can:

- Connect to a MySQL server
- Execute SQL queries and retrieve single value results or return result rows into arrays
- Return the last inserted table row identifier, the number of result rows and the number of affected rows
- Count the number of executed queries
- Lock and unlock tables
- Escape text literal values or like patterns
- Retrieve database access errors
« Previous 1 2 3 Next »