john ackers

There’s no special support for images.

It looks as if database images could be introduced into the HTML inline if you send to the browser encoded in base64. You should be able to create those encodings from jpegs using string base64_encode ( string $data ) in a PHP snippet. But you could quickly get into performance issues.

Do you mean hyperlinks in a column in the database – in which case yes. You just use a PHP snippet in a column to wrap the link in that column with the associated text (in another database column) with a pair A tags. There are hyperlinks in the example snippets that navigate wp_post etc. But will post an simple example if you need one.

John

The syntax looks right. Can you post up the line from the access log that shows the (ajax) page request, I just want to make sure that the request to the server is correct. You are looking for something like this:
GET /wp3/wp-admin/admin-ajax.php action=dbview&verb=autoLoad&name=show+all+options&pageSize=19 HTTP/1.1

thanks john

Not completely sure what you want to do. I am guessing you want to filter/select on specific user meta data. You can create a new view that includes a query that joins wp_users and wp_user_meta and select the desired rows.

Thanks. Points noted. It’s very helpful to see context. The top row doesn’t look right but I think you should be able to use CSS to right align ‘1 item’, reduce it size etc. You can set pagesize as shortcut argument. Dimensions can be set with CSS.

I think i understand what you want to do. It would not be easy to feed the value of a text box into the query!

Perhaps in a future version I should add an optional query or all column search box.

Sorry this is a slow reply. What functionality are you looking for?

I’m actually interested in doing something similar for google fusion tables which I find increasingly useful. But I don’t want/like to use iframes to embed tables into pages. If anyone knows of a plugin that does that, I’d love to know.

Sorry I haven’t added this. I will do it on next release but not sure when.

Change pagination by adding pagesize=xx to the shortcode e.g. [dbview name=addressBook pagesize=20] as per plugin home page. Sorry this is a bit late.

Richard

I cannot see ‘show user’ but that doesn’t matter.

Those supplied queries were a bit of an afterthought. Some of the queries expect parameters and they are passed from one query to another as a GET parameter arg1, arg2 etc.

If you look at the PHP snippet in the first column in ‘show ten users’, you can see
DBView::linkToView("[show posts by user $value]","show posts by user", $value);
which passes $value (which happens to be the user ID) as as argument to another view ‘show posts by user’. Hope this makes sense. Unfortunately those SQL statements with arguments aren’t handled properly when you edit and execute them – something i need to fix.

You can only use query parameters in the admin/dashboard pages. Have a look at this.

Orphaned PHP snippet error is generated when you modify a query and remove a column name to which you have attached a PHP snippet. It’s just a warning.

Sorry the help is a bit limited.

You are right, it doesn’t work! Looks like there’s no support for passing arguments to embedded views on public pages. But it can probably be tweaked. When do you need this?

%s and %d refer to strings and decimal digits, I think you should be using “WHERE Country=%s” not “WHERE Country=%d” . I think the mismatch nonce value error message is correct but it’s probably misleading us. Will try to recreate it tomorrow.

Thank goodness for that because I would have been struggling to merge and test today. Thanks for doing this great work.

slevit,

i have added you as a contributor on the plugin admin page.

Apologies for not coming back to this in the two days. Thanks for your patience. It would be great if you put your changes in a branch as you suggest. I will merge into trunk and test, most likely on Monday (or later if better for you). If I cannot do this, I’ll let you know in case you want to do this yourself.

I’ll be look out for emails with any problems you might encounter. Have fun.

John

Thanks for feedback. Won’t be able to get to this for a couple of days. But will fix.

Thanks for feedback. Won’t be able to get to this for a couple of days. But will fix.