Date: 02/15/05 (Web Technology)    Keywords: web

Web site operators and corporations are playing game of I spy, you spy with covert cloaking trick.

Source: http://news.zdnet.com/Hide+and+seek+on+the+Web/2100-9588_22-5573181.html?part=rss&tag=feed&subj=zdnn

Date: 02/16/05 (Web Technology)    Keywords: web

Fresh version of toolbar that lets people search the Web from static box on IE means "less cutting and pasting," company says.

Source: http://news.zdnet.com/Google+soups+up+search+toolbar/2100-9588_22-5579078.html?part=rss&tag=feed&subj=zdnn

Date: 02/16/05 (Web Technology)    Keywords: web, google

The search giant's AdWords program is coming to the Web sites of Billboard, Hollywood Reporter and other VNU publications.
Images: Google's maps to go

Source: http://news.zdnet.com/Google%2C+VNU+in+targeted+ad+deal/2100-9588_22-5578976.html?part=rss&tag=feed&subj=zdnn

Date: 02/16/05 (Java Web)    Keywords: database, web

It is a very strong capability to be able to post dynamic content in your blog. You can use this to integrate contents from other websites, fetch data from your database etc. It enables whole plethora of functionalities to your blog posting to make it more lively.

Source: http://feeds.feedburner.com/AngsumansBlogOnJavaAndWebTechnologies?m=153

Date: 02/17/05 (Web Technology)    Keywords: web, google

They're used in everything from Google searches to Web tax filings. But standards struggle is rattling W3C and confounding developers.

Source: http://news.zdnet.com/Fight+over+%27forms%27+clouds+future+of+Net+applications/2100-9588_22-5581106.html?part=rss&tag=feed&subj=zdnn

Date: 02/14/05 (PHP Community)    Keywords: php, mysql, css, html, sql, web

I've been working with PHP for several years now in a web-based envoronment and have achieved a moderate level of proficiency - I'm still a little green when it comes to PHP and MySQL though.

Additionally, I'm fluent in XHTML and CSS (though a little out of date with my CSS hacks).

Source: http://www.livejournal.com/community/php/259798.html

Date: 02/09/05 (PHP Community)    Keywords: php, mysql, sql, web

I'm working on creating some tools (PHP/MySQL) on one of my websites to help a user tell where things are. Generically, I will probably put this to use in several ways at some point - I just need a bit of help to start with. The budget is $0, so there will be no buying of commercial map data.

Scenario:
1) User A inputs location data - say, for SSO, it's a store that sells ShadowRun books. This information includes address, city, state, zip, country, phone, etc.
2) User B is going on a trip to Town Z, and wants to know which of these locations are nearby, so they input address Y and a radius of M miles.
3) The display shows a map of town Z with a radius of M miles centered around addess Y, and a numer N of locations X are indicated with icons on the map. Along with this, there is a table with a list of N locations and a distance between Y and X for each.
*) I would also like to be able to create a state-wide or regional default map to show as a default.

Work In Progress:
What I have been able to do so far, thanks to some links I found, is to use the old US Census Zip data that is floating around to give an approximate distance based on zip code. This is pretty inaccurate at best, but it does at least give some idea.

What I think the next step is would be to find a way to get a more accurate lat/long for each address, and use the zip only as a fallback if that method fails. This would increase the accuracy by a significant amount. Any ideas on where/how to implement such a thing would be welcome.

The big step would be actually mapping into an image. I have looked around quite a bit for information on creating images and maps, but have yet to find anything that I can relate well enough to to work with. I'm looking for an example not too far from this scenario to work from. I magine a basic way to accomplish this task would be to find a state outline map and the lat/long that equate with each corner, then use those as a base to map the icon points... somehow. That would at least be a place to start from, and could probably be done with freely available data. To actually generate M radius maps from address Y would be a bit trickier, I imagine. Any thoughts as to the methods, code, sites, data, or experience in creating such a thing are welcome.

Thanks.

Source: http://www.livejournal.com/community/php/257428.html

Date: 02/08/05 (PHP Community)    Keywords: database, web

OK, I'm trying to write a script that tells you when your next recycling collection is (don't laugh). In my city, your recycling is collected on a certain day (the actual day depends where exactly you live) every two weeks.

