Date: 01/09/06     Keywords: cms, php, html, database, security, web

Hey all,

I know there's been a couple posts about this recently, so if I'm asking redundant questions, sorry.

A friend of mine has come up with a pretty novel idea for a MySpace-ish site, but for a specific niche market (kind of like those CatSpace and DogSpaces that exist) - users will have profiles, photos, a blog, message boards, send friend requests, yadda yadda yadda, you've seen it all before. I'm going to be developing the initial setup myself (since we have no money), and this is a somewhat long term project that I'll be picking at casually for a little while.

Right now I'm trying to figure out if I should give this a go coding from scratch, or use an existing CMS type solution (like Mambo, Joomla, Drupal, etc). I'd really like to code it myself, as I think it could be a fun project to work on. I'm a pretty solid PHP programmer, but as I have a feeling that this idea could jump in popularity pretty quick, I really want to make sure I keep this thing as efficient as possible for a large user base. For instance, I don't want to go making another MySpace which I think runs horribly as a web app compared to even LiveJournal.

Currently I use PEAR's DB_DataObject or my database interactions and I've just gotten into Smarty for templating, though I'm sure I'm not using either to their fullest potential. I saw mention of a couple of development environments and frameworks in someone's recent post looking for a visual studio-esque PHP environment - http://www.livejournal.com/community/php/388602.html but I've never used any of these.

I'm not really concerned here with using a "rapid development" framework - I don't mind coding, I like it - but what I'm really concerned with is stability, efficiency and security - I know of course that these also rely heavily on how well I code, and using a good coding environment or framework won't do the coding for me, but there have to be some tools/frameworks/etc out there that pros are using that I just haven't moved onto yet, and I wanted to see what you guys (and gals) are using on some of your bigger projects.


- I know this comes up a bunch, but does anyone else think would it be handy at all for us as a community to maybe organize some of the more useful threads and frequently asked (and answered) questions in the php community at a separate location? Doing just a search on the community doesn't necessarily give you anything about the quality of the responses, and it may even be nice to be able to 'browse' solutions/posts by categories or something; maybe we could have some sort of quality ranking on posts, or some way to identify posts that contain questions that get asked all the time. I don't think this would be too tricky to put together, and I'd be willing to work on it, but I don't know if anyone would even use it?

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

Date: 01/09/06     Keywords: cms, php, html, database, security, web

Hey all,

I know there's been a couple posts about this recently, so if I'm asking redundant questions, sorry.

A friend of mine has come up with a pretty novel idea for a MySpace-ish site, but for a specific niche market (kind of like those CatSpace and DogSpaces that exist) - users will have profiles, photos, a blog, message boards, send friend requests, yadda yadda yadda, you've seen it all before. I'm going to be developing the initial setup myself (since we have no money), and this is a somewhat long term project that I'll be picking at casually for a little while.

Right now I'm trying to figure out if I should give this a go coding from scratch, or use an existing CMS type solution (like Mambo, Joomla, Drupal, etc). I'd really like to code it myself, as I think it could be a fun project to work on. I'm a pretty solid PHP programmer, but as I have a feeling that this idea could jump in popularity pretty quick, I really want to make sure I keep this thing as efficient as possible for a large user base. For instance, I don't want to go making another MySpace which I think runs horribly as a web app compared to even LiveJournal.

Currently I use PEAR's DB_DataObject or my database interactions and I've just gotten into Smarty for templating, though I'm sure I'm not using either to their fullest potential. I saw mention of a couple of development environments and frameworks in someone's recent post looking for a visual studio-esque PHP environment - http://www.livejournal.com/community/php/388602.html but I've never used any of these.

I'm not really concerned here with using a "rapid development" framework - I don't mind coding, I like it - but what I'm really concerned with is stability, efficiency and security - I know of course that these also rely heavily on how well I code, and using a good coding environment or framework won't do the coding for me, but there have to be some tools/frameworks/etc out there that pros are using that I just haven't moved onto yet, and I wanted to see what you guys (and gals) are using on some of your bigger projects.


- I know this comes up a bunch, but does anyone else think would it be handy at all for us as a community to maybe organize some of the more useful threads and frequently asked (and answered) questions in the php community at a separate location? Doing just a search on the community doesn't necessarily give you anything about the quality of the responses, and it may even be nice to be able to 'browse' solutions/posts by categories or something; maybe we could have some sort of quality ranking on posts, or some way to identify posts that contain questions that get asked all the time. I don't think this would be too tricky to put together, and I'd be willing to work on it, but I don't know if anyone would even use it?

