RE: [PHP-DB] php variables to JS

2003-01-05 Thread Bryan McLemore
Could always pass it through a hidden form.

Bryan


-Original Message-
From: Bruce Levick [mailto:[EMAIL PROTECTED]] 
Sent: Sunday, January 05, 2003 1:09 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] php variables to JS

Bruce Levick - VivamotionI am opening a chromless window with some JS
code.
I need to pass some variables which come from rows in my database into
the
jscript which will determine the size and URL of the window.

Before I go about drawing the info from the database I have set up some
hard
code php variables just so i could test how to pass these into js.

Does anybody know how I can code these variables into my jscript??

Cheers

##
?php
$h = 600;
$w = 343;
$theURL = test.php;
$wname = test;
?
###

##
script language=javaScript type=text/javascript
SRC=js/java.js/SCRIPT

script
!--
function openIT() {
theURL=wesley.php//php variable here
wname =CHROMELESSWIN  //php variable here
W=300;  //php variable here
H=100;  //php variable here
windowCERRARa = images/close_a.gif
windowCERRARd = images/close_d.gif
windowCERRARo = images/close_o.gif
windowNONEgrf = images/none.gif
windowCLOCK = images/clock.gif
windowREALtit = nbsp;? Task title
windowTIT = font face=verdana size=1nbsp;your chromless/font
windowBORDERCOLOR = #00
windowBORDERCOLORsel = #00
windowTITBGCOLOR = #FF0033
windowTITBGCOLORsel = #FF0033
openchromeless(theURL, wname, W, H, windowCERRARa, windowCERRARd,
windowCERRARo, windowNONEgrf, windowCLOCK, windowTIT, windowREALtit ,
windowBORDERCOLOR, windowBORDERCOLORsel, windowTITBGCOLOR,
windowTITBGCOLORsel)
}
//--
/script
##



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] advise needed for 'authorized only' site

2002-09-23 Thread Bryan McLemore

you could make them log in once per session and just have every page check
and see if they already have logged in and if they have not then trigger the
login mechanism.

Not sure exactly how to implement but I've read on the practice before.

-Bryan

- Original Message -
From: [EMAIL PROTECTED]
To: PHP_DB [EMAIL PROTECTED]
Sent: Monday, September 23, 2002 10:14 AM
Subject: [PHP-DB] advise needed for 'authorized only' site


 I have set up a section of my company site for use by authorized dealers
 only. I am currently using
 mysql authorization, which works for the first page, but if someone were
to
 type in the url of an
 underlying page they would be able to get in without authorization. I know
 I could use .htaccess
 for handling this but with a minimum of 350 -400 users to keep track of
 that would be unwieldly to
 say the least, especially for my boss who doesn't have a clue about *nix
 and has never even heard
 of .htaccess.

 What other options do I have to keep the underlying pages from being
 accessed without the user
 being forced to go through the logon screen?

 Thanks,

 --
 Chip Wiegand
 Computer Services
 Simrad, Inc
 www.simradusa.com
 [EMAIL PROTECTED]

 There is no reason anyone would want a computer in their home.
  --Ken Olson, president, chairman and founder of Digital Equipment
 Corporation, 1977
  (They why do I have 9? Somebody help me!)


 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] SQL file,

2002-09-21 Thread Bryan McLemore

in an example I saw in a book while I was leafing through it at barnes and nobles I 
saw a .sql file.  It appeared to have the schema for a db in it.  I was wondering what 
exactly what it is and how one could use it in a php application like he was doing.  

Thanks,
Bryan 



[PHP-DB] PHP Editor?

2002-09-06 Thread Bryan McLemore

First off, What html/php editor do you guys think is better?

Secondly, perhaps a little more relevant to the database part of this.  I just want to 
clarify that with mysql_query() I can send any valid sql expression and it will do 
that?

-Bryan



[PHP-DB] SQL Query

2002-09-06 Thread Bryan McLemore

Hi Guys I have written this SQL Query :

CREATE TABLE tasks (id INT AUTO_INCREMENT, name VARCHAR(50), desc TEXT, address 
VARCHAR(50), startDate DATE, lastWork DATE, progress INT(3))

I'm sending it in through php and I can't get it to work correctly.  Please help.  
Also, I would like to make id the primary key/index

-Bryan



Re: [PHP-DB] Re: mysql_connect

2002-09-05 Thread Bryan McLemore

Sorry about the private email didn't mean too.  The email header shows you
as it being from you and when I hit reply it defaults to go to you.  Sorry
bout that.

Well on the goodside I got it fixed.  Thanks for the feedback.  The thing
that got me was not having root has the user.  Well thanks.

Bryan

- Original Message -
From: David Robley [EMAIL PROTECTED]
To: Bryan McLemore [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, September 05, 2002 8:26 PM
Subject: Re: [PHP-DB] Re: mysql_connect


 On 3 Sep 2002 at 23:00, Bryan McLemore wrote:

  - Original Message -
  From: David Robley [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, September 03, 2002 9:31 PM
  Subject: [PHP-DB] Re: mysql_connect
 
 
   In article 000c01c253b2$506d7530$0101a8c0@fwcmain,
   [EMAIL PROTECTED] says...
I'm trying to connect using the sample code in the php
documentation.
  IT however dies every time.  If someone could please help me?  Thanks. 

BryanCan you show the code you are using, and any error
  messages you get?   --  David Robley  Temporary Kiwi!   Quod
subigo
  farinam   --  PHP Database Mailing List (http://www.php.net/)  To
  unsubscribe, visit: http://www.php.net/unsub.php 

 Love the formatting by your mail pkg - OE of course :-)

  The code is
 
  $link = mysql_connect(localhost:3306, UserName, Password)
   or die(Could not connect);
 
  Thanks,
  Bryan McLemore

 May I suggest you keep the discussion on the mailing list - a) you have
 the entire list's expertise to draw on, b) the solution is shared with
 others who may benefit and c) you may get a quicker answer.

 Now, you haven't said so, but I assume you are getting 'Could not
 connect'?

 So, points to check:

 1) mysql is running, and on port 3306; note that you don't need to
 specify the port usually
 2) the username and password are correct - try the command line version
 to check that the user/pass are accepted (assuming you have command line
 access)
 3) remove the 'or die' construct and see if you get an error message


 --
 David Robley
 Temporary Kiwi!
 Quod subigo farinam

 My grape juice has fermented, Tom whined.



 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] mysql_connect

2002-09-03 Thread Bryan McLemore

I'm trying to connect using the sample code in the php documentation.  IT however dies 
every time.  If someone could please help me?  Thanks.

Bryan



[PHP-DB] MySQL/PHP

2002-08-30 Thread Bryan McLemore

Where can I find a good manual/tutorial on how to access mySQL w/PHP.  Keep in mind 
that I am new to both PHP and mySQL, and my database theory is sketchy at best.

Thanks.