php-windows Digest 1 Jul 2003 00:13:30 -0000 Issue 1802
Topics (messages 20625 through 20634):
A simple test file duplicated in 2 directories, behaving differently!
20625 by: P
Problem with Insert with ODBC
20626 by: Veselina Jecheva
20627 by: Svensson, B.A.T. (HKG)
Connecting PHP to Jetty...
20628 by: Rodrigo Reyes
php-cli.exe with ?variable=blah
20629 by: Tommy Le
SQLyog 3.51 Released
20630 by: Karam Chand
20631 by: Stephen
Re: authenticating with SQL Server 2000
20632 by: Micah Montoya
Using ODBC in PHP to connect to a sql server
20633 by: Harpreet
web will not SUB, so I will try here
20634 by: phpWalter
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
A simple test file duplicated in 2 directories, behaving differently!
A simple test file with the php command
<?php echo 'hi how are you'; ?>
and nothing else
is placed in two subdirectories of the MyWebs folder which has been set as
localhost and Document root for the apache server .
It works in one as expected but not in the other, any ideas.
If using the ME file explore;
When looking on the file from listing in http://localhost/dir1
it shows the link in purple as though visited and opens correctly in the
right hand browse window.
When looking at the link in http://localhost/dir2
it shows the link in green and opens a second internet exporer page. if I
include the file name it displays and works normally opening the file in the
right hand window.
If I use IE to start navigating from the localhost both directories works
normally.
The reason for this test file in the first place is that php, echo and
print, is not working as expected in files from the dir2 there is no output!
Anyone please!!
--- End Message ---
--- Begin Message ---
Hello,
I've got the following problem: the following line prints "Error" all the
time:
$link = odbc_connect("conference","","");
$query="insert into participants (name, surname, family, degree,
work_place, speaker, listener, topic, title,
co_author, aspekt, comp, proektor, video, date15, date16, date17,
fee)
values ('$name', '$surname', '$family', '$degree', '$work_place',
'$speaker', '$listener', '$topic', '$title',
'$co_author', '$asp', '$computer', '$proekt', '$video', '$date15',
'$date16', '$date17', '$fee')";
$result=odbc_exec($link,$query);
if ($result) echo "Thank you, your request has been processed.";
else echo "Error";
The database is created by Access, all variables are defined and have their
values. It seems the SQL statement is not ok.
Thank's in advance.
Veselina
--- End Message ---
--- Begin Message ---
You ought to test for an error in your "error detection"
not for an return value on the execute of an SQL query.
> -----Original Message-----
> From: Veselina Jecheva [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 30, 2003 3:19 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] Problem with Insert with ODBC
>
>
> Hello,
> I've got the following problem: the following line prints "Error" all the
> time:
>
> $link = odbc_connect("conference","","");
> $query="insert into participants (name, surname, family, degree,
> work_place, speaker, listener, topic, title,
> co_author, aspekt, comp, proektor, video, date15, date16, date17,
> fee)
> values ('$name', '$surname', '$family', '$degree', '$work_place',
> '$speaker', '$listener', '$topic', '$title',
> '$co_author', '$asp', '$computer', '$proekt', '$video', '$date15',
> '$date16', '$date17', '$fee')";
> $result=odbc_exec($link,$query);
> if ($result) echo "Thank you, your request has been processed.";
> else echo "Error";
>
> The database is created by Access, all variables are defined and have their
> values. It seems the SQL statement is not ok.
> Thank's in advance.
> Veselina
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
Hi all
Has someone been able to have PHP connected to Jetty? Thanx...
Rodrigo
--- End Message ---
--- Begin Message ---
What is the command line for running php.exe with like this..
page.php?filterid=blah&sname=3
i want to include filterid=blah&sname=3 but it doesn't work for windows.
and one more question
Do i have to use php-cli.exe instead of php.exe? I'm using PHP 4.2.3
I'm doing this for Window Scheduled Task.
Regards,
Tommy
--- End Message ---
--- Begin Message ---
SQLyog v3.51 - The definitive Windows Front End for
MySQL, has been released.
SQLyog is a superfast, compact and easy to use Front
End for MySQL.
Some of the new features added in SQLyog 3.51 are -
-- Complete support for MySQL 4.1.
-- Improved SQL Editor.
-- Improved ODBC Import Tool.
-- BLOB data does not require double click for viewing
if the data is < 255 bytes.
-- More compact and optimized executable ( 480 KB ).
-- Lot of bugfixes and enhancements.
SQLyog 3.51 is available at an Introductory price of
$49.
You can download a full featured Trial version of
SQLyog at http://www.webyog.com/sqlyog/download.html
Regards
Karam
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--- End Message ---
--- Begin Message ---
Interesting idea, but do you think many people will pay the money when they
is already a high quality php - mysql interface available (phpMyAdmin).
http://www.phpmyadmin.net/
Stephen
----- Original Message -----
From: "Karam Chand" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 30, 2003 6:16 PM
Subject: [PHP-WIN] SQLyog 3.51 Released
> SQLyog v3.51 - The definitive Windows Front End for
> MySQL, has been released.
>
> SQLyog is a superfast, compact and easy to use Front
> End for MySQL.
>
> Some of the new features added in SQLyog 3.51 are -
>
> -- Complete support for MySQL 4.1.
> -- Improved SQL Editor.
> -- Improved ODBC Import Tool.
> -- BLOB data does not require double click for viewing
> if the data is < 255 bytes.
> -- More compact and optimized executable ( 480 KB ).
> -- Lot of bugfixes and enhancements.
>
> SQLyog 3.51 is available at an Introductory price of
> $49.
>
> You can download a full featured Trial version of
> SQLyog at http://www.webyog.com/sqlyog/download.html
>
> Regards
> Karam
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
Want to thank everyone for there comments. I was able to get it connected.
Now it looks as if I have some syntax errors to work out. No biggy though.
Again, thanks for all your help.
----- Original Message -----
From: "Frank M. Kromann" <[EMAIL PROTECTED]>
To: "Micah Montoy" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, June 30, 2003 12:31 AM
Subject: Re: [PHP-WIN] authenticating with SQL Server 2000
> Hi,
>
> If you remove the @ in front of the mssql_* functions you might get a bit
> more information about the problem.
>
> Using the MSSQL Server extension requires these stapes:
>
> 1) Install the SQL Server Client tools on the maschine running PHP (if
> your are using Win32)
> 2) Configure a server alias using the client network utility. The alias
> specifies name, host name, protocol and port numbers used for the db
> communication.
> 3) Connect to the database using the alias as db name as first parameter
> in mssql_connect.
> 4) If the SQL Server is configured for trusted connections only, enable
> this in PHP.INI by setting mssql.secure_connection = On (no need for
> userid and password then)
>
> If you are connection from a *nix box. You need to compile and install
> FreeTDS and recompile php using the --with-mssql configure option.
>
> There is no need to create any ODBC configurations to use the mssql_*
> functions
>
> - Frank
>
> > I'm in the process of learning PHP. I've gotten to the point of having
> > problems with accessing a database. What is happening is that I am
> getting
> > the message "Couldn't connect to SQL Server on BOBOS" (the name of the
> > server). I've tried putting in a user but with the same results. Now,
> I'm
> > wondering if there is some setting in the php.ini file that I missed.
> I
> > specified in the php.ini file to use the sql server extension and it
> > compiles without error. Here is the code.
> >
> > <?php
> > $myServer = "BOBOS";
> > $myUser = "Bobo the Bugbear";
> > $myPass = ""; //password not required
> > $myDB = "picture_DB";
> >
> > $server = @mssql_connect($myServer, $myUser, $myPass)
> > or die("Couldn't connect to SQL Server on $myServer");
> >
> > $database = @mssql_select_db($myDB)
> > or die("Couldn't open database $myDB");
> >
> > $result = mssql_query("SELECT * FROM category",$database);
> > printf ("Category: %s<br>n", mssql_result($result,0,"name"));
> > while($row = mssql_fetch_row($result))
> >
> > {
> > echo "<li>" . $row[0] . "</li>";
> > }
> > ?>
> >
> > What might I be missing? I already specified the database in the ODBC
> > connection part of windows. Wasn't sure if this was needed or not but
> did
> > it anyway. Anyway, if you could send me a note on what it is I might
> be
> > missing, I would greatly appreciate it.
> >
> > thanks
> >
> >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
>
>
--- End Message ---
--- Begin Message ---
Does anyone know of a nice artical that explains how I connect to a sql
server using odbc connection in my PHP pages.
I use mssql_connect right now and it works fine. I would like to use odbc
instead to connect.
Any help is appreciated.
Thanks,
Regards,
Harpreet Kaur
--- End Message ---
--- Begin Message ---
It seems the web page is not letting me subscribe, so I figured I'd try this
route.
phpWalter
--- End Message ---
