chiphpug-discuss — Discussions of PHP-related topics among members of the Chicago PHP User's Group.

[chiPHPug-discuss] PHPLib and Oracle

[Joseph A. <ja...@za...>]

Is there some one use PHPLib with db_oracle.inc ? How it works?
I am asking because of comments into db_oracle.inc:
  	/* 
	Due to a strange error with Oracle 8.0.5, Apache and PHP3.0.6
     	you don't need to set the ENV - on my system Apache
     	will change to a zombie, if I don't set this to FALSE!
     	If unsure try it out, if it works. 
	*/
Thanks.
Joseph Azaryayev 

Re: [chiPHPug-discuss] MySQL

[Tamara A. <ab...@ab...>]

At 06:18 PM 5/20/2002 -0500, Tamara Abbey wrote:

>aaaaaargh -- o.k., I finally have RedHat 7.2 (sorry, dm -- but, that's the 
>way it goes) on the laptop and I even have php/mysql.

I've been struggling with this for too long -- couldn't see the forest for 
the trees.

You've all been very kind when I know you're thinking -- duh! RTFM!

Thank you Andra, Chris, Simon, Joseph.

Back to http://www.mysql.com/

<t />

Re: [chiPHPug-discuss] MySQL

[Chris M. <mca...@ho...>]

Also, the online MySQL documentation is excellent.  There's a tutorial
chapter that gives you enough information to work on for a while.
Personally, I use that chapter, and O'Reilly's SQL in a nutshell book.
Between those two, I feel pretty comfortable.  Also, oreillynet.com has a
series of general SQL articles that are pretty good.

Good luck,
Chris McAvoy


----- Original Message -----
From: "Andra" <am...@rc...>
To: "Tamara Abbey" <ab...@ab...>
Cc: <chi...@li...>
Sent: Monday, May 20, 2002 7:46 PM
Subject: Re: [chiPHPug-discuss] MySQL


> Hey Tamara--
>     OK, it's not exactly pocket size, but if you take the first chapter of
the
> Rider book on MySQL, and the appendix of commands, and that's about
exactly
> what you're looking for.
>     But smaller and clearer than that-- I don't know. --  Andra
>
> Tamara Abbey wrote:
>
> > aaaaaargh -- o.k., I finally have RedHat 7.2 (sorry, dm -- but, that's
the
> > way it goes) on the laptop and I even have php/mysql.
> >
> > Now, about this mysql -- I like using phpMyAdmin, I really do.
> >
> > But, since I seem to get some sort of kick out of making myself
miserable,
> > is there a good mysql tut on the net?
> >
> > I know, there's tons of info -- but some sort of pocket guide to the
> > important commands? For example, I created a database, but I'll be
darned
> > if I can find it!
> >
> > Thanks all!
> >
> > <tamara />
> > who's also thinking about phpMyAdmin anyway . . .
>
>
>
> _______________________________________________________________
>
> Don't miss the 2002 Sprint PCS Application Developer's Conference
> August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
>
> _______________________________________________
> chiPHPug-discuss mailing list
> chi...@li...
> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss
>

Re: [chiPHPug-discuss] MySQL

[Andra <am...@rc...>]

Hey Tamara--
    OK, it's not exactly pocket size, but if you take the first chapter of the
Rider book on MySQL, and the appendix of commands, and that's about exactly
what you're looking for.
    But smaller and clearer than that-- I don't know. --  Andra

Tamara Abbey wrote:

> aaaaaargh -- o.k., I finally have RedHat 7.2 (sorry, dm -- but, that's the
> way it goes) on the laptop and I even have php/mysql.
>
> Now, about this mysql -- I like using phpMyAdmin, I really do.
>
> But, since I seem to get some sort of kick out of making myself miserable,
> is there a good mysql tut on the net?
>
> I know, there's tons of info -- but some sort of pocket guide to the
> important commands? For example, I created a database, but I'll be darned
> if I can find it!
>
> Thanks all!
>
> <tamara />
> who's also thinking about phpMyAdmin anyway . . .

[chiPHPug-discuss] MySQL

[Tamara A. <ab...@ab...>]

aaaaaargh -- o.k., I finally have RedHat 7.2 (sorry, dm -- but, that's the 
way it goes) on the laptop and I even have php/mysql.

