[PHP-DB] Compatibility with PHP and MySQL

2011-09-05 Thread Gabriel Solberg
Will installing the most recent XMAPP to install PHP MySQL and Apache to
create a development environment on my local computer affect how everything
runs when I upload it to the server (My web host 1and1.com runs php 5.0 and
MySQL 5.0) thanks

-- 
Gabriel Solberg
Solberg Design
845/389-6877


[PHP-DB] multiple queries in the same request

2005-06-20 Thread Gabriel B.
I have a table with some relational values, that really saves me on
selects, but gives me a weird error in the insert...

in the DB i have this 2 tables data and categories:
data(
id int
category tinyint ),
categories (
id tinyint
description varchar )

for selects i can use a single query with a left join.

but to populate the table without having to use magic numbers in my
code i've come up with:

SELECT (@category_id:=id) FROM categories WHERE description = cat1;
REPLACE INTO data VALUES( 10, @category_id);

i send this as a single query in PHP and it returns an error quoting
everything after the first ;

anyidea if i can't send several queries at once? any workaround?

Thanks,
Gabriel

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



[PHP-DB] Struggling to install php4 on win 2000 system with apache2

2004-12-07 Thread Gabriel kolbe
I have Windows 2000 on my system. I have installed Apache 2 and it seems to 
work fine, when I test it, it goes to the 'localhost' dir.



PHP is the problem, I have tried about 5 different websites's installation 
manuals to no avail. I have tried to do a manual installation



I have downloaded PHP 4.3.9  and have unzipped it into C:/php



Apache is installed in 'c:/program files/ apache group/apache2'



I have changed the php.ini-recommended file to php.ini, then I have copied 
it with the php4ts.dll  and  php4apache2.dll and all the dll's from the dlls 
folder to both my system and system32 folders in the WINNT folder on the c:/



Before I have done this I have changed the following files in the



php.ini file;



Short_open_tag = on off

Magic_quotes_gpc = onoff

Session.save_path = c:/temp

(a temp folder was created on the c:)





doc_root = c:\Program Files\Apache Group\ Apache2\htdocs



extentions_dir =  C:\PHP\extentions





in the Apache httpd.conf.file



DokumentRoot C:/Program Files/Apache Group/Apache2/htdocs

Directory C:/Program Files/Apache Group/Apache2/htdocs



DirectoryIndex index.html index.html.var index.php



Loadmodule php4_module C:/php/php4apache2.dll

(php4apache2.dll is in the php folder)



.htaccess files  AllowOverride All



ScriptAlias /php/ C:/php/

AddType application/X-httpd-php .php

Action Application/x-httpd-php /php/php.exe



Can any one help me from this night mare?

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



[PHP-DB] PostgreSQL + Cygwin

2004-04-16 Thread Gabriel Gramajo
Alguien ha hecho funcionar PostgreSQL con Cygwin, que error puede ser que me diga que 
gcc no puede generar ejecutables.


Gracias desde ya,

Saludos,

Gabriel.

[PHP-DB] Re: using href=abc.php/?day=......

2003-10-21 Thread Gabriel Peugnet
It's just the syntax:

1. Don't use the / after .php:
a href=abc.php?day=
2. Don't use echo inside the string:
a href='abc.php?day=$start_day'/a
3. Check the use of double and single quotes.

If you use:
echo a href='abc.php?day=$start_day'abc/a;
maybe you will get the link you want.

Gabriel.


MüCella Erdem Efe [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]
 Hi;

 I need to use a href=abc.php/?day=..  /a  statement in a
xxx.php
 file.

 I have to use a php  variable on the right of the day variable  like a
 href=abc.php/?day=+?echo $start_day;? /a.
 When i get this variable in abc.php file

 if (phpversion() = 4.1.0)
  { $vars = array_merge($HTTP_GET_VARS, $HTTP_POST_VARS); }
  else { $vars = $_REQUEST; }
  print_r($vars);

 Output is
 Array ( [day] =(nothing)

 When i use a constant instead of  variable like a
 href=abc.php/?day=12-12-2002/a.
 it works .

 Please help me about using a php variable in a href statement.

 thanks for your attention.

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



[PHP-DB] Re: disable History

2003-10-17 Thread Gabriel Peugnet
Check the Header() function in the manual:

// Tels to the browser the page has caducated and forces to reload..
header(Expires: Mon, 26 Jul 1997 05:00:00 GMT);

// Avoids cahce. It seams it's what you want.
header(Cache-Control: no-cache, must-revalidate);

Gabriel.


Open-Mind [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]
How can I disable the use of History(Temporary Internet Files) in a page ?
(and don't tell me: it's easy: Tools-internet options-settings ...;-) ...
from script (htm ?, js ?, php ?) I want to do this ..)

