Date: 10/14/05 (PHP Community)    Keywords: php, database

I have a form that allows users (based primarily in the former Soviet Union) to submit proposals, uploads the proposals to a database, and is then supposed to inform me when said proposal is uploaded, using PHP's mail() function. While it's always put into the database, it doesn't always send the email. I've tested as many variations as I can think to test, but I always get the confirmation email.

I'm at my wits end to figure out why I don't always get a confirmation email. Is there anything I should be checking for or stripping or adding that would make this work more consistently?

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

Date: 10/16/05 (PHP Community)    Keywords: php, database, web

One of the things I'm working on for my family's website is a photo album. It displays 15 thumbnails in a 3x5 table and then has links at the bottom to further pages (something I'll figure out later). The part with the thumbnails is what I'm trying to figure out right now. My current query pulls just the image url, the date, and the photoid from the database and prints each into a cell. I want to have the thumbnail linked so that it pulls up the full image, the date, the event, and a few other tidbits of information. The url for this new page would be photoalbum.php?id=324 or something like that and would have a new query where all information associated with that particular photoid is printed to the page. However, I've never dealt with passing parameters through a URL string before, and I haven't been able to find a good explanation of it, either online or in my books. What are the general guidelines for using the URL to pass parameters through a query?

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

Date: 10/17/05 (PHP Community)    Keywords: php, database, security

Im having some trouble writing a thumbnail view for a gallery script ive been working on. Now I have a nice little admin section which allows you to add pictures. It even makes the thumbnails for you. The problem occurs when I want to show these thumbnails. I would like to have a table maybe something like below

gallery title

image 1	image 2	image 3	image 4	image 5
image 6	image 7	image 8	image 9	image 10
image 11	image 12	image 13	image 14	image 15
image 16	image 17	image 18	image 19	image 20
image 21	image 22	image 23	image 24	image 25

page < 1 | 2 | 3 | 4 | 5 | 6 >

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

Date: 10/17/05 (Web Development)    Keywords: css, html, database, asp, web

I'm going freakin' insane here, and it is (of course) because of the different ways IE and Firefox display HTML and CSS.

Here is my site:

http://www.shifuimam.com/site.zip

I can't post links to it, because the only Windows web server I have access to is from my university, and it's password-protected.

There are three pages in that archive, plus all the includes and whatnot to make them display properly. browse.asp displays fine in IE and Firefox. faq.asp and category.asp, however, shift the content of the page down a bit for no explicable reason. I thought it was because of the tables on those two pages, but when I added a table to another page that was working fine, it displayed without any problems.

Any help would be greatly, greatly appreciated.

Oh - the databases are also included so all the stuff displays correctly. I know some of you might tell me to not use Access, and I normally wouldn't, but my teacher in this class requested we use Access databases so that he could see our database structure more easily.

Thanks in advance for any help provided!!

x-posted between webdesign and webdev

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

Date: 10/17/05 (WebDesign)    Keywords: css, html, database, asp, web

I'm going freakin' insane here, and it is (of course) because of the different ways IE and Firefox display HTML and CSS.

Here is my site:

http://www.shifuimam.com/site.zip

I can't post links to it, because the only Windows web server I have access to is from my university, and it's password-protected.

There are three pages in that archive, plus all the includes and whatnot to make them display properly. browse.asp displays fine in IE and Firefox. faq.asp and category.asp, however, shift the content of the page down a bit for no explicable reason. I thought it was because of the tables on those two pages, but when I added a table to another page that was working fine, it displayed without any problems.

Any help would be greatly, greatly appreciated.

Oh - the databases are also included so all the stuff displays correctly. I know some of you might tell me to not use Access, and I normally wouldn't, but my teacher in this class requested we use Access databases so that he could see our database structure more easily.

Thanks in advance for any help provided!!

x-posted between webdesign and webdev

Source: http://www.livejournal.com/community/webdesign/998198.html

Date: 10/19/05 (Apache)    Keywords: php, database, web, google, apache

Ok, i am a little new to apache, so go easy on me.

I have an database based website that uses id's to call each page e.g http://www.somesite.co.uk/index.php?id=1

now this i all very nice, but i find that url a little long for me, so i would like to be able to make it into something like http://www.somesite.co.uk/1

now i know this would have implications like if i wanted to sent to a folder past the root, like http://www.somesite.co.uk/images/1.jpg so it would have to have exceptions setup to.

now i have been told that this can be done with a mod_rewrite, but i have spend days pouring over documentation, google hits etc and i have yet to manage to do this. is there anyone out there who has a any clue's?

Thanks for any help

Source: http://www.livejournal.com/community/apache/26263.html

Date: 10/19/05 (MySQL Communtiy)    Keywords: php, database, web

howdy...

i have a fun one for you. i've written a user-driven database web-programthat uses PHP to create pages on the fly according to variables that draw information from the database. as it stands now, none of the "profile" pages actually exists, they are created via GET method - http://thepage.com/page.php?email=bob@thepage.com

now, what i'd like to do is offer my users the ability to use a static URL for example http://thepage.com/bob instead of http://thepage.com/page.php?email=bob@thepage.com. the first method i tried goes as follows.

i altered the htaccess to redirect all 404 requests to a file containing a script that pulled the last part of the URL "/bob" and used it as a variable to send as GET, thus creating the page. the reason i did this, theoretically it would handle ALL variations of http://thepage.com/bob that anyone could dream up and rely on the database to fill in the blanks. however, i was unable to make this work. i was able to complete the redirect portion by using a fixed redirect URL but i was unable to pull a GET variable from the URL and have it sent to the newly constructed page.

any and all suggestions are very welcome, especially if i am simply wrongheaded in my approach and there is a better, more efficient way to accomplish the same goal. thank you all for yout time and advice. take care.

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

Date: 10/25/05 (Java Web)    Keywords: software, database, java

Java Software - TinyDisk provides a way to store large amount of data anonymously (write once - read multiple times - delete admin only) on the internet. It overlays a write-once-read-many anonymous, persistent and globally shared filesystem. Once something is uploaded, only the database admin can delete it. Everyone can read it. No one can know [...]

Source: http://blog.taragana.com/index.php/archive/how-to-use-tinyurl-to-store-huge-data-online-anonymously/

Date: 10/26/05 (Security)    Keywords: database

Database could help banks avoid hiring financial services employees sacked for leaking consumer data or knowingly causing losses.

Source: http://news.zdnet.com/Banks+to+blacklist+rogue+workers+in+fraud+fight/2100-1009_22-5915678.html?part=rss&tag=feed&subj=zdnn

Date: 10/27/05 (Javascript Community)    Keywords: database

Hello,
I'm working with a terrible product that sees all commas as a new record even though the data is coming from a freaking database and not a CSV file. Because of this, I have to figure out a way to insert commas after the fact. Thing is, I need this to apply to all the forms and thus I'll have no idea of what the form field names will be. Is there an ultra generic way to say

In this form.. if there are ANY instances of || please replace it with ,

So for instance "Bankruptcy|| Finances and Commercial" will turn into "Bankruptcy, Finances and Commercial"

Thanks for any help or suggestions!

Source: http://www.livejournal.com/community/javascript/81087.html

Date: 10/28/05 (Web Development)    Keywords: software, database, web

Background: Web Designer/Business Consultant working on graduate thesis...

In terms of business sytems... (in the larger sense - ie corporate identity, databases, web sites, software, intranet, etc) If a system works and runs as it should, why is the design important? What about design will set apart one system to another? Why is it we "need" design in everyday things we use within business?

X-posted

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

Date: 10/28/05 (Security)    Keywords: database

Mechanism to secure passwords is weak, making it no challenge for an attacker to recover passwords for Oracle database users, experts warn.

Source: http://news.zdnet.com/Oracle+password+system+comes+under+fire/2100-1009_22-5918305.html?part=rss&tag=feed&subj=zdnn

Date: 10/27/05 (PHP Community)    Keywords: php, mysql, database, sql, web

Well guys, I'm truly stumped, and I don't know if you guys can even help me. I've exhausted everything so far, though, so I'm going to try it anyway.

Basically I have this:

$link = mysql_connect("ksg2000.mydomain.edu","user","pass") or die ("Could not connect"); mysql_select_db("IOP") or die("Could not select database");

which should work just fine as all my other statements are written exactly like that (to interface with my web database) and they work just fine.

I get this error, instead:

Warning: mysql_connect(): Lost connection to MySQL server during query in /data/htdocs/world/RegularSites/iop/events_forum_search.php on line 258
Could not connect

The only thing I can think of that would matter would be that it's a SQL database I'm trying to connect to, and not a MySQL, but there is not sql_connect function or anything like that, only ms sql and m sql... can someone give me some advice on this matter? I'm desperate and under a deadline!

Thanks in adddddddvance!

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

Date: 10/29/05 (WebDesign)    Keywords: php, mysql, database, sql

I want to enter in the locations of each of the LJ Icons I make in a MYSQL database...then have them displayed in rows using PHP....and just a note...I have Dreamweaver MX 2004 but can only get them going down in a column.

Any ideas?

Source: http://www.livejournal.com/community/webdesign/1005594.html

Date: 10/30/05 (PHP Community)    Keywords: cms, php, mysql, html, database, sql

I have come across a problem that is driving me mad. I have a php and MySQL CMS and I have a page that extracts the age content (html) out and plops it into the template file and all is sent back to the user. I have now come to the point when I would like to stop some php amongst the body html that is stored for each id in the database. The problem is how to have it recognised as php and then run.

So at the moment, I just extract the in from the database and copy it into a field: $body=$row['body'];

This is then in turn put in the template. I would however like to have this code run and then the result (so the html, plus whatever else has been generated in the middle) is then copied into a field ready for insertion into the template.

Does anyone know of a way to do this? I have seen ways that are meant to have worked, but as yet have not, but I don’t want to note them down as they may cloud people’s ideas.

Thanks for any help.

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

Date: 11/01/05 (WebDesign)    Keywords: php, database, java, web, apache

Hey, I may not have said this, or I don't say it enough, but I wanted to thank everyone in this community for their continued support and efforts. I would be the first to admit that when I find myself with any questions or in need of an honest (most of the time) professional opinion, this is where I tend to stop first.



I work for a higher education provider who has recently put a new state wide internet campaign together. This meant that all regions throughout the state came together and had to adhere to a standard format for all web publications. To me, this was a great move, however, we are still very limited to the type of tools we can utilize for creating web documents. For example, right now we are needing to publish our college bookstore book list online. The bookstore is currently using a very large and extensive Access database to handle all bookstore events. Each semester, or when a new book is added/deleted/edited to the book list, we publish an excel version of this book list and push that to our website, as is. We are now finding that this method is difficult to track, manage and keep current. It's a waste of time, really.

Here's what they are asking me, if we are able to update the database and have it also update the web at the same time?

Well my answer was yes, then no, and here's why.

Our network group has restricted all scripting except for Javascript and CGI/Perl. I'm pretty sure we are running Apache on a Unix box, with nothing like PHP installed. I really don't think Javascript could be used for this, however, I don't know it enough to really make anything happen. The same goes for me when it comes to CGI/Perl.

I do, however, know that I could accomplish this utilizing the Access database and PHP. Somethings I do know. But since I don't have the tools available to me that I know best, what other options could I use? Any suggestions?

Source: http://www.livejournal.com/community/webdesign/1008804.html

Date: 11/01/05 (Security)    Keywords: database

Proof-of-concept pest is believed to be the first to target Oracle databases.

Source: http://news.zdnet.com/Halloween+treat+for+Oracle%3A+A+database+worm/2100-1009_22-5926641.html?part=rss&tag=feed&subj=zdnn

Date: 11/02/05 (Web Development)    Keywords: php, mysql, software, html, technology, database, sql, security, apache

This is a follow up to the post I made before regarding this database connection problem I'm having. (http://www.livejournal.com/community/php/359304.html)

After receiving responses from people that suggested I install the MS SQL PHP functions, I inquired with my IT contact (we are a large institution and therefore have ridiculous amounts of red tape to deal with) as to whether or not they could be installed.

This is what I was told:

We do not support MSSQL odbc connection on our Sun Solaris server running Apache. mssql_connect would require a staff member who knows the technology, purchase of licensed software (which we do not have), and recompiling of Apache that may potentially break other users code. Also, there would be MSSQL security issues if we were to open up or authorize connections to it from our Sun Server, we host a variety of departmental databases on that SQL server, that could be a potentially serious problem if any of our other databases we to be compromised. Sorry for the inconvenience, but that is the story.


If I can't connect to that database, the entire project that I'm working on is going to be fucked and I have a 11/21 deadline. I need to know two things, if any of you can discern from all of this:

1. Is it EVER going to be possible for me to connect to that database? Or should I just stop wasting my time and create another for my personal use?

2. If it is possible, can someone tell me how? :(

Thanks everyone.

Cross posted to PHP/MySQL communities.

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

Date: 11/02/05 (PHP Community)    Keywords: mysql, database, sql, security, spam

for the last few days someone has been testing my various forms to see if they can send 'extra' email headers. stupid spammers...

This got me thinking about ways of 'cleaning up' user input, and I was wondering how other people go about it. I know input validation depends on what exactly the input is (ie guestbook comment would be treated differently to a query string), but in general terms

my current method involves stripping newline characters (\r\n), stripslashes (and then mysql_real_escape_string anything that's going into a database), trim, and strip_tags if need be.
I also have some things that use regular expressions to check/remove any unwanted characters etc. I'm probably missing lots of important things, but I seem to be picking stuff up as I go along, and I'm getting quite paranoid about security, which can't be a bad thing. heh.

Anyone else got a different approach, or any general tips/links?

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

Date: 11/02/05 (PHP Community)    Keywords: php, mysql, software, html, technology, database, sql, security, apache

Edit: Thank you all for your help and suggestions. I had a meeting with my server administrators and have found that it would just be easier to dump and import the data into my own little MySQL database. But I learned a lot in this process thanks to you all!

This is a follow up to the post I made before regarding this database connection problem I'm having. (http://www.livejournal.com/community/php/359304.html)

After receiving responses from people that suggested I install the MS SQL PHP functions, I inquired with my IT contact (we are a large institution and therefore have ridiculous amounts of red tape to deal with) as to whether or not they could be installed.

This is what I was told:

We do not support MSSQL odbc connection on our Sun Solaris server running Apache. mssql_connect would require a staff member who knows the technology, purchase of licensed software (which we do not have), and recompiling of Apache that may potentially break other users code. Also, there would be MSSQL security issues if we were to open up or authorize connections to it from our Sun Server, we host a variety of departmental databases on that SQL server, that could be a potentially serious problem if any of our other databases we to be compromised. Sorry for the inconvenience, but that is the story.


If I can't connect to that database, the entire project that I'm working on is going to be fucked and I have a 11/21 deadline. I need to know two things, if any of you can discern from all of this:

1. Is it EVER going to be possible for me to connect to that database? Or should I just stop wasting my time and create another for my personal use?

2. If it is possible, can someone tell me how? :(

Thanks everyone.

Cross posted to PHP/MySQL communities.

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