Re: [PHP] Craig's List Clone part deux
Bumpanyone? On May 31, 2005, at 10:11 AM, Michael O'Neal wrote: Hi...I posted a while back looking for an open-source or affordable Craig's List clone built in PHP, and the advice was to search...there are a ton out there. So far, the only one I've been able to come up with is AJ Classified Pro (http://www.ajsquare.com/ajclassifieds.php) which had some half-hearted reviews, and has a really cheesy website supporting it. So...I'll ask again to see if anyone knows of any others before I plunk down $250 for this semi-ok reviewed software. Does anyone know of a Craig's List type setup out there that is worth trying? Thanks, mto -- Michael O'Neal Head Honcho http://www.WhirledMedia.com [EMAIL PROTECTED] Boulder, Colorado 720.436.2922 IM: AOL-emptyo1 MSN: [EMAIL PROTECTED] Yahoo: bambisapartment -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php mto -- Michael O'Neal Head Honcho http://www.WhirledMedia.com [EMAIL PROTECTED] Boulder, Colorado 720.436.2922 IM: AOL-emptyo1 MSN: [EMAIL PROTECTED] Yahoo: bambisapartment -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Craig's List Clone part deux
Hi...I posted a while back looking for an open-source or affordable Craig's List clone built in PHP, and the advice was to search...there are a ton out there. So far, the only one I've been able to come up with is AJ Classified Pro (http://www.ajsquare.com/ajclassifieds.php) which had some half-hearted reviews, and has a really cheesy website supporting it. So...I'll ask again to see if anyone knows of any others before I plunk down $250 for this semi-ok reviewed software. Does anyone know of a Craig's List type setup out there that is worth trying? Thanks, mto -- Michael O'Neal Head Honcho http://www.WhirledMedia.com [EMAIL PROTECTED] Boulder, Colorado 720.436.2922 IM: AOL-emptyo1 MSN: [EMAIL PROTECTED] Yahoo: bambisapartment -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Craig's List Clone part deux
Thanks John. That's one of the reasons I haven't gone that route. The whole operation seemed cheesy to me. I appreciate the feedback though. On May 31, 2005, at 11:48 AM, John Nichel wrote: Michael O'Neal wrote: Hi...I posted a while back looking for an open-source or affordable Craig's List clone built in PHP, and the advice was to search...there are a ton out there. So far, the only one I've been able to come up with is AJ Classified Pro (http://www.ajsquare.com/ajclassifieds.php) which had some half-hearted reviews, and has a really cheesy website supporting it. So...I'll ask again to see if anyone knows of any others before I plunk down $250 for this semi-ok reviewed software. Does anyone know of a Craig's List type setup out there that is worth trying? I can't help you with finding other software to accomplish this, but I can advise you to steer clear of the AJ Classifieds. I've spent the better part of the last two months doing side work for a company who purchased it, couldn't get the developers to fix the bugs, and can't get them to complete the modifications that they paid for. mto -- Michael O'Neal Head Honcho http://www.WhirledMedia.com [EMAIL PROTECTED] Boulder, Colorado 720.436.2922 IM: AOL-emptyo1 MSN: [EMAIL PROTECTED] Yahoo: bambisapartment -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Craig's List Clone part deux
Anyone else? I have a hard time believing it's not out there...but I could be wrong!!! On May 31, 2005, at 1:48 PM, Michael O'Neal wrote: Thanks John. That's one of the reasons I haven't gone that route. The whole operation seemed cheesy to me. I appreciate the feedback though. On May 31, 2005, at 11:48 AM, John Nichel wrote: Michael O'Neal wrote: Hi...I posted a while back looking for an open-source or affordable Craig's List clone built in PHP, and the advice was to search...there are a ton out there. So far, the only one I've been able to come up with is AJ Classified Pro (http://www.ajsquare.com/ajclassifieds.php) which had some half-hearted reviews, and has a really cheesy website supporting it. So...I'll ask again to see if anyone knows of any others before I plunk down $250 for this semi-ok reviewed software. Does anyone know of a Craig's List type setup out there that is worth trying? I can't help you with finding other software to accomplish this, but I can advise you to steer clear of the AJ Classifieds. I've spent the better part of the last two months doing side work for a company who purchased it, couldn't get the developers to fix the bugs, and can't get them to complete the modifications that they paid for. mto -- Michael O'Neal Head Honcho http://www.WhirledMedia.com [EMAIL PROTECTED] Boulder, Colorado 720.436.2922 IM: AOL-emptyo1 MSN: [EMAIL PROTECTED] Yahoo: bambisapartment -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php mto -- Michael O'Neal Head Honcho http://www.WhirledMedia.com [EMAIL PROTECTED] Boulder, Colorado 720.436.2922 IM: AOL-emptyo1 MSN: [EMAIL PROTECTED] Yahoo: bambisapartment -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Dynamic Dropdown menu question.
Hi.
I'm working on an edit page where the pull down menu is populated from a
database. I can't figure out how to print selected when that particular
record is the one associated with the current ID. Can anyone help?
Here's my current code:
!-- Dynamic Career Menu--
?php
include(common.inc);
$connection = @mysql_connect($db_host,$db_user,$db_pass) or
die(Couldn't Connect.);
$db = @mysql_select_db($db_name, $connection) or die(Couldn't select
database.);
$sql =SELECT job_id,category,description,job_id AS my_job_id FROM
$cat_table_name;
$result = @mysql_query($sql, $connection) or die(Error #. mysql_errno() .
: . mysql_error());
while ($row = mysql_fetch_array($result)) {
$job_id=$row['job_id'];
$category=$row['category'];
$description=$row['description'];
$my_job_id=$row['my_job_id'];
echo option value=\$job_id\ ;
if ($job_id == '$my_job_id') {
echo selected ;
}
echo $title/option;
}
$num = @mysql_num_rows($result);
?
!-- /Dynamic Career Menu--
This is about the 5th iteration of this menu I've been working on. If
anyone has any ideas, please email me at [EMAIL PROTECTED] as I am on the
digest.
Thanks,
mto
--
Michael O'Neal
Web Producer
-
M A N G O
B O U L D E R
-
http://www.thinkmango.com
e- [EMAIL PROTECTED]
p- 303.442.1821
f- 303.938.8507
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] SQL / PHP Join issue.
Hi,
I'm having a little trouble with this join statement I'm working on. What I
*think* is happening is that PHP is getting confused with the ID field
that is the same for the three different tables. When I go through the
result set, you can see that the field ID gets used a couple of times. I
have since tried to change the result set to call out the table as well (as
in calendar.ID, but that didn't work. How can I give each ID field a
unique value to be used in the variables?
Here's my code:
$sql =SELECT calendar.ID,calendar.Calendar_Title,calendar.Add_To_Scroller,
careers.id,careers.title,careers.Add_To_Scroller,
menu_specials.ID,menu_specials.Menu_Description,menu_specials.Add_To_Scrolle
r
FROM calendar,careers,menu_specials
WHERE calendar.Add_To_Scroller = 2
AND careers.Add_To_Scroller = 2
AND menu_specials.Add_To_Scroller = 2;
$result = @mysql_query($sql, $connection) or die(Error #. mysql_errno() .
: . mysql_error());
while ($row = mysql_fetch_array($result)) {
$calendar_ID=$row['ID'];
$calendar_Calendar_Title=$row['Calendar_Title'];
$calendar_Add_To_Scroller=$row['Add_To_Scroller'];
$careers_id=$row['id'];
$careers_title=$row['title'];
$careers_Add_To_Scroller=$row['Add_To_Scroller'];
$menu_specials_ID=$row['ID'];
$menu_specials_Menu_Description=$row['Menu_Description'];
$menu_specials_Add_To_Scroller=$row['Add_To_Scroller'];
$display_block .= Latest News -
$calendar_Calendar_Title|http://skunkworks.thinkmango.com/canyon/calendar/de
tail_action.php?ID=$calendar_ID|_self
Looking for a hot job? -
$careers_title|http://skunkworks.thinkmango.com/scroll/careers/career_detail
.php?id=$careers_id|_self
Great Deals on Great Food! -
$menu_specials_Menu_Description|http://skunkworks.thinkmango.com/scroll/menu
/menu_detail.php?ID=$menu_specials_ID|_self;
}
Thanks in advance!
mto
--
Michael O'Neal
Web Producer
-
M A N G O
B O U L D E R
-
http://www.thinkmango.com
e- [EMAIL PROTECTED]
p- 303.442.1821
f- 303.938.8507
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] SQL / PHP Join issue. - SOLVED
Hi all. Never mind my previous post. I fixed my SQL statements by using AS statements. For example: SELECT calendar.ID AS calendar_ID,calendar.Calendar_Title AS Calendar_Title,calendar.Add_To_Scroller AS calendar_Add_To_Scroller... That worked like I wanted it to. Thanks! mto -- Michael O'Neal Web Producer - M A N G O B O U L D E R - http://www.thinkmango.com e- [EMAIL PROTECTED] p- 303.442.1821 f- 303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Party/RSVP App?
Hi all, I'm looking for a PHP Party Invite/RSVP app. I'd like it to be similar to evite.com. I'm just checking first to see if something exists before I dig into it myself. Thanks, mto -- Michael O'Neal Web Producer - M A N G O B O U L D E R - http://www.thinkmango.com e- [EMAIL PROTECTED] p- 303.442.1821 f- 303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Party/RSVP App?
Hi all, I'm looking for a PHP Party Invite/RSVP app. I'd like it to be similar to evite.com. I'm just checking first to see if something exists before I dig into it myself. Thanks, mto -- Michael O'Neal Web Producer - M A N G O B O U L D E R - http://www.thinkmango.com e- [EMAIL PROTECTED] p- 303.442.1821 f- 303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Trying to subtract...no luck. (Long Code)
= DB_fetch_array($result,$db);
echo PTABLE BORDER=0TRTDProject: A HREF=' . $rootpath .
/gaant.php?ProjectID= . $ProjectID . 'B . $myrow[ProjectName] .
/B/ABRProject Lead: A HREF='mailto:; . $myrow[PlayerEmail] . '
. $myrow[PlayerName] . /AP . $myrow[ProjectDescription] .
/TD/TR/TABLE;
/*Show tasks underway for modification or viewing status*/
$sql = SELECT TaskID, TaskName, DATE_FORMAT(EarliestStart,'%d/%m/%Y') AS
FmtEarliestStart, ExpectedDuration, PlayerName, Status, budget, actual FROM
ProjectTasks, Players WHERE ProjectTasks.TaskChampion=Players.PlayerID AND
ProjectTasks.ProjectID= . $ProjectID;
$result = DB_query($sql, $db);
if (DB_num_rows($result)!=0) {
echo ptable border=\0\ cellpadding=\5\tr
tdBTask/B/td
tdBEarliest Start/B/td
tdBDuration/B/td
tdBProject Lead/B/td
tdBStatus/B/td
tdBBudget/B/td
tdBActual/B/td
tdBDifference/B/td/tr\n\n;
while ($myrow=DB_fetch_array($result)){
$difference = ($budget - $actual);
printf(TRTD%s/TDTD%s/TDTD%s/TDTD%s/TDTD%s/TDTD%s/T
DTD%s/TDTD%s/TDTDA
HREF='%s?SelectedTask=%sProjectID=%s'Edit/A/TDTDA
HREF='%s/TaskDeps.php?TaskID=%s'Dependancies/A/TD/TR\n,
$myrow[TaskName],
$myrow[FmtEarliestStart],
$myrow[ExpectedDuration],
$myrow[PlayerName],
$myrow[Status],
$myrow[budget],
$myrow[actual],
$difference,
$PHP_SELF,
$myrow[TaskID],
$ProjectID,
$rootpath,
$myrow[TaskID] );
}
echo /TABLEHR\n\n;
}
echo FORM METHOD='post' action= . $PHP_SELF . ;
echo CENTERTABLE\n;
echo INPUT TYPE=HIDDEN NAME='ProjectID' VALUE=$ProjectID;
If ($SelectedTask) {
$difference = ($budget - $actual);
$sql = SELECT TaskName, TaskDescription, EarliestStart,
ExpectedDuration, TaskChampion, Status, budget, actual FROM ProjectTasks
WHERE TaskID=$SelectedTask;
$result = DB_query($sql, $db);
$myrow = DB_fetch_array($result);
$TaskName = $myrow[TaskName];
$TaskDescription = $myrow[TaskDescription];
$EarliestStart = ConvertSQLDate($myrow[EarliestStart]);
$TaskChampion = $myrow[TaskChampion];
$ExpectedDuration=$myrow[ExpectedDuration];
$Status = $myrow[Status];
$budget = $myrow[budget];
$actual = $myrow[actual];
$difference = ($budget - $actual);
echo INPUT TYPE=HIDDEN NAME='TaskID' VALUE=$SelectedTask;
echo INPUT TYPE=HIDDEN NAME='SelectedTask' VALUE=$TaskID;
}
echo TRTDTask Name:/TDTDinput type='Text' name='TaskName'
value='$TaskName' SIZE=52 MAXLENGTH=50/TD/TR\n;
echo TRTDTask Description:/TDTDtextarea name='TaskDescription'
cols=50 rows=8$TaskDescription/textarea/TD/TR\n;
if (!$SelectedTask) {
$EarliestStart = Date(d/m/Y);
}
echo TRTDEarliest Start Date (dd/mm/):/TDTDinput type='Text'
name='EarliestStart' value=$EarliestStart SIZE=12
MAXLENGTH=10/TD/TR\n;
echo TRTDExpected Duration ($DurationName):/TDTDinput type='Text'
SIZE=5 MAXLENGTH=5 name='ExpectedDuration'
value=$ExpectedDuration/TD/TR\n;
echo TRTDProject Lead:/TDTDSELECT name='TaskChampion';
$sql = SELECT PlayerID, PlayerName FROM Players;
$result=DB_query($sql,$db);
while ($myrow=DB_fetch_array($result)){
if ($myrow[PlayerID]==$TaskChampion){
echo OPTION SELECTED Value=' . $myrow[PlayerID] . ' .
$myrow[PlayerName];
} else {
echo OPTION Value=' . $myrow[PlayerID] . ' .
$myrow[PlayerName];
}
}
echo /SELECT/TD/TR\n;
echo TRTDStatus:/TDTDSELECT name='Status';
if ($Status==Wait){
echo OPTION SELECTED Value='Wait'Not Started;
} else {
echo OPTION Value='Wait'Not Started;
}
if ($Status==Started){
echo OPTION SELECTED Value='Started'Started;
} else {
echo OPTION Value='Started'Started;
}
if ($Status==Complete){
echo OPTION SELECTED Value='Complete'Complete;
} else {
echo OPTION Value='Complete'Complete;
}
echo /SELECT/TD/TR\n;
echo TRTDProjected Budget:/TDTDinput type='Text' name='budget'
value=$budget/TD/TR\n;
echo TRTDActual Budget:/TDTDinput type='Text' name='actual'
value=$actual/TD/TR\n;
echo TRTDBudget
Difference/TDTDb$difference/b/font/TD/TR\n;
if (!$SelectedTask) {
echo /TABLE\n\nPCENTERinput type='Submit' name='submit'
value='Add New task'\n/FORM;
} else {
echo /TABLE\n\nPCENTERinput type='Submit' name='delete'
value='Delete task'input type='Submit' name='submit' value='Update
task'/FORM\n;
}
?
?php include ../inc/ftr.php ?
END PHP STUFF ---
I can't figure out how to get the script working on this page. Where should
the variable definition go?
Thanks for any help.
If you can, please reply to [EMAIL PROTECTED], as I am on the digest.
mto
--
Michael O'Neal
Web Producer/ Autocrosser
ST 28 '89 Civic Si
-
M A N G O
B O U L D E R
-
http://www.thinkmango.com
e- [EMAIL PROTECTED]
p- 303.442.1821
f- 303.938.8507
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL
Re: [PHP] Trying to subtract...no luck. (Long Code)
Thanks all...I got what I needed. I'm amazed at how many different ways there are to do the same thing! mto -- Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si - M A N G O B O U L D E R - http://www.thinkmango.com e- [EMAIL PROTECTED] p- 303.442.1821 f- 303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] PHP Knowledge Base solution?
Hi. Anyone know of a Knowledge Base solution (Like you see from computer manufacturers on their websites) done in PHP/MySQL? Something where a user could search for entries on specific problems and such they might have? Please email me at [EMAIL PROTECTED] as I am on the digest. Thanks, mto -- Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si - M A N G O B O U L D E R - http://www.thinkmango.com e- [EMAIL PROTECTED] p- 303.442.1821 f- 303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Still no solution...can anyone help?
Hi,
I'm creating a PHP/MySQL photo gallery app and I'm having problem with my
edit page. I want the user to be able to change any of the fields in the
record. In this case there are two text fields, and two file fields where
they can browse to replace the images that are currently in the database.
The file fields send a variable of none if the user doesn't change it.
So, what I've done is created an if/else statement that says if these fields
DON'T = none, then do the SQL. However, I didn't account for the user
just updating ONE of the image fields. (Which still sends none for the
image field that *doesn't* get updated. Below is what I have so far:
?php
if (($userfile_th) ($userfile_full) ($userfile_th $userfile_full !=
none)) {
$db_name = wonderland;
$table_name = photo;
$connection = @mysql_connect($db_loc,$db_user,$db_pass) or
die(Couldn't Connect.);
$db = @mysql_select_db($db_name, $connection) or die(Couldn't select
database.);
$sql =UPDATE $table_name set
title='$title',caption='$caption',thumbnail='$userfile_th_name',full_size='$
userfile_full_name' WHERE ID=\$ID\;
$result = @mysql_query($sql, $connection) or die(Couldn't execute query.);
copy($userfile_th,
/Users/emptyo/Sites/wonderland/images/gallery/thumbnail/$userfile_th_name)
;
copy($userfile_full,
/Users/emptyo/Sites/wonderland/images/gallery/full_size/$userfile_full_name
);
include(edit_photo_upd_suc.html);
}
else {
$db_name = wonderland;
$table_name = photo;
$connection = @mysql_connect($db_loc,$db_user,$db_pass) or
die(Couldn't Connect.);
$db = @mysql_select_db($db_name, $connection) or die(Couldn't select
database.);
$sql =UPDATE $table_name set title='$title',caption='$caption' WHERE
ID=\$ID\;
$result = @mysql_query($sql, $connection) or die(Couldn't execute query.);
include(edit_photo_upd_ok.php);
}
?
So, my question is, do I need to do a separate if/else statement for every
combination of what the user might want to change (Two text fields, and one
image, or both images and no text fields, or 1 text field and 1 image,
etc..) or is there a catch-all that might be able to do this for me?
I'm a pretty new PHP'er, so forgive me if this is an obvious question, or
there is a better way to do this.
Please respond directly to [EMAIL PROTECTED] as I am on the digest.
TIA,
mto
--
Michael O'Neal
Web Producer/ Autocrosser
ST 28 '89 Civic Si
-
M A N G O
B O U L D E R
-
http://www.thinkmango.com
e- [EMAIL PROTECTED]
p- 303.442.1821
f- 303.938.8507
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Image Edit Uploading Problem.
Hi,
I'm creating a PHP/MySQL photo gallery app and I'm having problem with my
edit page. I want the user to be able to change any of the fields in the
record. In this case there are two text fields, and two file fields where
they can browse to replace the images that are currently in the database.
The file fields send a variable of none if the user doesn't change it.
So, what I've done is created an if/else statement that says if these fields
DON'T = none, then do the SQL. However, I didn't account for the user
just updating ONE of the image fields. Below is what I have so far:
?php
if (($userfile_th) ($userfile_full) ($userfile_th $userfile_full !=
none)) {
$db_name = wonderland;
$table_name = photo;
$connection = @mysql_connect($db_loc,$db_user,$db_pass) or
die(Couldn't Connect.);
$db = @mysql_select_db($db_name, $connection) or die(Couldn't select
database.);
$sql =UPDATE $table_name set
title='$title',caption='$caption',thumbnail='$userfile_th_name',full_size='$
userfile_full_name' WHERE ID=\$ID\;
$result = @mysql_query($sql, $connection) or die(Couldn't execute query.);
copy($userfile_th,
/Users/emptyo/Sites/wonderland/images/gallery/thumbnail/$userfile_th_name)
;
copy($userfile_full,
/Users/emptyo/Sites/wonderland/images/gallery/full_size/$userfile_full_name
);
include(edit_photo_upd_suc.html);
}
else {
$db_name = wonderland;
$table_name = photo;
$connection = @mysql_connect($db_loc,$db_user,$db_pass) or
die(Couldn't Connect.);
$db = @mysql_select_db($db_name, $connection) or die(Couldn't select
database.);
$sql =UPDATE $table_name set title='$title',caption='$caption' WHERE
ID=\$ID\;
$result = @mysql_query($sql, $connection) or die(Couldn't execute query.);
include(edit_photo_upd_ok.php);
}
?
So, my question is, do I need to do a separate if/else statement for every
combination of what the user might want to change (Two text fields, and one
image, or both images and no text fields, or 1 text field and 1 image,
etc..) or is there a catch-all that might be able to do this for me?
I'm a pretty new PHP'er, so forgive me if this is an obvious question, or
there is a better way to do this.
Please respond directly to [EMAIL PROTECTED] as I am on the digest.
TIA,
mto
--
Michael O'Neal
Web Producer/ Autocrosser
ST 28 '89 Civic Si
-
M A N G O
B O U L D E R
-
http://www.thinkmango.com
e- [EMAIL PROTECTED]
p- 303.442.1821
f- 303.938.8507
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Previous / Next Buttons
on 9/6/01 11:52 PM, [EMAIL PROTECTED] went and wrote:
I'll show you what I did but realize I'm an advanced beginner/intermediate
programmer. This may not be the most efficient way to do it but seems to
be the simplest code compared to other ways of doing it that I've seen. Not
sure if I will explain this well enough either. And this is for a fairly small
database. With a larger one it may be too inefficient.
First count how many records are in the database for the album and put
it in $count.
Then loop through all the records in the album, place the id for each record
in an array and find out where in the array the current record is. $photo_id
is fed to this script which tells it which picture to display:
$x = 0;
while ($row = mysql_fetch_array($result)) {
$photo_id1 = $row['photoid'];
$array[$x] = $photo_id1;
if ($photo_id1 == $photo_id) {
$position = $x;
Thanks a lot, Jeff Chris. I'll try it this morning!
mto
--
Michael O'Neal
Web Producer/ Autocrosser
ST 28 '89 Civic Si
-
M A N G O
B O U L D E R
-
http://www.thinkmango.com
e- [EMAIL PROTECTED]
p- 303.442.1821
f- 303.938.8507
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Previous / Next Buttons
Hi, what's the simplest way to provide previous/next buttons that navigate through individual records of a database? This is for a photo gallery, so I want to do one record at a time until I'm out of records, then I want the next button to disappear. I've been fiddling with it for a while now, but haven't been very successful. Anyone have any snippets, or ideas for me? Thanks in advance. mto -- Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si - M A N G O B O U L D E R - http://www.thinkmango.com e- [EMAIL PROTECTED] p- 303.442.1821 f- 303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] MySQL trubs
Hi. I've recently set up phpMyAdmin on an OS X 10.1 server. Everything was fine, and it set up great. I then restarted the Apache server and am getting this message: Warning: Access denied for user: 'root@localhost' (Using password: YES) in /Library/WebServer/Documents/Mangotest/phpMyAdmin/lib.inc.php on line 351 Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: YES) in /Library/WebServer/Documents/Mangotest/phpMyAdmin/lib.inc.php on line 351 Error MySQL said: Access denied for user: 'root@localhost' (Using password: YES) I've been mucking around the command line for a while, but can't figure out how to reset my root password. It *was* setup with a root password, but it won't let me in now. Anyone have any suggestions? Please respond to [EMAIL PROTECTED], as I am on the digest. Thanks. mto -- Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si - M A N G O B O U L D E R - http://www.thinkmango.com e- [EMAIL PROTECTED] p- 303.442.1821 f- 303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Mac PHP'ers - New PHP editor!
Hi all. I just stumbled across this earlier this week. It's an app called JaneBUILDER that helps with some of the PHP tedium of connecting, selecting, and grabbing data from your MySQL db. I was amazed at how fast I put together an admin section for a client...3 minutes generated 10 pages!!! Here's a little blurb from their website: What is JaneBUILDER? JaneBUILDER is a visual editor for PHP. JaneBUILDER allows you build complex PHP pages with mouse clicks and menu items. The files created are native PHP (text) files (that can be opened by any html tool or text editor) and uploaded to your web server for deployment. JaneBUILDER Philosophy: JaneBUILDER is simple tool that lets you build PHP pages extremely quickly. JaneBUILDER is not a replacement for your current HTML editor. Nor, is it a replacement for your current text editor. JaneBUILDER is a tool that lives in and lets you work in between these two worlds. We call it middleware for your middleware. We think you'll love it so much you will add it to your current arsenal of web tools. I certainly don't work for them, but I think it's a cool app. Windows version on the way, apparently. http://www.seejanecode.com mto -- Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si - M A N G O B O U L D E R - http://www.thinkmango.com e- [EMAIL PROTECTED] p- 303.442.1821 f- 303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] PHP Client Proofing System out there?
Hi. I work at a design agency, and we're looking to find/build/create a system where we can post client comps, and the client can log in and check out the work we've done for them. Has anyone seen anything like this out there that's built already? Please respond directly to [EMAIL PROTECTED], as I am on the digest. Thanks in advance! mto -- Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si - M A N G O B O U L D E R - http://www.thinkmango.com e- [EMAIL PROTECTED] p- 303.442.1821 f- 303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Postcard/Tell a friend app
Hi, First of all, thanks to all that answered my Auction question a few days ago. It looks like http://www.phpauction.org/ was the clear winner. So, on to the next question. Has anyone seen an app that can send digital cards, where a user can choose their picture, and add whatever text and font they want, then send to as many people as they want? Here's what I'm going for: http://itools.mac.com/WebObjects/iCards.woa?aff=consumercty=USlang=eniden tifier=BPimK6ft7BH2KBYf This one was built in WebObjects, but is pretty robust. Thanks in advance. mto -- Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si - M A N G O B O U L D E R - http://www.thinkmango.com e- [EMAIL PROTECTED] p- 303.442.1821 f- 303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] search for a better php source code viewer
on 6/27/01 1:49 AM, ReDucTor leaped tall buildings, and wrote: EditPlus is the best program EVER I use it for every thing... :) :) BB Edit is the PHP coder of choice on the Mac side. It does everything! It also has a great PHP library so you don't have to manually type redundant code, like MySQL connects and such. http://www.bbedit.com mto -- Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si - M A N G O B O U L D E R - http://www.thinkmango.com e- [EMAIL PROTECTED] p- 303.442.1821 f- 303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Auction PHP Solution?
Hi, Has anybody seen an ebay-like auction solution done in PHP? Thanks, mto -- Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si - M A N G O B O U L D E R - http://www.thinkmango.com e- [EMAIL PROTECTED] p- 303.442.1821 f- 303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Function Question
Hi. I'm hoping you folks can help me with a function problem I have.
Take a look at the following code:
?
?php
function fill_page($title) {
?
html
head
title?php echo $title; ?/title
?php
}
?
I have a page divided into 3 sections. A header include, the content,
and a footer include.
I have a function (fill_page) that lives in the header include that has
it's variable defined in the content page. As you can see, the function
above will fill $title with whatever is defined in the content page.
i.e. fill_page(This is the title)
What I want to do is use that $title variable *outside the function, a
little further down the page. I've played around with the ampersand
before the dollar sign, and using a global variable, all with no success.
It seems to me that this should be simple, and I think I'm
overcomplicating it. Here's what I'm trying to do:
1. Get a string of text from the individual content pages.
2. Use that string in the Title of the html page
3. Use the same string as the header of the content page.
I'm sorry I'm being stupid about it...but I've made it harder than it
probably is.
Please respond to [EMAIL PROTECTED] as I am on the digest.
Thanks in advance.
mto
Michael O'Neal
Web Producer/ Autocrosser
ST 28 '89 Civic Si
-
M A N G O
B O U L D E R
-
http://www.thinkmango.com
[EMAIL PROTECTED]
p-303.442.1821
f-303.938.8507
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: ANN:Visual PHP Studio 1.0 Field Test 1 B156 New release!
On Wed, 16 May 2001 00:28:21 +0200, José León Serna [EMAIL PROTECTED] successfully typed: Hello: The next release of Visual PHP Studio is out!!!. I have reserved the domain visualphpstudio.com and I have moved the web site to a new host to avoid some problems with the old one. The most exciting feature on this release is the ability to work with HTML Forms, a new palette contains all the components you need to create HTML Forms. Even you don't like Visual PHP Studio to develop your pages, maybe you could use it to design your forms, because it's very easy and powerful. Hopefully when/if you make a Linux version, you can port it to Mac OS X as well! mto Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si - M A N G O B O U L D E R - http://www.thinkmango.com [EMAIL PROTECTED] p-303.442.1821 f-303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] PHP4 and MySQL on Macintosh
On Mon, 14 May 2001 17:49:08 -0400, Hoover, Josh [EMAIL PROTECTED] wrote: Andy, I believe you can run PHP on Mac OS with the use of WebTen by Tenon (http://www.tenon.com/products/webten/). MySQL does not run on Mac OS. You can run both PHP 4 and MySQL on Mac OS X. Since it sounds like you're a Mac developer, I would suggest you check out the AMP mailing list which is full of Mac developers using technologies like PHP, MySQL, Mac OS X, etc. The URL is http://www.developersplace.com/ Hope that helps out. Josh Hoover KnowledgeStorm, Inc. [EMAIL PROTECTED] Searching for a new IT solution for your company? Need to improve your product marketing? Visit KnowledgeStorm at www.knowledgestorm.com to learn how we can simplify the process for you. KnowledgeStorm - Your IT Search Starts Here does anybody know if it is possible to run these applications on MAC 0S? I have PHP, MySQL, and Apache running on my OS X box beautifully. There are double-click installers out there that will install all of those apps. Actually, PHP and Apache come installed by default. You just have to edit the httpd.conf file to turn them on. You can get all this great UNIX functionality with the Out of the box version of OS X consumer, for $99. OS X server 2 will be out shortly, and will have web, mail, and file server admin features. HTH, mto Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si - M A N G O B O U L D E R - http://www.thinkmango.com [EMAIL PROTECTED] p-303.442.1821 f-303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Image problem
Hi, I'm still pretty new to PHP, and would like help on a solution for a problem I have. I have a website that has 6 different sections. (about, news, buying, selling, community, and relocation) Each of the sections has it's own subfolder in the root directory of the website. (/about, /news, etc...) Each of the sections also has a header image and footer image associated with that section. (hdr_txt_about.gif, ftr_txt_about.gif, hdr_txt_news.gif, etc..) I want to use PHP to know what section of the website the user is in, and load the appropriate header/footer image. I know that I need some sort of if/then statement, and I know that it has to use the URL to see where it is, but I don't know where to implement it, and I'm not quite sure how. The website is setup with an included header that has most of the html/javascript, a mostly text file for the content, and an included footer that takes care of the rest. Any help with this would be greatly appreciated. Thanks, mto Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si - M A N G O B O U L D E R - http://www.thinkmango.com [EMAIL PROTECTED] p-303.442.1821 f-303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Image problem
On Tue, 15 May 2001 10:23:39 -0700, Jerry Lake [EMAIL PROTECTED]
wrote:
This is how I fixed that same issue
in the head of my page
snip
if (ereg (new, $PHP_SELF)) {
$header = img src=location/of/header/image;
$title = www.website.com - What's New; }
elseif (ereg (products, $PHP_SELF)) {
$header = img src=location/of/header/image;
$title = www.website.com - Products; }
else {
$header = img src=location/of/header/image;
$title = www.website.com; }
/snip
then call the header in in the appropriate place in
your html ? echo $header; ?
Thanks Jerry.
This is what I ended up going with, (Thanks to Josh Hoover) and it works
great!
switch(true)
{
case (stristr($REQUEST_URI, /about/)):
$headerImage = /images/hdr_txt_about.gif;
$footerImage = /images/ftr_txt_about.gif;
break;
case (stristr($REQUEST_URI, /news/)):
$headerImage = /images/hdr_txt_news.gif;
$footerImage = /images/ftr_txt_news.gif;
break;
case (stristr($REQUEST_URI, /buying/)):
$headerImage = /images/hdr_txt_buying.gif;
$footerImage = /images/ftr_txt_buying.gif;
break;
case (stristr($REQUEST_URI, /selling/)):
$headerImage = /images/hdr_txt_selling.gif;
$footerImage = /images/ftr_txt_selling.gif;
break;
case (stristr($REQUEST_URI, /community/)):
$headerImage = /images/hdr_txt_community.gif;
$footerImage = /images/ftr_txt_community.gif;
break;
case (stristr($REQUEST_URI, /relocation/)):
$headerImage = /images/hdr_txt_relocation.gif;
$footerImage = /images/ftr_txt_relocation.gif;
break;
}
Then, just called $headerImage, and $footerImage in the appropriate
places.
Thanks to all!
mto
Michael O'Neal
Web Producer/ Autocrosser
ST 28 '89 Civic Si
-
M A N G O
B O U L D E R
-
http://www.thinkmango.com
[EMAIL PROTECTED]
p-303.442.1821
f-303.938.8507
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Website production tool in PHP
Hi, I am wondering if a website planning/production tool exists already in PHP? This would be something that the agency and the client could use as a central meeting place about the project, with deadlines, comps, project brief, etc... Unix based, PHP/MySQL setup is preferred. I thought I'd mail the list before I built one from scratch. Please email me directly at [EMAIL PROTECTED], as I am on the digest. Thanks! mto Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si - M A N G O B O U L D E R - http://www.thinkmango.com [EMAIL PROTECTED] p-303.442.1821 f-303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Image Processing in PHP
Hi, I want a client to be able to upload a file to the web server via PHP. Then, I want that image to be processed, scaled, and made into thumbnails and full-size images. Is this possible with the image processing capabilities of PHP, or should I use something like Image Magick to do it server side? Please copy your reply to [EMAIL PROTECTED] as I am on the digest version. Thanks in advance. mto Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si - M A N G O B O U L D E R - http://www.thinkmango.com [EMAIL PROTECTED] p-303.442.1821 f-303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Count function. (Newbie Question)
Hi, I'm trying to display a record count of some sort on a page I'm working on. For example, "Record 1 of 15". I can display the 1st number ok, but I'm a bit confused on what the count function should look like for the 2nd number (15, in this case). Here is my current (not working) code. ?php $query = "SELECT count(*) FROM mango_pr"; $result = mysql_query($query); $record_count = mysql_fetch_row($result); ? And then I'm calling the code with an "echo" later on: b?php echo $record_count ? /b/font This obviously isn't right...can anyone offer any suggestions? Thanks, mto Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si - M A N G O B O U L D E R - http://www.thinkmango.com [EMAIL PROTECTED] p-303.442.1821 f-303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Count function. (Newbie Question)
Hi There are 2 issues: You need to maintain a page counter You need to pass the page counter and the total page count from page to page You can do this via url params (xxx.html?page=$page_countrecord_count=$record_count), sessions or cookies depending HTH Let me elaborate a little bit more. I don't think I explained myself very well. Sorry to waste the bandwidth. I am building a little press-release administration for our sales department. There is a single page that contains form fields where they can input thier data. I want the users/admins to be able to see what record number they are editing, and how many total records there are in the db. I have figured out the record number by echoing the "ID" of the record. I can't figure out how to display how many *total* records there are in that db. Does your tip still apply? Thanks again, mto Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si - M A N G O B O U L D E R - http://www.thinkmango.com [EMAIL PROTECTED] p-303.442.1821 f-303.938.8507 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
