[PHP] Noob question: Making search results clickable.
Hi all I'm building a fairly basic php/mySql site but I'm running into problems due to my total lack of experience. I have a database of videos - each has a title, transcript, description and one or more topics. So far I can search the database by topic (using a drop-down menu), like this: "; } ?> Basic, but it works. What I'd like now is to make the search results clickable so clicking them leads to a page showing all the details of that video. I have a page "video_display.php" set up, ready to display the details from the database, but how do I connect the two? Thanks in advance Paul -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] php quiz script/tutorial
I'm considering my options for making quizzes mostly multiple choice type of thing, but also 'filling in the gaps'. This is in support of educational materials I'm working on. So far I've looked at Flash and javascript but have concerns about accessibility for both of these. Does anyone have any experience of writing quizzes with php and if so, can you recommend any resources to get me started? TIA Paul -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] php/mysql/phpMyAdmin on an iBook?
Hi everyone I'm thinking of getting an iBook for reasons not really to do with webbing but really need to do occasional php/mysql stuff to justify the expense. I believe that they all come with an Apache testing server installed and wondered if anyone had any success with getting php/mysql/phpMyAdmin working on one of these machines. Thanks in advance Paul -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Web2.0 style tags - where to start?
Hi I'm working on a project where we're building a collection of videos in Flash and the idea has been mooted that it would improve usability if we were to allow users to tag videos they've seen a la last.fm, flickr youtube etc. It's still very early days and I'm quite interested in putting something together quickly to see if it's really the way we want to go (also because it might be useful for other projects). Does anyone know of any good resources on building a tagging system? The video for now will be held on a normal LAMP machine as will everything else. TIA Paul -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Web2.0 style tags - where to start?
On Mon, July 28, 2008 2:04 pm, Richard Heyes wrote: >> I'm working on a project where we're building a collection of videos in >> Flash and the idea has been mooted that it would improve usability if we >> were to allow users to tag videos they've seen a la last.fm, flickr >> youtube etc. > > If you're thinking of trying re-invent a UI - my advice would be > don't. Your visitors are more likely to know and understand their own > PCs UI as opposed to one that you invent. Any UI you come up with is > not going to be as easily used no matter how good it is. > > -- > Richard Heyes > http://www.phpguru.org > Hi Richard I think my first post was ambiguous. What we're thinking of is to build a site on which people can view videos with the option to add metadata to a video after viewing it. We think that the content we have will be of wide interest to a lot of people and the best way to index it is for users to 'tag' it themselves, since it's hard for us to anticipate the uses that people may have for the content. Last.fm allows users to tag bands and songs for example; here's the tag page for Joy Division: http://www.last.fm/music/Joy+Division/+tags The idea being that if you're interested in post-punk, for example, you can click on that tag and be taken to the pages of similarly genred bands. So it encourages use of the content and serendipitous connections (maybe). I'm not convinced that this is the way to go, but I'd like to pilot the idea and am looking for signposts for where to start. Paul Ps. I was wrong about youtube, by the way, it doesn't look like they do tagging. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Web2.0 style tags - where to start?
Jason Norwood-Young wrote: On Mon, 2008-07-28 at 14:48 +0100, Paul Jinks wrote: I think my first post was ambiguous. What we're thinking of is to build a site on which people can view videos with the option to add metadata to a video after viewing it. We think that the content we have will be of wide interest to a lot of people and the best way to index it is for users to 'tag' it themselves, since it's hard for us to anticipate the uses that people may have for the content. How do you plan to have users enter the info? Through the Flash player, through some kinda Ajax form, through a form in a frame or just a static form? Also, would the tags be predefined by you (eg. genres like the ID3 tag genres) or would people be able to add their own tags? The way I'd do it would be to let the users enter the info through an Ajax form below the video, with suggestions popping up as they type. Then save it in a separate table (I assume all your vids are in their own table) with a link table between the vids table and the tags table (M2M relationship). This means that if the tag is already in there and linked to one vid, you don't replicate it for a second vid. It's also very easy to do lookups of similar items. I'd also add a weighting to the tags in the links table, maybe with the more people that add a specific tag, the more weight that tag gets. Also check out http://www.music-map.com/ as an example of showing similar music - you might even be able to plug into this data. Hi Jason Hmm, food for thought. music-map is brilliant, though not what I'm looking for graphically at the moment (was surprised to find Cesaria Evora in close proximity to The Cardigans but I digress). What you describe is pretty much what I'm chasing, thanks and helps me down the road, particularly with thinking about the database set up. They 'only' problem is, my php/mysql skills are some way behind my javascript/actionscript knowhow (I'm pretty much a noob here); what I could use now is a how-to tutorial to give me some code to work off, either online or in a book. If it ain't there, I can build from scratch but it's going to mean a lot of calls for help! =) Many thanks Paul -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Web2.0 style tags - where to start?
On Tue, July 29, 2008 9:22 am, Jason Norwood-Young wrote: > > On Mon, 2008-07-28 at 23:57 +0100, Paul Jinks wrote: >> Jason Norwood-Young wrote: >> > On Mon, 2008-07-28 at 14:48 +0100, Paul Jinks wrote: >> > >> >> I think my first post was ambiguous. What we're thinking of is to >> build a >> >> site on which people can view videos with the option to add metadata >> to a >> >> video after viewing it. >> >> >> >> We think that the content we have will be of wide interest to a lot >> of >> >> people and the best way to index it is for users to 'tag' it >> themselves, >> >> since it's hard for us to anticipate the uses that people may have >> for the >> >> content. >> >> >> > >> > How do you plan to have users enter the info? Through the Flash >> player, >> > through some kinda Ajax form, through a form in a frame or just a >> static >> > form? >> > >> > Also, would the tags be predefined by you (eg. genres like the ID3 tag >> > genres) or would people be able to add their own tags? >> > >> > The way I'd do it would be to let the users enter the info through an >> > Ajax form below the video, with suggestions popping up as they type. >> > Then save it in a separate table (I assume all your vids are in their >> > own table) with a link table between the vids table and the tags table >> > (M2M relationship). This means that if the tag is already in there and >> > linked to one vid, you don't replicate it for a second vid. It's also >> > very easy to do lookups of similar items. I'd also add a weighting to >> > the tags in the links table, maybe with the more people that add a >> > specific tag, the more weight that tag gets. >> > >> > Also check out http://www.music-map.com/ as an example of showing >> > similar music - you might even be able to plug into this data. >> > >> > >> Hi Jason >> >> Hmm, food for thought. music-map is brilliant, though not what I'm >> looking for graphically at the moment (was surprised to find Cesaria >> Evora in close proximity to The Cardigans but I digress). >> >> What you describe is pretty much what I'm chasing, thanks and helps me >> down the road, particularly with thinking about the database set up. >> They 'only' problem is, my php/mysql skills are some way behind my >> javascript/actionscript knowhow (I'm pretty much a noob here); what I >> could use now is a how-to tutorial to give me some code to work off, >> either online or in a book. If it ain't there, I can build from scratch >> but it's going to mean a lot of calls for help! =) >> >> Many thanks >> >> Paul > > In that case, I suggest the following solution: > 1. Download the unternet into your puter > 2. Open the file called mysql.com > 3. Read and learn > 4. Open the file called php.net > 5. Read and learn > 6. Rinse and repeat > LOL > In all seriousness, this is a nice, simple project to learn on. You want > to look at different types of relationships in Sql (one-to-one, > one-to-many and many-to-many) and learn a bit about basic DB > architecture; make some tables and play with getting data in and out > (get PHPMyAdmin to help you out); maybe use a nice simple framework like > CodeIgniter to get you kick-started on the PHP. > Right, from scratch it is then (installs xampp, starts up PSPad, and cancels all meetings)... =) Cheers Paul -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP/MySql noob falls at first hurdle
Hi all I've been asked to put simple database interactivity on an academic site. They want users to enter a few details of their projects so other researchers can search and compare funding etc. How difficult can that be, I thought I've built the database in MySQL and entered some dummy data, and I'm now trying in the first place to get the data to display with a simple select query to display the variable "projTitle" from the table "project" thus: Result of When I view the page I get this: Result of SELECT projTitle FROM project There are indeed 4 entries in the database, but I can't figure out why it's not displaying the data. It worked fine on my "PHP/Mysql-in-a-box" course. No, we didn't study the syntax :( Any help gratefully received. Thanks Paul -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: PHP/MySql noob falls at first hurdle
Brice wrote: Try to check the key of your result row with a print_r or a var_dump command. Brice Favre http://pelmel.org/ Like this? Apologies if this is pathetically wrong. Like I said, I'm a total noob. The above returned no data or errors, by the way. Thanks Paul -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP/MySQL noob rides again.. into trouble
Hi all, I have a site where users can search study projects. I'd like to be able to clicks on a project title which passes a variable to this page, which then displays all the data on that project in a table. Cool - and to a noob like me, actually pretty exciting. Except it doesn't work. I get a "couldn't set value of result" message - see end of code. The page displayed all the projects fine when I messed up passing them from the previous page, so the problem is presumably in the first SQL query. Any suggestions? TIA Paul -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP/MySQL noob rides again.. into trouble
David Grant wrote: $SQLQuery = "SELECT * FROM project WHERE projTitle = '" . $HTTP_GET_VARS['projTitle'] . "'"; Yep, that fixed it. Thanks. I had a feeling there was a mix up with the "s and 's. What's with the . s? Not sure why you've got the or die() there. I had the idea that you could put an or die() after any command and it would tell you that it had screwed up at that point. Bad idea? Many thanks Paul -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP/MySQL noob rides again.. into trouble
Richard Davey wrote: ($HTTP_GET_VARS), because lots do not. I would suggest replacing $HTTP_GET_VARS with $_GET (in all instances), because the long format will eventually vanish and your script will cease to work. Cheers Rich, will sort this out. I assume you removed the MySQL details to post to the mailing list, otherwise that won't help too much ;) Erm, even I'm not that daft! =) Rich -- http://www.corephp.co.uk PHP Development Services -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP/MySQL noob rides again.. into trouble
Richard Davey wrote: There are various issues re: SQL injection and lack of filtering going on here, but perhaps not best to dwell on those -just yet-, as long as you are aware that your script is lacking in all forms of security? Then you can address that once you've got it working. Hi Richard Think I've got everything more or less working now and need to look at security issues. Thanks for the tip about SQL injection - had no idea what this was, but googling it proved very interesting - scary stuff! Could you direct me towards any good resources on general security with php/mysql? Thanks again Paul. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