Source: http://community.livejournal.com/php/392457.html

Date: 01/09/06     Keywords: php, templates, mysql, css, html, sql, java, spam

I've been hunting all around for a decent photo gallery. There seem to be quite a few different projects, some of which are still active, available. None of them seem to accomplish what I'm looking for, though. I have tested quite a few, but all are lacking. To this end, I thought I'd ask here if anyone has anything similar to what I've been looking for.

Major Features:
Abstracts image URLs - hides the path and filename to prevent direct access
Public/private flags - allows some images to stay hidden
Tags - I'd like to be able to tag the images ala del.icio.us, LJ, Flickr
Does not require gd - auto-thumbnails and watermarks can be disabled
Traverses directories - new images can be dropped in a subfolder or the root image folder and will be picked up automatically
Comments - allows for public (configurable) or private comments, either ties into phpbb or uses some sort of email validation/captcha scheme to reduce spam
EXIF - extracts all image data form the photographs and can display it
Uses simple cacheable CSS/XHTML templates
Does not store images in DB
Uses MySQL or abstraction layer that allows MySQL for comments, tags, etc
Takes reasonable measures to be secure and speedy

Minor Features:
Users can upload images
Temporary/expiring image URLs for sharing
Hotlinking configuration - allow all, deny all, allow specific sites
User-switchable templates
Javascript navigation and image pop-ups optional
Keeps stats on a pre image basis - top keywords, views, etc
All images can be watermarked automatically
Thumbnails may be re-generated automatically
Can assign/rename/describe multiple photos at once

I'm sure there are more details, but that should give a start. The scripts I've found so far are either too simple and don't have many features or too complex and require components and methods of use that I won't be using. There are a few others that store the images in the DB, which is something I'm definately against. I want to be able to FTP a directory of images and know that it will be online and ready to go as soon as the transfer is complete, or that it takes a simple click to do a rescan so they are available.

If I have to, I'll start from scratch... I was just hoping that there would be something available that I have not yet found that could serve as a foundation to build from.

Thanks

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

Date: 01/09/06     Keywords: php, templates, mysql, css, html, sql, java, spam

I've been hunting all around for a decent photo gallery. There seem to be quite a few different projects, some of which are still active, available. None of them seem to accomplish what I'm looking for, though. I have tested quite a few, but all are lacking. To this end, I thought I'd ask here if anyone has anything similar to what I've been looking for.

Major Features:
Abstracts image URLs - hides the path and filename to prevent direct access
Public/private flags - allows some images to stay hidden
Tags - I'd like to be able to tag the images ala del.icio.us, LJ, Flickr
Does not require gd - auto-thumbnails and watermarks can be disabled
Traverses directories - new images can be dropped in a subfolder or the root image folder and will be picked up automatically
Comments - allows for public (configurable) or private comments, either ties into phpbb or uses some sort of email validation/captcha scheme to reduce spam
EXIF - extracts all image data form the photographs and can display it
Uses simple cacheable CSS/XHTML templates
Does not store images in DB
Uses MySQL or abstraction layer that allows MySQL for comments, tags, etc
Takes reasonable measures to be secure and speedy

Minor Features:
Users can upload images
Temporary/expiring image URLs for sharing
Hotlinking configuration - allow all, deny all, allow specific sites
User-switchable templates
Javascript navigation and image pop-ups optional
Keeps stats on a pre image basis - top keywords, views, etc
All images can be watermarked automatically
Thumbnails may be re-generated automatically
Can assign/rename/describe multiple photos at once

I'm sure there are more details, but that should give a start. The scripts I've found so far are either too simple and don't have many features or too complex and require components and methods of use that I won't be using. There are a few others that store the images in the DB, which is something I'm definately against. I want to be able to FTP a directory of images and know that it will be online and ready to go as soon as the transfer is complete, or that it takes a simple click to do a rescan so they are available.

If I have to, I'll start from scratch... I was just hoping that there would be something available that I have not yet found that could serve as a foundation to build from.

Thanks

Source: http://community.livejournal.com/php/392436.html

Date: 01/09/06     Keywords: php

Can anyone recommend a decent or good php framework?

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

Date: 01/09/06     Keywords: php

Can anyone recommend a decent or good php framework?

Source: http://community.livejournal.com/php/391680.html

Date: 01/09/06     Keywords: php, mysql, sql, web

First off, new to this community so I hope this is okay :)