What I'd like to do is have a web page with a list of street names and the date of your next collection, which is generated based on the current date (using time() ). I'm running into a bit of trouble generating the next collection day because it's once a fortnight and I can't just (for example) increment the current time() until I get to the right day because it could be more than a week away.

At the moment I've got all the street names in a database with a timestamp of a known collection. Then I just increment the "known collection" timestamp by two weeks until the value exceeds time().

What I'd like to know is - is there an easier way to do this? I figure once the script has been up and running for a while it's a bit silly to start at a date that was years ago and increment it until it passes the current date.

UPDATE: Sorted it (maybe). I don't have server access to set up a cron job, but I can kind of achieve the same effect by querying and updating the database in the script before outputting the values. Cheers! :) You can see the script in action here (woooo).

Source: http://www.livejournal.com/community/php/256785.html

Date: 02/07/05 (PHP Community)    Keywords: php, html, database, web

I'm doing something of a small content management system for a project I'm working on, and had a quick question about stripping html tags from database held text.

I plan on having a "news" section, updated via a web form or phpMyAdmin or something, but I would like the full news entries safe for HTML tags (bolding, italics, email links, etc). Additionally, I would like to display small 100-character or so blurbs of the "news" entries on other pages - my concern is that if a tag is opened before the 100-character cut-off and not closed, this will mess with the following code.

I've dabbled in solving this problem with little effort, and equally little success. Is there an easy way of stripping out HTML tags for a preview such as this? Am I better off not allowing HTML and providing my own tags, such as ::BOLD::here's some bold text::BOLD:: ? If this is the case, how do I prevent HTML tags at all?

Source: http://www.livejournal.com/community/php/256244.html

Date: 02/19/05 (Web Technology)    Keywords: web

Adding hyperlinks where there weren't any before is like hijacking a Web site, some critics say.

Source: http://news.zdnet.com/Google+landgrab+raises+online+ire/2100-9588_22-5582792.html?part=rss&tag=feed&subj=zdnn

Date: 02/20/05 (PHP Community)    Keywords: php, java, web

Hi there. I think this may be a bigger question than really admits of an answer in this forum, but I'll give it a shot anyway.

I'm working on a website in which I'd like to include the option to vote on pages, or leave comments. Thus far I've figured out that this involves forms and cookies, but I'm having all kinds of trouble. It's been months since I've done any sort of coding, and my PHP skills were never good anyway.

So say we have some text links that point to a javascript function, that updates a hidden form with the value input (say, a vote from 1 to 10) and submits the form. can the form submit itself to the same script? -- could a form on view.php have a form action that points to view.php?

how do I set up cookies that won't expire and thus have values overwritten the next time a given user comes and wants to vote, but that will also not allow multiple votes on the same things from the same user?

lots of questions. I've looked around online and gotten swamped. Maybe someone could just recommend a good book on PHP...

thanks-
Damon

Source: http://www.livejournal.com/community/php/263326.html

Date: 02/19/05 (Web Technology)    Keywords: web

Adding hyperlinks where there weren't any before is like hijacking a Web site, some critics say.

Source: http://news.zdnet.com/Google+toolbar+move+raises+online+ire/2100-9588_22-5582792.html?part=rss&tag=feed&subj=zdnn

Date: 02/21/05 (PHP Community)    Keywords: browser, web

Hello all! I'm new to this community, and I've encountered an extremely frustrating problem.

I recently set up an Invision Power Board forum at one of my websites. Everything is working fine -- except my users (and myself) cannot stay logged in. Even after checking the "keep me logged in" box, if you close the browser or even surf to another site and come back, you are suddenly not logged in.

I've been through the admin panel over and over, and everything appears to be configured correctly. I know this must be a cookie problem, but I can't figure out what could be causing it, and my users are getting very irritated with it.

Any help at all would be so greatly appreciated! Thanks in advance!

Source: http://www.livejournal.com/community/php/264825.html

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

For a website, I have to write a suite of scripts interacting with a database of bibliographic references. Some pages will have an embedded request for a set of the latest titles by an author, and some pages will have an embedded list of titles from which to generate full references. Additionally, I have to build a simple search engine that will query by author, title, publication or abstract.

The search engine is a later problem, and I've already got searching for an embedded list of titles working. So right now I have to solve the author problem. I'm a MySQL newbie and am having problems with the following dilemma:

The problem with citations is that there's no fixed number of authors for a book. As a consequence, the database has a table for the papers, a table for the authors, and a link table with columns for a paper's foreign key and author's foreign key. A paper with three authors populates three rows of the link table.