Now, about this mysql -- I like using phpMyAdmin, I really do.

But, since I seem to get some sort of kick out of making myself miserable, 
is there a good mysql tut on the net?

I know, there's tons of info -- but some sort of pocket guide to the 
important commands? For example, I created a database, but I'll be darned 
if I can find it!

Thanks all!

<tamara />
who's also thinking about phpMyAdmin anyway . . . 

[chiPHPug-discuss] RE: Storing Multiple Values in a Single MySql Table Column

[JP H. <jp...@xs...>]

At 07:49 PM 5/14/2002 -0400, rl...@mi... wrote:
>You can do like this:
>
><FORM METHOD=POST>
><INPUT TYPE=CHECKBOX NAME=info[0]> Info 0<BR>
><INPUT TYPE=CHECKBOX NAME=info[1]> Info 1<BR>
><INPUT TYPE=CHECKBOX NAME=info[2]> Info 2<BR>
><INPUT TYPE=CHECKBOX NAME=info[10]> Info 10<BR>
></FORM>

Aren't you missing the value= component? I think you need something like:
<INPUT TYPE=CHECKBOX NAME=info[0] value="1"> Info 0<BR>
<INPUT TYPE=CHECKBOX NAME=info[1] value="1"> Info 1<BR>
<INPUT TYPE=CHECKBOX NAME=info[2] value="1"> Info 2<BR>
<INPUT TYPE=CHECKBOX NAME=info[10] value="1"> Info 10<BR>

Otherwise the input has nothing to assign to the NAMEd variable.  Also, 
doesn't that have to be in a PHP section of code?  I've never seen HTML 
handle arrays before.  And this is all well and good for assigning a 1 to 
every box that's checked but it doesn't assign a 0 to the unchecked 
boxes.  Not automatically anyway.  I suppose if I was using radio buttons 
for each element I could assign the value 1 to YES and 0 to NO but that 
seems a poor alternative.

So, it seems to me that the next step is to have a loop to see if each 
element of the array has been assigned a "1" and if it hasn't then assign 
it a "0".  This would need to occur before the implode statement, 
right?  Or is it that I just don't even need zeros and if 4 boxes were; 
checked, unchecked, unchecked, checked then the implode statement would 
generate "1:::1".  Am I getting warmer?

>Then, simply use:
>
><?php
>   $infotext = implode(":", $info);
>   # Put $infotext into MySQL
>?>
>
>To display the current values:
><?php
>   # Get $infotext from MySQL 0:1:1:0:1...
>   $info = explode(":", $infotext);
>   while (list($index, $value) = each($info)){
>     $checked = $value ? 'CHECKED' : '';
>     echo "<INPUT TYPE=CHECKBOX NAME=info[$index] $checked> Info
>$index<BR>\n";
>   }
>?>

Do I read this right that you suddenly changed from "1" and "0" to 
"CHECKED" and "<nothing>"?
(This kinda goes with my question above about maybe not needing zeros.)

[chiPHPug-discuss] Re: [chiPHPug] Storing Multiple Values in a Single MySql Table Column

[JP H. <jp...@xs...>]

Hi folks,

I'm on a project that requires a couple of fields with checkboxes.  No 
problem creating a field in the form (HTML).  Done that dozens of 
times.  BUT, never done it in MySQL.  Please somebody tell me I don't have 
to have 18 individual fields (9 times 2 to cover the options of both 
fields) in order to do this.

