wwwsqldesigner short review


Download from
Very easy installation: you need a webserver running, unpack
wwwsqldesigner it in a folder, setup your virtual host (I use
personal domain for my pc), all done!


There is a small tool bar to the right, very simple and intuitive to
use, it is grouped in 4 areas:

Simplepie and CodeIgniter

yes, found:
and tried with php 5.3 installation ... simply do not work

I recalled there was a problem in simplepie for assign new by reference, just downloaded newer code from ... still same problem.


{syntaxhighlighter brush:bash}
sed 's/=&\ new/=\ new/' > Simplepie.php

jquery Form Hint plugin (mine)

This is my view of form hint plugin: show a div over with the title content inside, instead of replace text in input elements and match it with placeholder
simply run $(selector).formHint() on all form element and title is used as hint

See also

shuffle db table order

simple code to shuffle a table ... with php shuffle:

$result = $mysql->query("SELECT id FROM $table ORDER BY id");
$rows = $result->num_rows;
$order = shuffle(range(1,$rows));
while($row=$result->fetch_row()) {
  $mysql->query("UPDATE $table SET rand_sort=$num WHERE id=".$row[0]);

with MySQL RAND():

Ajax frontend for my backoffice in jQuery and PHP

This is my way to organize php for a simple jQuery frontend ajax based: a administration page include the php that generate html for each box
2.for each box setup behavior in Javascript
3.let each php manage POST request (for change/update) and GET request for show content

So in admin.php we could have something like that

innerHTML problem with internet explorer (supposed)

I lost some time to debug this


The problem is on Internet Explorer (all version) that refuse to load data in #target, using $.get and innerHTML(data) do not help. The problem is with no well formed html! Internet Explorer refuse to load in dom a malformed html.

Email from your host you are banned (mail php security matter)

I found this in a server:

$header = "From: <".$_REQUEST['email'].">\n";

$_REQUEST['email'] came from a form input ...

Here $_REQUEST['email'] should be, at least, stripped by all \n no matter on how you trust to js code..

$from = $_REQUEST['email'];
$from = str_replace("\n","",$from);
$header = "From: <$from>\n";