My challenge is that to pull a complete citation when I search by author, I currently have to make two database queries:
SELECT name, id_people, papers_fk FROM papers pa, link li, people pe WHERE name LIKE 'Smith' AND pa.id_paper=li.papers_fk AND pe.id_people=li.people_fk
pulls the IDs of papers that Smith has contributed to.

I take that list of IDs and loop through
SELECT name, id_people, title, id_paper FROM papers pa, link li, people pe WHERE li.papers_fk='$titleid' AND pa.id_paper='$titleid' AND pe.id_people=li.people_fk
entering a different paper ID into $titleid on each loop to generate arrays of citations. A script will distill the arrays into comma-separated lists of authors and format the results.

My question is: Is there a way to distill this into a single query? Which is to say: Can I use a single query to get the complete list of authors for each title that Smith has contributed to?

The approach I have now will work, even if it ends up sending a lot of queries for each web page hit, but being able to streamline this query will both make this page more efficient and give me a leg up on writing the full text (citation + abstract) search section.

Source: http://www.livejournal.com/community/mysql/47657.html

Date: 12/23/04 (MySQL Communtiy)    Keywords: mysql, sql, web

I upgraded my server today to 4.1.8, both MySQL and MySQL Max. I had to force it as there was a conflict with the client tools. My question is, where are all the client tools? I looked for upgrades on the MyS!QL site and couldn't find them.

Also, any reason why WebMin would still report the old version number?

Source: http://www.livejournal.com/community/mysql/44609.html

Date: 02/20/05 (Web Development)    Keywords: database, web, hosting

I'm trying to find a good webhost that supports InnoDB and allows adult content. I found oxxus.net, whose database hosting starts at $9.99 and includes InnoDB support. I'm wondering if anybody has had any bad experiences with them, or knows of somewhere I can read user reviews of them.

Thanks.

Source: http://www.livejournal.com/community/webdev/173911.html

Date: 02/17/05 (Web Development)    Keywords: php, html, web

Well, I got the OK, so here goes:





As someone who's never been an IT insider, I only have knowledge of *how* to do things, not how to get paid to do them. Almost everything I know I've taught myself, from HTML 3 way back in the day to PHP 5 over the past year. My only concept of what it's like to work in this field is based on my experience in my last job. So what's out there? I know that web design and web development are often considered separate fields, but is this always the case? What are the positions like? Should I go back and get a degree? If so, what kind? If not, what do I need to impress potential employers? I'm more interested in design than development at the moment, but I like both and would be happy doing either full-time... really, any information you can provide would be helpful at this point!


(cross-posted to webdesign)

Source: http://www.livejournal.com/community/webdev/172586.html

Date: 02/17/05 (Web Development)    Keywords: web

Hello folks, new here. Thought I'd take a jump and see if I can learn something new or at least keep up in my field other than reading mags and surfing. Haven't been in a web developer or designer community ever. Been in the web development/design for 6 years. Currently webmaster of two web sites, one which is my day job (a newspaper web site), the other my night job (an art gallery). People hit on me for small web site jobs.

So...Hi! :D

Source: http://www.livejournal.com/community/webdev/172350.html

Date: 02/17/05 (Web Development)    Keywords: web

Just taking a moment to introduce myself: I'm a twenty-something American with a Psychology degree who wound up doing web development and found out he loved it. Problem is last Friday I just got laid off ("It's not you employees, it's us, we're broke") and now as I think about it I don't know a lot about this field I've come to love after my first exposure to it. Is it inappropriate here to ask for information about the industry? I've got a million questions to ask...

Source: http://www.livejournal.com/community/webdev/172071.html

Date: 02/08/05 (Web Development)    Keywords: php, programming, mysql, database, asp, sql, jsp, web

Ok, I've got a question for all the professionals out there. I've been looking for a while now to get into server-side web programming (PHP, ASP, JSP, SQL) for a little while now. While I do have experience working with these things working on personal projects, I have no professional experience. I was wondering if anyone had any suggestions on what I can do to more effectively represent myself in this way.

In terms of skills, I'm talking a heavy PHP/MySQL background, with a focus on content managers and database served content.

Just hoping someone might have some pointers. Feel free to ask me any questions.

Source: http://www.livejournal.com/community/webdev/170943.html