Searching the MySQL website for "checkbox" produced limited results.  In 
fact the only appropriate hit was an excerpt from Kevin Yank's book (joke 
database example) but he's using a relational database design where the 
"categories" are in a separate table and not different values in a single 
field (like I'm accustomed to in PC based relational DB programs).  I don't 
think I need to go relational with this project so I'd rather not follow 
this example.

Then I searched my email archive and found this (which I don't truly 
understand):
At 04:22 PM 1/15/2002 +0000, j8h9 wrote:
>Storing Multiple Values in a Single MySql Table Column (Using Explode/Implode)
>
>Some applications may have a need to store many values or switches in a 
>database. Rather than creating numerous columns to hold all the unique 
>values, you can create one column to hold all the values.
>
>An example of this might be a form which uses multiple checkbox controls. 
>These are simple on/off switches. You can use the 0 and 1 values to 
>indicate whether the checkbox is set on or off.
>
>First, create a column in your MySql table (varchar 255 should be good). 
>Each unique value will be delimited by a colon (":"). So, the contents of 
>the "parameters" column might look like this:
>
>MySql table column called parameters contains: 0:1:1:0:0:0:1
>
>Note the colon delimits each value. After selecting the column from the 
>database, you use the PHP explode verb to explode the values into an array:
>
>$ParmsX = explode(":",$row->parameters);
>
>The PHP documentation describes the explode verb thusly: "Returns an array 
>of strings, each of which is a substring of string formed by splitting it 
>on boundaries formed by the string separator." In the above example, the 
>colon is the delimiter. After the execution of the explode statement, the 
>ParmsX array contains seven elements (i.e. one for each of the zero/one 
>values above).
>
>When your finished with these parameters and are ready to update the 
>database, you can execute the implode verb. This verb is the opposite of 
>the explode verb and re-assembles the array elements back into one string 
>with the designated delimiter.
>
>$Parameters = implode(":",$ParmsX);
>
>Storing multiple values in a single MySql column is very efficient and 
>manageable. Make sure your variables are related. I use this method often 
>to store security bytes (switches) which control user access to specific 
>web pages or actions.
>
>Questions? Comments? Send me a note at tju...@ho...

I created a field in the MySQL DB [ name = InfoRequested, type = 
varchar(255) ] but now I don't know how to write the PHP code to populate 
the field.

Obviously there's an array involved in the field.  Something like this?

<input type="checkbox" name="InfoRequested[]" value="1"> Info Package 1
<input type="checkbox" name="InfoRequested[]" value="1"> Info Package 2
<input type="checkbox" name="InfoRequested[]" value="1"> Info Package 3

If that's proper then if only the first box is checked will it 
automatically know that $InfoRequested[1] and $InfoRequested[2] are 
"0"?  If not then how do I make sure that happens?  Do I make a conditional 
loop that says
if ($InfoRequested[i] != "1") $InfoRequested[i] = "0";
?

I'd be grateful if someone could help me make sure I'm on the right track.


                           Let's go ride,

                              JP Honeywell

Re: [chiPHPug-discuss] login and redirect

[Tamara A. <ab...@ab...>]

Oh for crying out loud -- I guess that's what I deserve when I try coding 
without my usual 2 pots of caffeine --

It would probably help if I asked mysql for the field names!!

duh!

O.k., just in case anyone cares -- here's what I ended up with:

<?php
   mysql_connect("xxxxxx","xxxxxxxx","xxxxxxx") or die ("Unable to connect 
to database.");
   mysql_select_db ("xxxxxx") or die ("Unable to select database.");

   $sql     = "SELECT cid,client_name,username FROM authorize WHERE 
password='$password'";

   $result =  mysql_query($sql) or die ("Couldn't access username");

   $num    = mysql_numrows($result);
   if ($num == 1){

      while ($row = mysql_fetch_array($result)) {
              $client_name = $row["client_name"];
              $username = $row["username"];

    header("Location: /$username\n\n");
		//this now directs to http://www.site.com/abbey --yay!
     }
   }
    else {
     echo ("<div id=main><span class=redtext>You are not authorized to 
enter this area!</span></div>");
     }

     ?>

So anyway, there's one big part of the project -- now I just have to see 
about those sessions in order to validate the user on the pages -- sounds 
like a project for next week.

8-)

Re: [chiPHPug-discuss] login and redirect

[Tamara A. <ab...@ab...>]

At 07:59 AM 5/3/2002 -0700, Peter Harkins wrote:

>On Fri, May 03, 2002 at 05:47:18AM -0500, Tamara Abbey wrote:
> > I've taken a look around and I was wondering, is there any way to have a
> > login and a redirect? Where the login would take the person to the correct
> > page?
> >
> > I've done the login part, but when I try to add a redirect, it stops 
> working.
>
>         header("Location: http://www.example.com");
>
>         The URL given must not be a relative URL ("../index.html"), and
>you've got to send it before other output for the browser to get it as an
>instruction (rather than as data to be displayed).

Yes, I actually did get that far, but the correct page is going to depend 
on the login so I wanted to redirect to something like 
http://www.site.com/$user

That's where the thing falls apart -- when I did the login, I'm selecting 
from the db so that I have

SELECT cid, user,password FROM authorize WHERE password=$password

which lets me in, but if I try the next step with the $user, I'm getting 
http://www.site.com. I tried echoing out $user and $password, but only 
$password was actually printing to the page.

I've been looking and I haven't seen anything, so I was wondering if this 
was even possible.

Thanks
<t />

Re: [chiPHPug-discuss] login and redirect

[Peter H. <mal...@us...>]

On Fri, May 03, 2002 at 05:47:18AM -0500, Tamara Abbey wrote:
> I've taken a look around and I was wondering, is there any way to have a 
> login and a redirect? Where the login would take the person to the correct 
> page?
> 
> I've done the login part, but when I try to add a redirect, it stops working.

	header("Location: http://www.example.com");

	The URL given must not be a relative URL ("../index.html"), and
you've got to send it before other output for the browser to get it as an
instruction (rather than as data to be displayed).

[chiPHPug-discuss] login and redirect

[Tamara A. <ab...@ab...>]

I've taken a look around and I was wondering, is there any way to have a 
login and a redirect? Where the login would take the person to the correct 
page?

I've done the login part, but when I try to add a redirect, it stops working.

Thanks!
<tamara />

RE: [chiPHPug-discuss] PHP installation problem

[Jason S. G. <ja...@mu...>]

Could be a newer version of PHP or a new configuration setting.

If register_globals is set to On in your php.ini, then for the url 

page.php?variable=value

You can automatically reference $variable 

Otherwise, with the newer php setups, you need 
$_GET["variable"] or $_POST["variable"] to access it.

- jason scott gessner
    ja...@mu...

[chiPHPug-discuss] PHP installation problem

[Jessica L. <cj...@oa...>]

Hi! Everyone,

I am learning PHP recently. But, I got a problem when I tested my
program.

I tested a same program on two apache servers.

One is working fine, I mean when users input their name and age, it will
be showed on next page.

(passing the value works fine.)

But, When I runned this same program on another server, the valus did
not pass to the next page.

I do not what cause this problem. I even can not figure out what problem
is?

I know maybe it is a server configuration problemm, but how can I solve
it?

Can someone give some advices? thank you so much!




Jessica Lee

[chiPHPug-discuss] CVS

[Jason S. G. <ja...@mu...>]

Okay, found better instructions.....sorry...

-jason scott gessner
	ja...@mu...
	630.542.7974
     

[chiPHPug-discuss] CVS setup on redhat 7.2

[Jason S. G. <ja...@mu...>]

Hey guys and gals.

I know that david is planning a CVS talk next Saturday, but I just got a
brand spanking new redhat7.2 box (and I have a wedding to go to that
day.  :(  ), so I was wondering if anyone could talk me through a CVS
server install on redhat 7.2.

I have done this on windows 2000/XP, but am moving it to the right
platform now. :)

Please email or call me if you are willing to help.

Thanks!

-jason scott gessner
	ja...@mu...
	630.542.7974
     

[chiPHPug-discuss] extracting domain from url

[<da...@dm...>]

Have any good solution to pull foo.com from www.foo.com remembering that
some domains are foo.co.uk, etc?

[chiPHPug-discuss] Make the switch

[Ted K. <te...@aa...>]

I hope everyone switches over.

Ted

[chiPHPug-discuss] RE: [chiPHPug] Newsletter script

[Tamara A. <ab...@ab...>]

That would be great.

This is my volunteer job, so I didn't really want to spend a lot of time on 
it -- that's why I'm not doing my own.

<t />

[chiPHPug-discuss] Hello, hello

[Tamara A. <ab...@ab...>]

Just saw the note and signed up immediately -- ChiPHPug list with no ads -- 
oh yeah!!

8-)

[chiPHPug-discuss] 1st post

[Jason S. G. <ja...@mu...>]

Well, I have sent a message off to everyone on the old yahoo
list...let's see how everything goes...

-jason scott gessner
	ja...@mu...
	630.542.7974