Date: 06/04/07 (Web Development)    Keywords: php, templates, mysql, html, xml, database, sql, web

xml.lt has announced the release of DIY Framework. It is an open–source web application framework based on MVC architecture, object–oriented PHP 5, MySQL, and XSLT.

The Model is database–backed and generated by Propel ORM tool, the Controller is inspired by REST and RDF, and the View is based on XSLT stylesheets as templates.

The framework allows clean and precise sever–side development with a fully object–oriented code, absolutely no mixing of PHP, (X)HTML and/or SQL code, resources that have nice meaningful URIs with no extra effort, and many other features. On the other hand, it is tiny, flexible, and not overloaded with buzzword things.

Blog post (digg!):
http://www.xml.lt/Blog/2007/06/04/DIY+Framework+v0.1+released

More information and download:
http://www.xml.lt/Resources/Framework

Martynas

Source: http://community.livejournal.com/webdev/411944.html

Date: 06/05/07 (HTML Help)    Keywords: mysql, sql

Hi!

Does anybody know where I can find simple user-friendly Guest-book scripts, that I can edit easily?

And what is "CGI" and "MySQL"?

Thank you in advanced.

Source: http://community.livejournal.com/htmlhelp/2401202.html

Date: 06/08/07 (MySQL Communtiy)    Keywords: php, mysql, sql, web, apache

I have what is probably an easy question, but I've been Googling and don't quite know where to go.

I write and test MySQL queries on a virtual Apache server on my PC before transferring it to the live server on a website. At the moment, I write the MySQL through a command-line interface, which makes it very difficult (almost impossible) to go back and edit the query if I need to change things or have made mistakes. It seems to take much longer to develop things than it should!

At work, I use Teradata SQL and we have a nice graphical interface where we can type in SQL, edit it easily, save SQL to re-use and all those good things. It's much easier to develop in and also easier to copy and paste the query into other files, such as Excel or PHP.

Can anyone recommend a good equivalent program for MySQL?

Source: http://community.livejournal.com/mysql/114511.html

Date: 06/10/07 (Webmaster View)    Keywords: php, mysql, software, browser, html, database, sql, linux, apache

Last month,I did a clean install of Ubuntu Feisty Fawn on my home computer removing the "dapper drake". But it is only now, I got a chance to sit down and install all necessary packages to set up my development server again.

With Dapper Drake, I had to use alien to convert MySQL5 rpm to .deb, because there was no version 5 in the repositories. Anyway, Feisty has all newest versions of software.

This is what I did for setting up my development server:

For installing MySQL server I ran the command: sudo apt-get install mysql-server. Then I installed the following:

MySQL Administrator: It is a Graphical User Interface for administrating MySQL: sudo apt-get install mysql-admin

MySQL Query Browser is a GUI for managing databases: sudo apt-get install mysql-query-browser

Apache: sudo apt-get install apache2

Apache Manual: sudo apt-get install apache2-doc

PHP: sudo apt-get install php5

PHP module for Apache: sudo apt-get install libapache2-mod-php5

Enabling public_html directories for users

Well, I am the only user in my computer. But I can create and edit files without running sudo if I have a public_html directory at my home. sudo a2enmod userdir. I then restarted Apache and created a 'public_html' directory in my home. Now I can access it with http://localhost/~username/.

Enable mod_rewrite

1. sudo a2enmod rewrite.
2. Edit Apache configuration: sudo gedit /etc/apache2/sites-available/default
3. Change line 12: “AllowOverride none” to “AllowOverride all”
4. save and close
5. Restart Apache

(Thanks to mod_rewrite for Apache2 in Ubuntu Feisty Fawn 7.04)

How to restart Apache?

sudo /etc/init.d/apache2 force-reload.

Todo:

1. Install IEs4Linux.
2. Install Opera.
3. Install Komodo Edit.
4. Install gftp.

Source: http://www.webmasterview.com/server_side/development_server_on_ubuntu_desktop

Date: 06/11/07 (Open Source)    Keywords: mysql, sql

Booking.com says it's processing "tens of thousands" of reservations a day, but more important that it's growing exponentially. Yet they commited to mySQL. Not Oracle, not DB2, not SQL Server, and not Ingres. Now it's always possible these people are out of their minds, or just enamored of freeware, but I doubt it.

Source: http://feeds.feedburner.com/~r/zdnet/open-source/~3/123917232/

Date: 06/12/07 (Java Web)    Keywords: mysql, sql

ANALYZE TABLE analyzes and stores the key distribution for a table. The MySQL query optimizer is the magic inside MySQL that decides which keys, if any, to use to in the query. ANALYZE helps query optimizer to make accurate decisions by detailed analysis of the data, unlike query optimizer which makes quick analysis. The command [...]

Source: http://blog.taragana.com/index.php/archive/how-to-quickly-analyze-all-tables-in-mysql-database/

Date: 06/13/07 (MySQL Communtiy)    Keywords: mysql, sql

I have a query that worked fine against the MySQL 4.0.x binaries, but when I perform the same query on a 5.0.x install I have a problem. I'm using a query with a GROUP_CONCAT clause to put the results into a single field. This is a section of the query, just to show how I'm using it:

GROUP_CONCAT( DISTINCT album ORDER BY album SEPARATOR '||' ) AS album_list

The problem is that it seems to truncate all results at exactly 341 characters. Again, on 4.x it worked fine, but something changed in 5.x that now limits the size of the returned dataset. I read something about group_concat_max_len and a MySQL bug with utf8 columns (all of my tables are utf8). Has anyone come across this problem or a solution? How does one set the group_concat_max_len variable--is that an SQL command or a DB startup parameter?

Source: http://community.livejournal.com/mysql/114840.html

Date: 06/24/07 (MySQL Communtiy)    Keywords: mysql, sql

Does anybody has an experience with japanese language with mySQL?
my client asked to implement "two bite kanji". What should I set in mySQL in order to get it work?
Thanks,
Roman

Source: http://community.livejournal.com/mysql/115333.html

Date: 07/02/07 (MySQL Communtiy)    Keywords: mysql, sql

I'm beyond rusty on my MySQL, and I don't have my book handy (I'm at work, it's not). I'm plugging along working on this little program and I run into this little quandry. I'm positive it's an exceptionally easy question, but sometimes (especially with me) the easiest questions are the ones that I just have no flipping clue on.

So...would this be a legal SELECT statement in MySQL?

SELECT this_value FROM table_a AND this_other_value FROM table_b WHERE `this` = `that`;

I'd upload it to the server and test it out, but I haven't bothered to put any data up yet. I'm just trying to get this down before I forget.

Source: http://community.livejournal.com/mysql/116029.html

Date: 07/08/07 (MySQL Communtiy)    Keywords: programming, mysql, sql

Short info:
Is there a way to use a * operator in a query like so:

`SELECT newSrc.*, oldSrc.* FROM current_raw_table newSrc LEFT JOIN yesterday_raw_table oldSrc ON(newSrc.id = oldSrc.id) WHERE newSrc.* != oldSrc.*);`

to use mysql to compare two tables of data created by a `load data infile` where one table is today's and the other is yesterday. My tests with using *'s failed so plan B is to use my l33t programming skillz to generate a bunch of
`if(newSrc.{fieldName} != oldSrc.{fieldName},"fieldName") as "{fieldName}",` then wrap the whole mess with concat_ws(' ',...);

but before I use said l33t skelz, I figured it might be smart to ask before I reinvent something else.

Source: http://community.livejournal.com/mysql/116735.html

Date: 07/08/07 (MySQL Communtiy)    Keywords: mysql, database, sql

Quick question to see if anyone has a better way.

I have 3 development environments: Workstation at work, my laptop, and the workstation at home... my code is moved between all these machines with svn and it works perfectly, so it makes me wish I could do the same with development schema's or whole Databases.

Is there anything like svn for Databases? I know about and use replication, but that's a tad too much just to allow me to work from a coffee shop or catch up on some work on the weekends. Right now I have a fetchSchema.bat file for my windows machines that grabs the current schema/data from the dev server using mysqldump.

Which reminds me of another question for another post.

Source: http://community.livejournal.com/mysql/116466.html

Date: 07/08/07 (PHP Community)    Keywords: php, mysql, html, database, sql

I'm sorry to disturb, I'm new in php and I have a trouble with this code:


    mysql_connect($host,$utente,$passwd) or die("Connessione non riuscita: " . mysql_error());
    mysql_select_db("news") or die("Selezione del database non riuscita");
    $np = "SELECT * FROM persona";
    if($riga = mysql_fetch_array($np,MYSQL_ASSOC)) {                        
                                echo "" . $riga["Nome"] . " - " . $riga["Cognome"] . " - " . $riga["Organizzazione"];
                                selected ($riga["id_persona"]);
                                    echo "";
                                  }
    while($riga = mysql_fetch_array($np,MYSQL_ASSOC)) {                        
                                echo "" . $riga["Nome"] . " - " . $riga["Cognome"] . " - " . $riga["Organizzazione"];
                                    echo "";
                                  }
?>
 

It has to extract a row from a mysql database and make a html select of the value id_persona displaying also the value of the other fields (Nome, Cognome, Organizzazione) but it don't works properly. Choices on select are displayed like in the attached photo instead with the correct data .

Source: http://community.livejournal.com/php/575883.html

Date: 07/10/07 (Web Development)    Keywords: php, mysql, browser, html, database, sql