Hello, I tried creating my own php based script... and lets face it that was a mess haha (I had so many errors, it was sad really). I've been looking all over the web (literally, I've emailed 20+ people by now) and no one seems to be able to create this project that I am doing (although, one did reply but they were asking for over $500 which I can't afford :/). Basically I'd like a script created, for a project I was hoping on opening a month ago (that went well eh?). Of course I can pay, but I don't have too much money but I'm sure something could be worked out. If interested a discription of what I'd like done (or something similar) will be in the cut below. Thanks in advance, if more detail is require that is fine.


I am creating a project for my up-and-coming forum (despair.nu) where when members join they can take
part in different projects. Project will be like that of xposure.nu (might still be down, sorry)

The project that I need some help on, is creating a php/mysql script where when members join this project they are then approved by having a certain type of link placed on their site. Then a few days a week members are sent random emails containing the user ID, user site address, and user site name and then they must comment on the 3 sites they are sent. Would also like to have it where the emails also contain the comments that the members are supposed to recieve. Also wouldn't mind having some sort of report system, so if someone doesn't comment they can report the member and then member will recieve some sort of warning.Thanks for your time. I was also curious as to 1) How much this project would cost (if you can do it)? and 2) What payment methods you accept (i.e. paypal etc)?.
Thanks for your time


Thanks for those who have read this, that's at least something in my opinion (as cheesy as it sounds). Comment here if interested, or email works as well. Thanks again. Or if someone could point me in the direction of either, learning how to do it myself (which I doubt but, hey call it wishful thinking) or of someone who could possibly do it.

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

Date: 01/09/06     Keywords: php, web

I'm a programmer that usually codes in ruby or python not php so I'm all of you will be so kind as to help me find the php equivalents I'm looking for. Right now I need to send some http request. Python has urllib and urllib2 for these.

Basically, I need to retrieve a webpage with a php script. Something like $page = retrieve('http://livejournal.com') but i need more control. I need to be able to specify the http headers and such. Anyone know the php functions for this sort of thing? I know of the raw socket functions but I'm hoping for a more abstract method.

Side note, the docs on php.net are great if you know the function your looking for but not so great if you don't know the names of what your looking for :(

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

Date: 01/09/06     Keywords: php, google, apache

Im having a horrible experience upgrading php from 4.4.1 to 5.0.5. Im on a lamp server and its got apache 1.3 running on it, every time i try to upgrade php, "BAM!", httpd fails and i have to revert back to 4.4.1. I havnt a clue on how to fix this problem and i can't seem to find anything on google about it. If you have any ideas please help!

Thanks in advance!

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

Date: 01/06/06     Keywords: php, software, shopping

The only way I can think to accurately describe what I want, is to compare it to ColdFusion, so please bear with me for a second here...

In ColdFusion, there is a "session expiration" option. I can track users (i.e. if User A is logged in, maintain their shopping cart, etc), via server side session variables for however many minutes I specify in this option. It's a setting in the ColdFusion server software that I edit via the Administrator.

Is there a similar option for PHP apps? And if so, where is the setting?

Thanks.

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

Date: 01/06/06     Keywords: php, mysql, html, sql, web

So what is the best way to serve documents (DOC PDF Images, other…) from a location outside of your public html directory?

I thought about using mysql and the LONGBLOB attribute.

But surely there must be a way to simply store the files and use php to retrieve them????
(I’ve done more web searching than I care to admit)

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

Date: 01/05/06     Keywords: php, xml

I haven't really used php in a while and I seem to be a little rusty. Let's say the following request is sent to my php page. How to I access the xml in my php script?

POST /myScript.php
Content-Type: text/xml
Content-Length: 557
User-Agent: myClient
Host: www.lalala.ca


... a bunch of xml here ...

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

Date: 01/05/06     Keywords: mysql, database, sql, web

Okay, stumped.

