as you can see the one $host is for me loacl pc and the other for the
server.

<?php
//$host = 'localhost:c:/apache/htdocs/site/SERVER.GDB';
$host = 'localhost:c:/InetPub/wwwroot/SERVER.GDB';
$username = 'SYSDBA';
$password = 'masterkey';
$dbh = ibase_connect($host, $username, $password) or die
('<b>Error:</b> '.ibase_errmsg());


--- In firebird-php@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> I can't see the format of you $host string and you have commented

out what

> looks lie the beginning of a tcp connection string. So show me the

path or a

> made up one if you're paranoid
> Alan
> -----Original Message-----
> From: jason_panzera [mailto:jason@i...]
> Sent: Saturday, November 20, 2004 11:39 PM
> To: firebird-php@yahoogroups.com
> Subject: [firebird-php] Re: PLZ HELP - I am lost
>
>
>
>
> The conn is right, as I can login and my other functions work
>
> <?php
> $host = '***************************************';
> //$host = 'localhost:************************;
> $username = '************';
> $password = '***********';
> $dbh = ibase_connect($host, $username, $password) or die
> ('<b>Error:</b> '.ibase_errmsg());
>
>
>
> // error handler function
> //function myErrorHandler ($errno, $errstr, $errfile, $errline)
> //{
> // $f = fopen('log.txt', 'a+');
> // fputs($f, "$errno :: $errstr : $errfile : $errline\n\r");
> // fclose($f);
> //}
>
> //set_error_handler("myErrorHandler");
> // run query and log if raise exception
> /*
> function query($dbh, $query){
> $result = ibase_query($dbh, $query);
> if(ibase_errmsg() != ''){
> echo('<hr>'.$query.'<br><b>Error: '.ibase_errmsg
> ().'</b><hr>');
> }
> return $result;
> }
> */
> // function return combobox from table with selected item
> // TEST: echo get_combo('SELECT * FROM

V_CATERING', 'CATERING', 'Self-

> catering');
> function get_combo($sql, $f_name, $selected, $f_key = '',

$name='')

> {
> global $dbh;
> if($f_key == ''){
> $f_key = $f_name;
> }
>
> if ($name != '') {
> $out = '<SELECT class="body" name="' . $name . '" type=>';
> }else{
> $out = '<SELECT class="body" name="' . $f_name . '"
> type=>';
> }
>
> $result = ibase_query($sql);
> if ($row = ibase_fetch_assoc($result)) {
> do {
> if ($row[$f_key] == $selected) {
> $out .= '<OPTION value="'.$row[$f_key].'"
> selected>' . $row[$f_name] . '</OPTION>';
> } else {
> $out .= '<OPTION value="'.$row[$f_key].'">' . $row
> [$f_name] . '</OPTION>';
> }
> } while ($row = ibase_fetch_assoc($result));
> }
> $out .= '</SELECT>';
> return $out;
> }
>
> function get_y_n($val){
> if($val == strtoupper('Y')){
> return '<OPTION value="Y" selected>Yes<OPTION
> value="N">No';
> }else {
> return '<OPTION value="Y">Yes<OPTION value="N"
> selected>No';
> }
> }
>
> ?>
>
> --- In firebird-php@yahoogroups.com, "Alan McDonald" <alan@m...>
> wrote:
> > can we see dbcon.php
> > Alan
> > -----Original Message-----
> > From: jason_panzera [mailto:jason@i...]
> > Sent: Saturday, November 20, 2004 10:26 PM
> > To: firebird-php@yahoogroups.com
> > Subject: [firebird-php] PLZ HELP - I am lost
> >
> >
> >
> >
> > Hay there,
> >
> > I have a problem, this form works perfectly well on two local
> > machines, but on the server it only allows 1 person to signup

and

> > then I have to restart IIS so another user can register. I

can't