Ok, so I have a fully UTF-8 MySQL database with a fully UTF-8 table. I have a php page which has "" at the top of the html section and "mysql_set_charset("utf8");" after my connection (it's php 2.2.3, so that's more or less the same as "mysql_query("SET NAMES 'utf8'");).  I have all my php.ini mbstring stuff configured for utf-8:

mbstring.language = Neutral
mbstring.internal_encoding = UTF-8
mbstring.http_input = auto
mbstring.encoding_translation = On
mbstring.detect_order = auto

and for what it's worth, echo mb_internal_encoding(); reports "UTF-8".

when I run a query that pulls out (in this case, Japanese, but say any) UTF8 data, it displays properly in MySQL Query Browser.  With php in the above context however, it does not.  Instead, it prints a ? corresponding to each character.  When I use mb_detect_encoding(); on each such string, it tells me they are encoded as ASCII.  The nearest I can tell is that somewhere between using mysql_query() and mysql_fetch_row(), things got messed up.  Is this a bug?  Is there something I'm missing?  Any clues? Help!

Source: http://community.livejournal.com/webdev/420578.html

Date: 07/13/07 (Java Web)    Keywords: php, mysql, sql, web

This is a very interesting presentation (see below) on the technologies used to make Digg, the challenges faced along the way and how they overcame it. I would recommend it to any Web 2.0 startup architects. In short Digg uses multiple MySQL slaves with a single master, multiple load balanced PHP servers which connects to random [...]

Source: http://blog.taragana.com/index.php/archive/digg-technologies-used-challenges-faced/

Date: 07/17/07 (PHP Community)    Keywords: php, mysql, sql, web

hey everyone,
i have a website: http://thebigone.homeip.net with a form for users to put either 'chat' or news for the site.
my question is: when someone tries posting in either of the text boxes and hits enter to create a new line the php doesn't pick up on this when it posts to the mysql backend. how do i keep the formatting of the textbox for the actual site?

Source: http://community.livejournal.com/php/576562.html

Date: 07/18/07 (PHP Community)    Keywords: php, mysql, database, sql

I have a chronic problem with a fanfiction archive script I made. Since I've put it online, I hit max_user_connections in MySql very often, and my host is losing patience. The script opens a mySql connection (originally a normal one, now a permanent one by my host's suggestion) on loading and should use it for all the mysql calls forward. The archive is famous in the fandom and gets a lot of hits, but this shouldn't happen. I've tried to reduce the mysql calls at minimum, but I only get a few days reprieve. This is the code I use:

In db_layer.php:

Source: http://community.livejournal.com/php/576875.html

Date: 07/20/07 (Java Web)    Keywords: mysql, sql

What is auto reconnect in MySQL? The MySQL client library can perform an automatic reconnect to the server if it finds that the connection is down when you attempt to send a statement to the server to be executed. In this case, the library tries once to reconnect to the server and send the statement again. [...]

Source: http://blog.taragana.com/index.php/archive/how-to-enable-disable-auto-reconnect-in-mysql/

Date: 07/25/07 (Java Web)    Keywords: php, mysql, software, sql

A much dreaded MySQL error message during queries is “MySQL server has gone away”. An alternative message is “Lost connection to server during query”. This is a strange problem which afflicts a wide variety of PHP software including but not limited to WordPress. There are several causes for it. Let’s look at the common and [...]

Source: http://blog.taragana.com/index.php/archive/mysql-tip-mysql-server-has-gone-away-or-lost-connection-to-server-during-query-fix/

Date: 07/26/07 (Open Source)    Keywords: mysql, sql, postgresql

The PostgreSQL take on this is people date mySQL, but enterprises marry PostgreSQL.

Source: http://feeds.feedburner.com/~r/zdnet/open-source/~3/137602580/

Date: 07/30/07 (MySQL Communtiy)    Keywords: mysql, sql

I have a table with 341K records. When I query for all records with a certain string that have occurred in the in the last 24 hours, it returns in .66 seconds. When I sort that same query by any field, it returns in 3 minutes. Any thoughts on how to optimize this query for sorting?

mysql> describe eventlog_data ;
+----------+---------------+------+-----+---------------------+-------+
| Field    | Type          | Null | Key | Default             | Extra |
+----------+---------------+------+-----+---------------------+-------+
| host     | int(11)       | NO   | MUL | 0                   |       |
| event    | int(11)       | NO   |     | 0                   |       |
| record   | bigint(20)    | NO   |     | 0                   |       |
| cname    | varchar(255)  | NO   |     |                     |       |
| time     | datetime      | NO   |     | 0000-00-00 00:00:00 |       |
| type     | varchar(16)   | NO   |     |                     |       |
| log      | varchar(16)   | NO   |     |                     |       |
| source   | varchar(128)  | NO   |     |                     |       |
| message  | text          | NO   |     |                     |       |
| notified | enum('y','n') | NO   |     | n                   |       |
+----------+---------------+------+-----+---------------------+-------+
10 rows in set (0.02 sec)

mysql> select count(record) from eventlog_Data ;
+---------------+
| count(record) |
+---------------+
|        341414 |
+---------------+
1 row in set (0.00 sec)

mysql> SELECT cname, time, event, log
    -> FROM   eventlog_data
    -> WHERE  time > SUBDATE(NOW(), INTERVAL 1 DAY)
    -> AND    eventlog_data.message LIKE '%adm%';
SOME DATA RETURNED
16 rows in set (0.66 sec)

mysql> SELECT cname, time, event, log
    -> FROM   eventlog_data
    -> WHERE  time > SUBDATE(NOW(), INTERVAL 1 DAY)
    -> AND    eventlog_data.message LIKE '%adm%';
    -> ORDER BY 1
SOME DATA RETURNED
16 rows in set (2 min 53.63 sec)

Source: http://community.livejournal.com/mysql/116972.html