if ($_GET['id'] == "") { $link = mysql_connect("localhost","iop","iopweb") or die ("Could not connect"); mysql_select_db("iop") or die("Could not select database"); $select_string = "SELECT `id`,`name` FROM internships WHERE `approved` != \"yes\" ORDER BY `post_date` DESC"; $result = mysql_query($select_string); while ($current = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "<a href=\"internships_edit.php?id=" . $current['id'] . "\">" . $current['name'] . "</a><br />"; } //end of first clause of get_id if statement } else { echo $_GET['id'] . "<br /><br />"; $query_id = $_GET['id']; echo $query_id; $select_string_specific = "SELECT * FROM internships WHERE `approved` != \"yes\" AND `id` = " . $query_id . " ORDER BY `id` DESC"; echo $select_string . "<br />"; $result_spec = mysql_query($select_string_specific); // Print out the information while ($current = mysql_fetch_array($result_spec, MYSQL_ASSOC)) { echo "<td><b>ID</b>: <input type=\"text\" name=\"this_id\" value=\"" . $current['id'] . "\"/><br /><b>Name:</b> <input type=\"text\" name=\"this_name\" value=\"" . $current['name'] . "\"/><br /><b>Post Date:</b> " . $current['post_date'] . "<br /><b>Title:</b> " . $current['title'] . "<br /><b>Deadline:</b> " . $current['deadline'] . "<br /><b>Description:</b> " . $current['description'] . "<br /><b>Application Requirements:</b> " . $current['app_requirements'] . "<br /><b>City:</b> " . $current['city'] . "<br /><b>Contact Name:</b> " . $current['contact_name'] . "<br /><b>Contact Address:</b> " . $current['contact_address'] . "<br /><b>Contact Email:</b> " . $current['contact_email'] . "<br /><b>Contact Phone:</b> " . $current['phone'] . "<br /><b>Contact Fax:</b> " . $current['fax'] . "<br /><b>URL:</b> " . $current['url'] . "<br /><b>Link to Application:</b> " . $current['app_link'] . "<br /><b>Job yes/no:</b> " . $current['job'] . "<br /> <b>State:</b> " . $current['state'] . "<br /><form action=\"internships_approve.php\" method=\"post\"><input type=\"hidden\" name=\"approved\" value=\"yes\"> <input type=\"hidden\" name=\"submitted\" value=\"yes\"><input type=\"hidden\" value=" . $current['id'] . " name=\"id\"><input type=\"submit\" value=\"Click to Approve\"></form></td>"; } }

Everything works fine until the else portion is reached. At that point, the query that is echoed works just fine if I paste it into my MySQL db, but it acts like an asshole here, apparently, because I get the old "not a valid resource" error message that we all live for. It should only be selecting one record, the one with the corresponding ID number (there are no duplicate IDs) and then displaying the information associated with that ID number after obtaining the ID number from the url as a $_GET. (I know there's some unnecessary variable re-setting in here - I was trying anything I could.)

I can't figure this out. It's something so simple, I bet, and that's why I'm not seeing it because I've been swearing at it for over 30 minutes now.

Any help is appreciated.

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

Date: 01/05/06     Keywords: php, mysql, sql

I've tried several variations of code.
(even direct copy from several sites)

But I can't seem to delete a table from my php file.
(works great from directy sql in phpmyadmin)

Here is the code I am working with (connection already made to db)

Any ideas? Thanks!

-----

$tblname = "tablename";

$result = @mysql_query("DROP TABLE '$tblname'");
if (!$result)
{
echo ("Error--Unable to Delete Table. Try Again Later");
exit;
}

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

Date: 01/04/06     Keywords: php, web

I'm looking to add PayPal's subscription service to a current project/website, with a secure login service in order to access the content. I was wondering if someone would be interested on working on the project with me, dealing with the coding/PHP for said subscription service. The bulk of the site is already in place, and I just need to add the subscription service in order to complete the site. I'm an artist, not a coder, and much of the implementation of the php/subscription code is beyond my technical expertise! If you're interested, give me a shout/comment.

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

Date: 01/04/06     Keywords: no keywords

Hey guys, can anyone suggest me a cool script for random quotes?
As easy as possible please, with no extra-stuff like categories or something
Thnx :)

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

Date: 01/04/06     Keywords: php, asp

Hi,

Is there any PHP GUI available for development? like Windows guys use ASP .NET? or Visual Basic or Qt Designer for KDE people?

If not, anybody interested in developing such thing?

X-Posted to php_dev

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

Date: 01/03/06     Keywords: mysql, database, sql

While trying to connect to the mysql database, I get this error:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
So I look up the solutions for this error. I discover that I need to edit a my.cnf file and change the socket setting. I wish it was that easy. I check what socket is set too.

[client]
#password = my_password
port = 3306
socket = /opt/local/var/run/mysqld/mysqld.sock

Not the socket the server is trying to connect to.

The file is located in /opt/local/etc/mysql4 and I also copied it to /opt/local/etc incase.
The password and username is correct, I can manually connect to the database.
Using a Mac OSX.4 server.
DB Server version is 4.1.15
Connection: Localhost via UNIX socket

I am out of ideas, can anyone help me?

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

Date: 01/02/06     Keywords: no keywords

What, if anything, do you use for unit testing?

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

Date: 01/02/06     Keywords: php, web

I know php isn't made for this but is anyone using a chat interface on their website that is worth looking at? I prefer it be php5 compatible.

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