> see
> > the prob here or on the server. PLZ HELP
> >
> > Jason
> >
> > <?php
> > session_start();
> > require_once 'dbcon.php';
> > $registered=0;
> > if ($_POST['submit']=='Register'){
> > $query = "SELECT * from MEMBERS where EMAIL='".$_POST
> > ['EMAIL']."'";
> > $result = ibase_query($dbh, $query);
> > $row = ibase_fetch_assoc($result);
> > $email_exist = 0;
> > if ($row[EMAIL] == $_POST['EMAIL']) $email_exist =
> > 1;
> > if ($email_exist == 0){
> >
> > if(($_POST['WEBPASSWORD'] != ($_POST['WEBPASSWORD_again']))
> > || $_POST['WEBPASSWORD'] == ''){
> > $msg = '<span class="sub_heading"><font
> > color=red>Incorrect passord</font></span><br><br>';
> > } else {
> > /*
> > //strip tags before enter data in db
> > $_POST[VENUE] = addslashes(htmlspecialchars($_POST
> > [VENUE]));
> > $_POST[SURNAME] = addslashes(htmlspecialchars($_POST
> > [SURNAME]));
> > $_POST[NAME] = addslashes(htmlspecialchars($_POST
> > [NAME]));
> > $_POST[TELH] = addslashes(htmlspecialchars($_POST
> > [TELH]));
> > $_POST[CEL] = addslashes(htmlspecialchars($_POST
> > [CEL]));
> > $_POST[FAX] = addslashes(htmlspecialchars($_POST
> > [FAX]));
> > $_POST[EMAIL] = addslashes(htmlspecialchars($_POST
> > [EMAIL]));
> > $_POST[ADDRESS1] = addslashes(htmlspecialchars($_POST
> > [ADDRESS1]));
> > $_POST[ADDRESS2] = addslashes(htmlspecialchars($_POST
> > [ADDRESS2]));
> > $_POST[ADDRESS3] = addslashes(htmlspecialchars($_POST
> > [ADDRESS3]));
> > $_POST[ADDRESS4] = addslashes(htmlspecialchars($_POST
> > [ADDRESS4]));
> > $_POST[POSTAL1] = addslashes(htmlspecialchars($_POST
> > [POSTAL1]));
> > $_POST[POSTAL2] = addslashes(htmlspecialchars($_POST
> > [POSTAL2]));
> > $_POST[POSTAL3] = addslashes(htmlspecialchars($_POST
> > [POSTAL3]));
> > $_POST[POSTAL4] = addslashes(htmlspecialchars($_POST
> > [POSTAL4]));
> >
> >
> > $_POST[ID] = addslashes(htmlspecialchars($_POST[ID]));
> > $_POST[OCCUPATION] = addslashes(htmlspecialchars
> > ($_POST[OCCUPATION]));
> > $_POST[TELW] = addslashes(htmlspecialchars($_POST
> > [TELW]));
> > $_POST[BANKNAME] = addslashes(htmlspecialchars($_POST
> > [BANKNAME]));
> > $_POST[BRANCHNAME] = addslashes(htmlspecialchars
> > ($_POST[BRANCHNAME]));
> > $_POST[BRANCHCODE] = addslashes(htmlspecialchars
> > ($_POST[BRANCHCODE]));
> > $_POST[BANKACCOUNT] = addslashes(htmlspecialchars
> > ($_POST[BANKACCOUNT]));
> > $_POST[ACCOUNTHOLDER] = addslashes(htmlspecialchars
> > ($_POST[ACCOUNTHOLDER]));
> > $_POST[ACCOUNTTYPE] = addslashes(htmlspecialchars
> > ($_POST[ACCOUNTTYPE]));
> >
> >
> > $_POST[DIRECTIONS] = addslashes(htmlspecialchars
> > ($_POST[DIRECTIONS]));
> > */
> > $query = 'SELECT * from MEMBERS order by LINK desc';
> > $result = ibase_query($dbh, $query);
> > $row = ibase_fetch_assoc($result);
> > $link_no = $row[LINK];
> > $link_no++;
> >
> > $query = "INSERT INTO MEMBERS
> > (LINK,SURNAME,NAME,TELH,CEL,FAX,EMAIL,ADDRESS1, ADDRESS2,
> > ADDRESS3,ADDRESS4,ADDRESS5,";
> >
> > $query .= "POSTAL1,POSTAL2,POSTAL3,POSTAL4,MEMBERSHIPID,WEBPAS
> > SWORD,VENUENAME) VALUES (".$link_no.",'".ucwords(substr($_POST
> > ['SURNAME'], 0, 30));
> > $query .= "', '".ucwords(substr($_POST['NAME'], 0,
> > 30))."', '".substr($_POST['TELH'], 0, 30)."', '".substr($_POST
> > ['CEL'], 0, 30);
> > $query .= "', '".substr($_POST['FAX'], 0,
> > 30)."', '".strtolower(substr($_POST['EMAIL'], 0,

36))."','".substr

> > ($_POST['ADDRESS1'], 0, 30);
> > $query .= "', '".substr($_POST['ADDRESS2'], 0,
> > 30)."', '".substr($_POST['ADDRESS3'], 0, 30)."','".substr

($_POST

> > ['ADDRESS4'], 0, 30);
> > $query .= "', '".substr($_POST['ADDRESS5'], 0,
> > 30)."', '".substr($_POST['POSTAL1'], 0, 20)."', '".substr

($_POST

> > ['POSTAL2'], 0, 20);
> > $query .= "', '".substr($_POST['POSTAL3'], 0,
> > 20)."', '".substr($_POST['POSTAL4'], 0, 20)."', '".substr

($_POST

> > ['MEMBERSHIPID'], 0, 30)."', '".strtolower(substr($_POST
> > ['WEBPASSWORD'], 0, 20))."','".substr($_POST['VENUE'], 0,
> 30)."')";
> >
> > //echo $query;
> > $result=ibase_query($dbh, $query) or
> > die('Database error. Please contact
> > Administrator');
> > //if (!mail("nedeljko@f...", "My
> > Subject", "this is just test email\n")) echo error;
> >
> > $message = '
> > <html>
> > <head>
> > <title>Wildfly - Confirm of
> > membership</title>
> > </head>
> > <body>
> > <br><strong>Welcome to
> > Wildfly</strong>
> > <br>
> > <br>You are now a registered member
> > of the Wildfly community, which depending on
> > <br>what membership you have
> > selected, will give you access to a wide range of different
> benefits.
> > <br>
> > <br>
> > <br><strong>Your Registrations
> > Detials:</strong>
> > <br> Email Address: '.$_POST
> > ['EMAIL'].'
> > <br> Password: '.$_POST
> > ['WEBPASSWORD'].'
> > <br>
> > <br>
> > <br>We hope you enjoy everything that
> > WildFly has to offer and should you have
> > <br>any questions or need anything in
> > the world of fly fishing, please do not
> > <br>hesitate to contact us.
> > <br>
> > <br>Please Do not reply to this email!
> > <br>
> > <br>
> > <br>Regards,
> > <br>Wildfly
> > <br>
> > <br>www.wildfly.co.za
> > <br>Tel (033) 2666981
> > <br>Fax (033) 2666981
> > <br>Email: reservations@w...
> > </body>
> > </html>';
> >
> > $emailfrom
> > = 'admin@w...';
> > $emailto = $_POST
> > ['EMAIL'].',gareth@w...,jason@w...';
> > $subject = 'Wildfly -
> > Confirmation of membership';
> >
> > $headers = "MIME-Version: 1.0
> > \r\n";
> > $headers .= "Content-type:
> > text/html; charset=iso-8859-1\r\n";
> >
> > // additional headers
> > $headers .= "To:
> > $emailto\r\n";
> > $headers .= "From:
> > $emailfrom\r\n";
> > $headers .= "Cc:\r\n";
> > $headers .= "Bcc:\r\n";
> > // and now mail it
> >
> > $query = "select * from
> > members where ((EMAIL='" . $_POST['EMAIL'] . "') or

(EMAIL='" .

> > strtoupper($_POST['EMAIL']) . "')) and WEBPASSWORD='" . $_POST
> > ['WEBPASSWORD'] . "'";
> > $result = ibase_query
> > ($dbh, "select * from members where ((EMAIL='" . $_POST
> > ['EMAIL'] . "') or (EMAIL='" . strtoupper($_POST

['EMAIL']) . "'))

> and
> > WEBPASSWORD='" . $_POST['WEBPASSWORD'] . "'");
> > if ($row = ibase_fetch_assoc
> > ($result)) {
> > session_register('login');
> > session_register
> > ('member_id');
> > $_SESSION['login'] = $row
> > ['MEMBERSHIPID'];
> > $_SESSION['member_id'] = $row
> > ['LINK'];
> >
> > mail($emailto, $subject,
> > $message, $headers);
> > session_write_close();
> > ibase_close($dbh);
> > if ($row['MEMBERSHIPID']
> > =="Fly Fisher") header("Location: club_rulesb.php");
> > else header("Location:
> > myadminvenue.php");
> > }else {
> > // not send email and
> > password
> > header('Location: join.php');
> > }
> > }
> > }
> > $registered = 1;
> > }
> > include('header.php');
> > ?>
> > <script src="js/check.js" type="text/javascript"></script>
> > <script Language="JavaScript">
> > function validateForm(theForm)
> > {
> > if (!validRequired(theForm.NAME,"Name")){return false;}
> > if (!validRequired(theForm.SURNAME,"Surname")){return false;}
> > if (!validRequired(theForm.CEL,"Cel")){return false;}
> > if (!validRequired(theForm.WEBPASSWORD,"Password")){return

false;}

> > if (!isequal
> > (theForm.WEBPASSWORD_again,theForm.WEBPASSWORD,"Passwords"))
> {return
> > false;}
> > if (!validEmail(theForm.EMAIL,"Email Address",true)) return

false;

> > return true;
> > }
> > </script>
> > <style type="text/css">
> > <!--
> > .style1 {font-weight: bold}
> > -->
> > </style>
> > <link href="main.css" rel="stylesheet" type="text/css">
> >
> > <table width="770" border="0" align="center" cellpadding="6"
> > cellspacing="0" class="lastest_catch_boarder">
> > <tr>
> > <td colspan="2" ><p align="right"><span class="heading">Join
> > WildFly</span><br>
> > <br>
> > <span class="sub_heading"><span style="font-weight: bold"><a
> > href="join.php" style="color: #000000">Membership Types</a> -

<br>

> > <a href="club_rules.php" style="color: #000000">Club
> > Rules</a> - <br>
> > <a href="mem_terms.php" style="color: #333333">Membership
> > Terms & Conditions</a> - <br>
> > <a href="reg.php" style="color: #000000">Signup Now</a> -
> > </span></span> <strong><br>
> > </strong> </p>
> > <p>
> >
> > <?
> > if ($email_exist == 1){
> > //edit this part
> > //you can close php, put html code and open again php
> > echo 'Email exist in database';
> > }
> > if ($registered == 1) include('sponsors_h.php');
> > $registered == 0;
> > if (($_POST[submit]!='Continue')&&($_POST['submit']!

='Register')){

> > ?>
> > <form name="newuser" action="<? 'PHP_SELF' ?>" method="post">
> >
> > <span class="sub_heading"> Registration Form </span><br>
> > <br>
> > <? print $msg ?>
> > <table width="98%" border="0" align="center" cellpadding="4"
> > cellspacing="0" bgcolor="eeeeee" class="main_boarder">
> > <tr>
> > <td nowrap>Registration Type </td>
> > <td nowrap>
> > <select name="MEMBERSHIPID" class="body" id="MEMBERSHIPID">
> > <option value='Fly Fisher'>Fly Fisher</option>
> > <option value="Venue">Venue</option>
> > </select>
> > </td>
> > <td nowrap> </td>
> > <td nowrap> </td>
> > </tr>
> > <tr>
> > <td nowrap> </td>
> > <td nowrap> </td>
> > <td nowrap> </td>
> > <td nowrap>
> > <input name="submit" type="submit" class="body"
> > value="Continue" id="sumbit">
> > </td>
> > </tr>
> > <?
> > include('sponsors_h.php');
> > ?>
> > </table>
> > </form>
> > <?
> > };
> > if ($_POST[submit]=='Continue'){
> > ?>
> > <form name="newuser" action="<? 'PHP_SELF' ?>" method="post"
> > onsubmit="return validateForm(this)">
> > <input type="hidden" name="MEMBERSHIPID" value='<?echo $_POST
> > [MEMBERSHIPID];?>'>
> >
> > <span class="sub_heading"> Registration Form </span><br>
> > <br>
> > <? print $msg ?>
> >
> >
> >
> > <table width="98%" border="0" align="center" cellpadding="4"
> > cellspacing="0" bgcolor="eeeeee" class="main_boarder">
> >
> > <tr>
> > <td colspan="4" nowrap><strong>New Registraton</strong></td>
> > </tr>
> > <tr>
> > <td nowrap>Email Address*<br>
> > </td>
> > <td nowrap><input name="EMAIL" type="text" class="body"
> > id="EMAIL"></td>
> > <td nowrap>First Name*</td>
> > <td nowrap><input name="NAME" type="text" class="body"
> > id="NAME"></td>
> > </tr>
> > <tr>
> > <td nowrap>Password*</td>
> > <td nowrap><input name="WEBPASSWORD" type="password"

class="body"

> > id="WEBPASSWORD"></td>
> > <td nowrap>Last Name* </td>
> > <td nowrap><input name="SURNAME" type="text" class="body"
> > id="SURNAME"></td>
> > </tr>
> > <tr>
> > <td nowrap>Confirm Password*</td>
> > <td nowrap><input name="WEBPASSWORD_again" type="password"
> > class="body" id="WEBPASSWORD_again"></td>
> > <td nowrap>Tel</td>
> > <td nowrap><input name="TELH" type="text" class="body"
> > id="TELH"></td>
> > </tr>
> > <td nowrap>Fax</td>
> > <td nowrap><input name="FAX" type="text" class="body"
> > id="FAX"></td>
> > </tr>
> > <tr>
> > <td nowrap>Comanpy Name (if aplicable) </td>
> > <td nowrap><input name="VENUE" type="text" class="body"
> > id="VENUE"></td>
> > <td nowrap>Cell*</td>
> > <td nowrap><input name="CEL" type="text" class="body"
> > id="CEL"></td>
> > </tr>
> > <tr valign="top">
> > <td nowrap>Physical Address<br></td>
> > <td nowrap><input name="ADDRESS1" type="text"
> > class="body" value="<? echo $row['ADDRESS1']; ?>"></td>
> > <td nowrap>Postal Address*</td>
> > <td nowrap><input name="POSTAL1" type="text" class="body"
> > value="<? echo $row['POSTAL1']; ?>"></td>
> > </tr>
> > <tr valign="top">
> > <td nowrap> </td>
> > <td nowrap><?
> > print get_combo('SELECT * FROM TOWNS ORDER BY
> > TOWN', 'TOWN','', '','ADDRESS2');
> > ?></td>
> > <td nowrap> </td>
> > <td nowrap><?
> > print get_combo('SELECT * FROM TOWNS ORDER BY
> > TOWN', 'TOWN', '', '','POSTAL2');
> > ?></td>
> > </tr>
> > <tr valign="top">
> > <td nowrap> </td>
> > <td nowrap><?
> > print get_combo('SELECT * FROM V_PROVINCES
> > ORDER BY PROVINCES', 'PROVINCES', '', '','ADDRESS3');
> > ?></td>
> > <td nowrap> </td>
> > <td nowrap><?
> > print get_combo('SELECT * FROM V_PROVINCES
> > ORDER BY PROVINCES', 'PROVINCES', '', '','POSTAL3');
> > ?></td>
> > </tr>
> > <tr valign="top">
> > <td nowrap> </td>
> > <td nowrap> <input name="ADDRESS4"
> > type="text" class="body" size="8" value="<? echo $row
> ['ADDRESS4']; ?
> > >"></td>
> > <td nowrap> </td>
> > <td nowrap> <input name="POSTAL4"
> > type="text" class="body" size="8" value="<? echo $row
> ['POSTAL4']; ?
> > >"></td>
> > </tr>
> > <tr valign="top">
> > <td><div align="left">Country</div></td>
> > <td colspan="3" nowrap>
> > <?
> > print get_combo('SELECT * FROM V_COUNTRY ORDER BY
> > COUNTRY', 'COUNTRY', '', '','COUNTRY');
> > ?>
> > </td>
> > </tr>
> > <tr>
> > <td nowrap>
> > <input name="submit" type="submit" class="body"
> > value="Register" id="sumbit">
> > </td>
> > <td nowrap> </td>
> > <td nowrap> </td>
> > <td nowrap> </td>
> > </tr>
> > <?
> > include('sponsors_h.php');
> > ?>
> > </table>
> > </form>
> > <?
> > }
> > ?>
> > </td>
> > </tr>
> >
> > </table>
> > <?php
> > include('footer.php')
> > ?>
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> >
> >
> > ----------------------------------------------------------------

----

> --------
> > --
> > Yahoo! Groups Links
> >
> > a.. To visit your group on the web, go to:
> > http://groups.yahoo.com/group/firebird-php/
> >
> > b.. To unsubscribe from this group, send an email to:
> > firebird-php-unsubscribe@yahoogroups.com
> >
> > c.. Your use of Yahoo! Groups is subject to the Yahoo!

Terms of

> Service.
> >
> >
> >
> > [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
> Get unlimited calls to
>
> U.S./Canada
>
>
>
>
> --------------------------------------------------------------------

--------

> --
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-php/
>
> b.. To unsubscribe from this group, send an email to:
> firebird-php-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of

Service.

>
>
>
> [Non-text portions of this message have been removed]