PS: I have a script witch generate jpegs (cuts from a larger one) and
sometimes in browser I see older pictures ...
If I go to: Tools-internet options-settings- chk for new versions every
visit to the page   everything works just fine

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



Re: [PHP-DB] Help with file upload

2003-10-16 Thread Gabriel Peugnet
For the message:
 Warning: move_uploaded_file(./ayservenet.jpg): failed to open stream:
 Permission denied in /home/ayserve/public_html/fu/fuprocess.php on line 6

you have to change the permissions of the file folder where you are copying
the file.
If you created it via FTP then you can't use copy() or move().

check:
echo fileperms( $folder );
if it's 33188 or 33279 it's ok but I think it is not the permission of your
folder.
I think you'll get 17901 or some other.
so you have to use ftp_chmod() of ftp_site() to change it..

try this:

$folderbase = folderbase; // it's the folder where your folder for
uploads is.
$folder = foldername;// it's your folder for uploads.
$mode = 0777;

$site = ftp_connect ( ftp.yourdomain.com );
if( $site != FALSE ) {

$loged = ftp_login( $site , your username, your password );

if( $loged ) {

ftp_chdir( $site , $folder );
ftp_site( $site , chmod $mode $folder );

}

ftp_quit( $site );


John W. Holmes [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]
 Bunmi Akinmboni wrote:

  Pls Help.
  I have done a lot of reading prior to this yet I just can't seem make it
  work. I wrote an upload program as seen below but the response I got
was:
 
  Possible file upload attack. Filename: ayservenet.jpg Array ( [ufile1]
  = Array ( [name] = ayservenet.jpg [type] = image/pjpeg [tmp_name] =
  /tmp/phpIMEhdh [error] = 0 [size] = 3030 ) )
 [snip]
  if (is_uploaded_file($_FILES['ufile1']['name'])) {
  copy($_FILES['ufile1']['name'], .);
  echo $ufile1_name ;
  echo DONE;
  echo  ;
  print_r($_FILES);
  } else {
  echo Possible file upload attack. Filename:  .
  $_FILES['ufile1']['name'];
  echo  ;
  print_r($_FILES);
  }
  ?

 You should pass $_FILES['ufile1']['tmp_name'] to is_uploaded_file().

 --
 ---John Holmes...

 Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

 php|architect: The Magazine for PHP Professionals – www.phparch.com


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



[PHP-DB] Re: Help with file upload

2003-10-16 Thread Gabriel Peugnet
I made a mistake in my last message:

The lines that say:
ftp_chdir( $site , $folder );
ftp_site( $site , chmod $mode $folder );
should say:
ftp_chdir( $site , $folderbase );// this is the one that
was wrong
ftp_site( $site , chmod $mode $folder );



Bunmi Akinmboni [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]
 Pls Help.
 I have done a lot of reading prior to this yet I just can't seem make it
 work. I wrote an upload program as seen below but the response I got was:

 Possible file upload attack. Filename: ayservenet.jpg Array ( [ufile1]
 = Array ( [name] = ayservenet.jpg [type] = image/pjpeg [tmp_name] =
 /tmp/phpIMEhdh [error] = 0 [size] = 3030 ) )

 My codes are:
 File UPLOAD.HTM:
 html
 head
 titleUntitled Document/title
 meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
 /head

 body
 form method=post action=fuprocess.php enctype=multipart/form-data
 input type=file name=ufile1 size=20
 input type=submit name=submit value=submit
 /form
 /body
 /html

 File FUPROCESS.PHP:
 ?php
 // In PHP earlier then 4.1.0, $HTTP_POST_FILES  should be used instead
 of $_FILES.
 // $realname = $_FILES['ufile1']['name'];

 if (is_uploaded_file($_FILES['ufile1']['name'])) {
  copy($_FILES['ufile1']['name'], .);
 echo $ufile1_name ;
 echo DONE;
 echo  ;
 print_r($_FILES);
 } else {
  echo Possible file upload attack. Filename:  .
 $_FILES['ufile1']['name'];
 echo  ;
 print_r($_FILES);
 }
 ?

 Thanks.
 --
 'Bunmi Akinmboni
 5, Aibu Street, Off Bode Thomas Street,
 P.O. Box 6235, Surulere, Lagos, NIGERIA.
 Tel: (234) 1-813-3335
 Fax: (234) 1-583-2585 (Nigeria Only)
 Fax: 1 (309) 285-2383 (International)
 Email: [EMAIL PROTECTED]
 Web site: http://www.budelak.com
http://www.ayserve.net

 Web Design, Web Hosting, Domain Registration, ICT Consultancy,
 Networking, Internet, eCommerce, System Integrator
 ===

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



[PHP-DB] more about permissions

2003-10-16 Thread Gabriel Peugnet
Have in mind that some permissions can be changed only via FTP but some
other can only be changed useing chmod().

If you want more security you should set the permission in the moment of the
upload and change it again after it.

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



[PHP-DB] Another way.

2003-10-16 Thread Gabriel Peugnet
You can also pass the variable via POST to the script where the function is.
It remains a local variable.

Or you can set it as global like Chris says.

And another way is puting it in a cookie.

Adam Symonds [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]
 Hi,
 I am starting to us functions with my work but I am having troubles
 With the variables in the functions..

 If I have the following function called from my page it will work but the
 variable won't
 ($username)
 but if I put this code straight on the page then it works fine..

 Any reason for the variable not to work in the function but in straight
 coding?
 Thanx



 Sample Function Below:

 ==
 function LoginSystem()
  {
 echo div align=right;
 if ( !isset( $_SESSION['login'] ) ) {

 echo form action=../Users/Login.php method=post;
 echo font size=1Username: /fontinput name=user type=text
 size=10nbsp;font size=1Password: /fontinput name=pass type=password
 size=10nbsp;input type=submit value=GObr;
 echo a href=../Register.phpfont size=1Not A Member
 Yet?/font/font/anbsp;;
 echo /form;

  } else {
 echo font size=1Welcome $username nbsp;nbsp;nbsp;a
 href=../Users/Logout.phpfont
 size=1Logout/anbsp;nbsp;nbsp;/font/fontbrbr;
 }
 echo /div;
  }


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



[PHP-DB] About security.

2003-10-16 Thread Gabriel Peugnet
In your code, where you have:

if (is_uploaded_file($_FILES['ufile1']['name'])) {
 copy($_FILES['ufile1']['name'], .);
...

you should check the extension of the file been uploaded
you should'n accept files with php, cgi, asp, etc., extensions neither an
index file
if you do, some user (hacker) could upload a script and would be inside your
server

then check this:

if (is_uploaded_file($_FILES['ufile1']['name'])) {

if ( the file is not a script  ){
 copy($_FILES['ufile1']['name'], .);

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



[PHP-DB] Sorry, About security is for this discution.

2003-10-16 Thread Gabriel Peugnet
The message About security is for Help with file upload.
I placed the message outside.

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



[PHP-DB] Can't conect with mysql_connect(), please help.

2003-10-14 Thread Gabriel Peugnet
I'm starting to use MySQL, well, trying to, and I get the next message:

Warning: mysql_connect(): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)

The manual says that mysql_connect() can be called without arguments. That's
what I'm doing.

What's wrong?

Thanks,
Gabriel.

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



Re: [PHP-DB] Can't conect with mysql_connect(), please help.

2003-10-14 Thread Gabriel Peugnet
  phpinfo() says:

  MySQL Support enabled

  MYSQL_SOCKET /var/lib/mysql/mysql.sock

but in fact the file /var/lib/mysql/mysql.sock doesn't exists.

So I understand that the first step is to check the configuration of MySQL,
is it?


Dan Brunner [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]
 Hello!!

 Does that file /var/lib/mysql/mysql.sock exist?!!?!?

 Check to make sure mysql is running.



 Dan


 On Oct 14, 2003, at 4:34 PM, [EMAIL PROTECTED] wrote:

  I'm starting to use MySQL, well, trying to, and I get the next message:
 
  Warning: mysql_connect(): Can't connect to local MySQL server through
  socket
  '/var/lib/mysql/mysql.sock' (2)
 
  The manual says that mysql_connect() can be called without arguments.
  That's
  what I'm doing.
 
  What's wrong?
 
  Thanks,
  Gabriel.
 
  --
  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] Can't conect with mysql_connect(), please help.

2003-10-14 Thread Gabriel Peugnet
My site is hosted in a remote server.
I can't find /etc/init.d/mysqld
/etc does exists but /etc/init.d doesn't

What I found is
/usr/bin/msql2mysql
/usr/bin/mysql_config
/usr/bin/mysql
/usr/bin/mysql_install_db
/usr/bin/mysql_find_rows
...
and a lot of files like /usr/bin/mysql

The one that seems to be useful is
/usr/lib/php4/mysql.so
it's the socket, isn't?

I guess that running /etc/init.d/mysqld start is kind of command line
executing
So, how can I start mysql from inside a php script?

Thanks again.
Gabriel.


Joe Nilson Zegarra Galvez [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]
 You must start your mysql server :

 do it:

 /etc/init.d/mysqld start

 and when you read the line

 mysql start [OK]

 your problem will be fix ;)

 Regards

 Nilson

 Gabriel Peugnet dijo:
phpinfo() says:
 
MySQL Support enabled
 
MYSQL_SOCKET /var/lib/mysql/mysql.sock
 
  but in fact the file /var/lib/mysql/mysql.sock doesn't exists.
 
  So I understand that the first step is to check the configuration of
  MySQL,
  is it?
 
 
  Dan Brunner [EMAIL PROTECTED] escribió en el mensaje
  news:[EMAIL PROTECTED]
  Hello!!
 
  Does that file /var/lib/mysql/mysql.sock exist?!!?!?
 
  Check to make sure mysql is running.
 
 
 
  Dan
 
 
  On Oct 14, 2003, at 4:34 PM, [EMAIL PROTECTED] wrote:
 
   I'm starting to use MySQL, well, trying to, and I get the next
  message:
  
   Warning: mysql_connect(): Can't connect to local MySQL server through
   socket
   '/var/lib/mysql/mysql.sock' (2)
  
   The manual says that mysql_connect() can be called without arguments.
   That's
   what I'm doing.
  
   What's wrong?
  
   Thanks,
   Gabriel.
  
   --
   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
 


 -
 Joe Nilson Zegarra Galvez
Sistemas Kola Real
  Telefax : 0051-54-256658
   Movil: 0051-54-9603244

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



[PHP-DB] Re: Parse Errors...

2003-10-12 Thread Gabriel Peugnet
Some times parse errors aren't in the line the interpreter says.
Looking at the code you sent I don't see the error but if your original code
is in a biger file try looking if the brackets {} or parenthesis of all the
code are balanced.


Scott V Nipp [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]
om...
 I keep receiving a parse error every time I try and view the page I
 am working on.  I am developing this very simple application in
DreamWeaver
 MX 2004.  Here are lines 3-16:

 ?php
 mysql_select_db($database_Prod, $Prod);
 $query_Host = SELECT Name FROM systems;
 $Host = mysql_query($query_Host, $Prod) or die(mysql_error());
 $row_Host = mysql_fetch_assoc($Host);
 $totalRows_Host = mysql_num_rows($Host);

 mysql_select_db($database_ProdUsers, $ProdUsers);
 $query_UserMod = SELECT shell, home_dir FROM modification;
 $UserMod = mysql_query($query_UserMod, $ProdUsers) or die(mysql_error());
 $row_UserMod = mysql_fetch_assoc($UserMod);
 $totalRows_UserMod = mysql_num_rows($UserMod);

 ?

 I am simply attempting to pull data from two separate tables in two
 separate databases.  Every time I try to view my work, I am getting a
parse
 error on the 'mysql_select_db($database_ProdUsers, $ProdUsers);'
regardless
 of whether this is the first or second mysql_select_db.  I imagine that I
am
 simply doing something obviously wrong here.  Please help.  Thanks.


 Scott Nipp
 Phone:  (214) 858-1289
 E-mail:  [EMAIL PROTECTED]
 Web:  http:\\ldsa.sbcld.sbc.com

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



[PHP-DB] Re: Parse Errors...

2003-10-12 Thread Gabriel Peugnet
I just sent you an email that was rejected.
Recipient address: [EMAIL PROTECTED]
  Reason: Server rejected MAIL FROM address.
  Diagnostic code: smtp;550 5.0.0 Access Denied for prodigy.net.mx

So here is the message:

For sending numbers with format I prefer the number_format() function.

Instead of these two lines:
$formatted = sprintf(%01.2f, $money);
echo $formatted;
I'd use only one line:
echo number_format( $money, 2 );
The output would be:
123.10

I'm sorry I can't help about the format %01 I'm not familiar with it.

Gabriel.


Scott V Nipp [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]
om...
 I keep receiving a parse error every time I try and view the page I
 am working on.  I am developing this very simple application in
DreamWeaver
 MX 2004.  Here are lines 3-16:

 ?php
 mysql_select_db($database_Prod, $Prod);
 $query_Host = SELECT Name FROM systems;
 $Host = mysql_query($query_Host, $Prod) or die(mysql_error());
 $row_Host = mysql_fetch_assoc($Host);
 $totalRows_Host = mysql_num_rows($Host);

 mysql_select_db($database_ProdUsers, $ProdUsers);
 $query_UserMod = SELECT shell, home_dir FROM modification;
 $UserMod = mysql_query($query_UserMod, $ProdUsers) or die(mysql_error());
 $row_UserMod = mysql_fetch_assoc($UserMod);
 $totalRows_UserMod = mysql_num_rows($UserMod);

 ?

 I am simply attempting to pull data from two separate tables in two
 separate databases.  Every time I try to view my work, I am getting a
parse
 error on the 'mysql_select_db($database_ProdUsers, $ProdUsers);'
regardless
 of whether this is the first or second mysql_select_db.  I imagine that I
am
 simply doing something obviously wrong here.  Please help.  Thanks.


 Scott Nipp
 Phone:  (214) 858-1289
 E-mail:  [EMAIL PROTECTED]
 Web:  http:\\ldsa.sbcld.sbc.com

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



[PHP-DB] Re: set password on a page

2003-09-21 Thread Gabriel Peugnet
Use setCookie()  function. It places a global variable on the client that
your programs can verify after. See the manual for the use of the function.
Here is an example:

// Example of file chkacces.php.
?php

$pass = $_POST['password'];// It receives the password from a FORM
with POST method.

if( ($pass != xyz ){// where xyz is the right password.
echo You are not autorized to see this page;
return;
}

// Autorized.
setCookie( $USER, autorized );

header( Location: index.php );// redirects to index.php

?

Example for your index.php file:

?php

if( ($USER != autorized ){
echo You are not autorized to see this page;
return;
}

// Here goes the code for autorized users.

?

The variable set with setCookie() is not availabe until the script ends. See
details in the manual.
The manual is available in www.php.org

Sagerat [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]
 How do I set up password on a page so that only restricted people can open
 it?

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



[PHP-DB] Re: best upload method

2003-09-21 Thread Gabriel Peugnet
I use file upload, it's faster than ftp because the ftp conection and login
process takes a few seconds.

You have to see that the permissions in each method are diferent. Some times
you cannot delete a file copied with ftp useing the unlink() function unless
you change the chmod. If you used the upload method you can use unlink() but
not ftp_delete().

It has solutions but with a little of complexity. That's why I recomend the
upload method and the functions copy() and unlink() for moveing and deleting
files. You can use also the chmod() function with this method to change
permissions.


Open-Mind [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]
 which is the best upload file method ?
 file uploads or FTP commands from PHP

 thanks

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



[PHP-DB] Re: set password on a page

2003-09-21 Thread Gabriel Peugnet
In my last replay I told you to find the manual in the wrong place.

The right place is www.php.net


Sagerat [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]
 How do I set up password on a page so that only restricted people can open
 it?

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



[PHP-DB] Re: tutorial

2003-09-21 Thread Gabriel Peugnet
Go to www.php.net, in the section Documentation you'll find manuals in
several languages.


Novianto Dwiatmojo [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]

 Hi everyone

 i'm a newbie in php, mysql and linux but i want to learn about it can you
 guys help me or give me referal to any tutorial links.
 thank you for your kindness.

 thanks :P

 sorry for my english :- [

 _
 STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
 http://join.msn.com/?page=features/junkmail

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



[PHP-DB]php-odbc-ctree

2003-05-27 Thread Gabriel Gramajo
Does anybody knows any kind of odbc for c-tree´s databases in linux ?

Thanks in advance,

Gabriel.


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



[PHP-DB] C-Tree And PHP

2003-03-20 Thread Gabriel Gramajo
Hi all,

Anyone has interact with c-tree databases using php.

Where can i found help about it?

Thanks in advance,

Gabriel.

[PHP-DB] How can i upload files

2003-02-13 Thread Gabriel Gramajo
Hi All,
Can anyone tell me how can i select and upload files using php.

 Thanks in advance,

Gabriel,

- Original Message -
From: Clarkson, Nick [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 13, 2003 10:59 AM
Subject: RE: [PHP-DB] MySQL problem -- new to PHP



 Looks like is to do with MySQL permissions. Check your host's (the one you
 are trying to connect from) permissions to the server.

 To change permissions, from the MySQL prompt type;

 GRANT ALL ON * TO username@host IDENTIFIED BY password;

 Substitute in username, host and password for your ones.

 Easier to use PHPMyAdmin or SQLYog (www.sqlyog.com) if you're new to it.
I'm
 pretty new, so learning all the time.

 A couple of links to get you started;
 http://www.mysql.com/doc/en/GRANT.html
 http://www.mysql.com/doc/en/GRANT.html

 Good luck,

 Nick



 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: 13 February 2003 13:20
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] MySQL problem -- new to PHP


 Hi all

 I am new to PHP (just basically started yesterday). I am currently having
a
 problem connecting to a MySQL database.

 My sample code is:

 --
 ?php
 mysql_connect(localhost,username,password) or die (Unable to connect
to
 MySQL server.);
 $db = mysql_select_db(DB_NAME) or die (Unable to select requested
 database.);
 ?
 ---

 This throws the following error:

 ---
 Warning: MySQL Connection Failed: Host 'my.host.name' is not allowed to
 connect to this MySQL server
 ---

 Now, the mySQL server and the web server reside on the same machine. This
 warning is therefore saying that this machine does not have permission to
 connect to itself. Hmm. I have put entries in the host table and the user
 table, using both hostname and ip address, but no luck. I keep getting the
 same error.

 What am I doing wrong?

 Any and all help appreciated.

 Thanks

 Evan Morris
 [EMAIL PROTECTED]
 +27 11 792 2777 (tel)
 +27 11 792 2711 (fax)



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


 This private and confidential e-mail has been sent to you by Egg.
 The Egg group of companies includes Egg Banking plc
 (registered no. 2999842), Egg Financial Products Ltd (registered
 no. 3319027) and Egg Investments Ltd (registered no. 3403963) which
 carries out investment business on behalf of Egg and is regulated
 by the Financial Services Authority.
 Registered in England and Wales. Registered offices: 1 Waterhouse Square,
 138-142 Holborn, London EC1N 2NA.
 If you are not the intended recipient of this e-mail and have
 received it in error, please notify the sender by replying with
 'received in error' as the subject and then delete it from your
 mailbox.


 --
 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] Re: [PHP-DEV] [CROSS POST] PHP Meetup Texas PHP Users

2002-07-30 Thread Gabriel Ricard

Jay Blanchard wrote:
 Howdy all!
 
 Just wanted to remind everyone that sign-up for the PHP Meetup is still in
 progress at http://php.meetup.com . At latest count there are 289 folks
 signed up world-wide with the top 10 cities being;
 
 Washington DC (9 members)
 Toronto (9 members)
 Leeds, UK (8 members)
 London, England (8 members)
 Amsterdam (7 members)
 Melbourne (6 members)
 Atlanta (5 members)
 Oakland-Alameda, CA (5 members)
 Manhattan (below 42nd St) (5 members)
 Montréal (4 members)
 
 Why do something like this? Meet other developers, networking (you can never
 tell when you're going to need another pair of hands for a project),
 networking (you can never tell when someone is going to need to hire extra
 hands for a project), and networking (you get the idea). Sign up soon! There
 are thousands of PHP folks out there, spread the word.
 

First of all, sorry for the additional cross post. MeetUp.com lacks the 
ability to let you contact other folks who have signed up. In my general 
area, Massachusetts, there are a bunch of tiny groups scattered about, 
and I'd like a chance to get all of them to converge in one place to 
make the meetup worth it for all of us. I know there's only a few days 
before the meetup is to take place, but if folks from the following 
areas could email me, then we can try and work out somewhere we can all 
meet, instead of there being 5 groups of 2 or 3 people.


Boston, Ma
Hyannis, Ma
North Boston Suburbs
Springfield, Ma
Manchester, NH

(heck, even people in RI and CT who don't mind driving)

Meetup.com cancels meetups for groups less than 5 also, so I'd like to 
see if we can just get one or two big groups.

Also, anyone else in this area... I've been looking for user groups in 
the Massachusetts area, and the only one that did exist, was PHPUG New 
England, which doesn't seem to exist anymore. Anyone interested in 
getting one going around here?


Again, sorry for the cross post.

-- 
Gabriel Ricard
[EMAIL PROTECTED]


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




Re: [PHP-DB] Moving from MySQL to MSSQL Server 2000

2002-01-15 Thread Gabriel Ricard

Sorry for the late reply to this, but if you were to move to MS SQL I'd 
highly recommend using FreeTDS (www.freetds.org) to access the database 
from PHP. Due to the lack of an MS SQL client library in Mac OS X I have 
to use FreeTDS to contact another MS SQL server ( I use MySQL myself ). 
Setup was very easy, you just build FreeTDS and then configure PHP using 
--with-sybase-ct=/path/to/freetds. Then you can use the mssql_* group of 
functions to access the database.

Or you could use ODBC... but I was never able to get that to work 
correctly, and the general consensus seems to be that ODBC is slow.

On Saturday, January 12, 2002, at 03:24 PM, Boaz Yahav wrote:

 Hi

 I'm planning to move my site (Very successful / high traffic Auctions
 site) from MySQL to MSSQL Server 2000.
 I was wondering if anyone has done this move and if there are any pit
 falls to notice.

 1. Is ODBC the only way to work from a Solaris / Apache / PHP 4 machine
 to a Win2K / SQL Server 2000?
 2. What could be the performance cost (if any).
 3. Are there any special points that need to be taken into consideration
 on either side?


-- 
PHP Database 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-DB] Use of Like

2001-07-09 Thread Gabriel

Can anyone tell me a way to simulate the command LIKE in mySQL query´s,

Thanks in advance,

Gabriel.




--
PHP Database 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-DB] Filling mysql db with access db

2001-05-16 Thread Gabriel

How can i import data from an access database to a mysql db.

Thanks in advance,

Gabriel.




[PHP-DB] Fwd: URGENT : How can i generate scripts of database

2001-05-08 Thread Gabriel

Anyone can tell me how can i generate the scripts of my database to create it in 
another mysql server.
Or better wich other ways i´ve to do it.

Thanks in advance,

Gabriel.




[PHP-DB] Method POST not allowed

2001-04-04 Thread Gabriel




Someone can tell me how can i resolve the problem in the subject i ve a form with a 
peace of code in php calling a mysql db,
when i press submit the apache server returns me that error:

450 Method not allowed
The requested method is not allowed to this URL


Ill appreciate any kind of help,

Thanks in advance,

Gabriel.

*** END FORWARDED MESSAGE  ***


--
PHP Database 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-DB] SSI and PHP?

2001-03-10 Thread Fernando Gabriel Ranea

Dear Dan,

Yes, you can! In PHP you must use:

?
include("filename")
?

or

?
require("filename")
?


Include evaluates andd executes the code in the external. And replace just
replaces the contents of the file.
Regards,

Dan Eskildsen wrote:

 Hi there,

 Can anyone tell me if it is possible to combine Server Side Includes with
 PHP?  If not, is there a work around?

 Please cc your comments to [EMAIL PROTECTED]

 I would like everyone who commented on my queries the last couple of days.
 I went from not knowing a single thing about PHP and MySQL to a day later
 having already programmed a small application that will display newspaper
 articles.

 Thanks!

 Dan

 --
 PHP Database 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 Database 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-DB] i need help with odbc!

2001-01-29 Thread Angel2 Gabriel Lena Valega
 Emanuel.exe