PHP Forum

I'm trying to build a good DB Layer on top of Pear::DB Are there any forums or knowledge base sites on this direct topic ? I've been using the documentation at: http://pear.php.net/package/DB/docs But since I'm not always online, is there a way I can download this ? Or if the documentation is derived from the classes, How can I build...

I'm trying to build a good DB Layer on top of Pear::DB Are there any forums or knowledge base sites on this direct topic ? I've been using the documentation at: http://pear.php.net/package/DB/docs But since I'm not always online, is there a way I can download this ? Or if the documentation is derived from the classes, How can I build...

Hey, I have a 'staff' table with a column 'status', corresponding to a 'statuses' table with the appropriate titles (eg 1 | Editor in Chief). I want to display on the page the headings (the titles from statuses) along with all of the staff members with that status ID. I've attempted this using a query for each possible status, which I...

Hi i'm trying to write a piece of code which writes the message on screen "access denied" telling the user he can't access this page without logging in and then offering a hyperlink to the login page. Like this: if ($queryrows) { echo("Welcome to the birthdays page"); }

Hi all, I want to use SQLite databases to my site. But the hosting company's server does not support SQLite extension. Is there any way to use SQLite DB's to my site? PS: safe mode is off, php version is 4.3.4 Thanks

Hello, I am trying to set up a page that will show a random image of something on a web page (e.g. cats) taken from a random Google Image. I can't find any sample code to do this. Can someone point me to an example? Thanks!

Lo group, During my quest for the "perfect" way for storing tree-structures it quickly became clear that all of the available SQL-solutions have their own peculiar weaknesses (scalability, slow querying, dangerous inserts, etc). This makes me wonder if storing a tree-structure in LDAP would be a realistic alternative? Scaling probably...

I have developed this simple script that display a banner amond others in a random way. Here is the page http://www.teachingonline.it/articoli.php?IdArticolo=55 Francesco

Hello, I am using php 4.2.2 in Red Hat 9.0 with apache 2.0.40 I try to build a php script that accepts POST requests that contain multimedia data and shoves them in a MySQL database. My problem is that it seems that I cannot read the POST data from stdin. I created the following php script to test it: <?php

Hi guyz, I am developing a website using php.This website involves dealing with forms which span over multiple pages. I want data obtained from 1 form to be available after 3-4 pages. This can be ofcourse achieved through use of cookies.But i am keeping cookies as last option as they r not supposed to be reliable.I want to achieve the...

If I only escape the characters that mysql_real_escape_string recognizes, is this adequate protection against SQL injection attacks? I have read a number of archived posts plus I've read some of the info at php.net. I am still not convinced as to what to do. The php folks claim that using mysql_real_escape_string is all that is needed. Then...

I don't if that's possible... that's why I ask. In my homepage www.coaster.ch I show photos from beercoasters with their respective codes. At present, those who want to exchange with me, have to write the codes in a mail. I want to make it possible that other collectors can select the coasters (by clicking on it, for example) and something...

The following is from http://php.mirrors.ilisys.com.au/manual/en/security.database.sql-injection.php . Would someone explain the following lines, in particular I don't understand '$paramArr' nor do I understand how the syntax {1} works or how it is related to arrays? Thanks, mIke. <some code snipped>

I have a book which had code that includes the line: require 'DB.php'; I know that this is from the PEAR code modules, but when I downloaded them and unpacked the directory, they "DB.php" module does not exist. Is this out of date or do I need to go somewhere else to get this extra module? Thanks

I am trying to program a upload system. The following code work very fine, $file_name = $_FILES; $size = filesize($file_name); $type = mime_content_type($file_name); However, when I change to

I am reading this correctly, because it doesnt seem to match up. I downloaded the zip archive for php5 and Win32. I am trying to enable php_xml.dll? in the extensions, but the dll isnt there and of course I get the error, xmldoc does not exist. What am I missing? As of this date, latest php5 version zip from the php site for Win32. ...

Hi guys, I made a site that you all can critize (you have carte blanche :)) http://thereference.webhop.org I do appreciate postive feedback though. Cheers, Tom Pester

Hello, PHP and MySql Thanks to everyone for help on questions I've posted here. Here's another.... Imagine I have a table containing details of pageviews on a website. To keep the example simple this table has a colum called 'Date' and imagine that the earliest date in there is 01/01/04 (01 Jan 04) and each

extension=php_exif.dll when I uncomment this apache will not start - what is wrong? I already uncommented mbstring.dll and restarted apached w/no problem. using win2k php5 thanks

After running my PHP/MySQL application, I have found that the associated .MYD and .MYI files remain locked. Even after the browser is closed, if I try to rename these files, I get the message: Can't rename filename. It is being used by another person or program... These files remain locked until I reboot. I'm running on a Windows XP...

I use php.ini on my site to execute scripts for every page (auto_prepend_file) and also set some spefic settings in it (buffering,auto session start;..) I am starting on the development of a second site that requires its own php.ini How can I do this on a windows system? Cheers, Tom Pester

Some jerk wrote a robot to attack one of my contact forms. Once a day, it hits my form about 10 times in a couple of seconds. It adds email header info into a textarea box as printed below: Content-Type: multipart/mixed; boundary="===============0845246937==" MIME-Version: 1.0 Subject: a7a679bf To: oanhpiuxh@mydomain.com bcc:...

Is there something build into php where {0} or {1} means something? For example, SELECT * FROM table1 WHERE col1 = {0} AND col2 = {1}; Mike

my regular expression knowledge is admittedly amateurish ... I have spent an hour trying to get this to work without any great success, but am in the middle of a big project so I can't waste a day fiddling around to get it to work (although I might have to if someone here can't help). I thought I would throw it out to the group to see if...

Hi there, I've read in a few places that you should *never* store original passwords in a mySQL DB. Now i wonder if you encrypt it (with MD5 ?), how should i create a lost password function, so the pass could be sent to a corresponding e-mail address? Greetings Frizzle.