What do I need to do to connect to the Pervasive database using MySQL?  I can connect using PHP  
$conn=odbc_connect('newevo08','','');
 
but not directly from MySQL.

It's not necessarily that odd. Sometimes you've got data from one application in one DB and data from another application in a different DB system and you want to query across them. Granted, you probably should import the relevant data from one DB system to the other but what if you want realtime results? It's not an every day sort of thing but sometimes it can be something you'd want to try to do. It's too complicate to do on a whim...

Quote from dashdown on 06/23/08 at 17:42:14:

 
PHP can also use ODBC databases. Your best bet is probably to setup an ODBC link to the Evo tables and then use PHP's ODBC module to access the data.  
 
GasGiant has done a lot of work with Evo and PHP. You can see his code at http://www.evoerpwiki.com/index.php?title=PHP_Hacks

Here is a good example: this code will show all employees
 
<?
 
$mydpt = "SELECT
BKPRMSTR.BKPR_EMP_NUM,
BKPRMSTR.BKPR_EMP_DEPT,  
BKPRMSTR.BKPR_EMP_FNMI,  
BKPRMSTR.BKPR_EMP_LNME,  
RTRIM(LEFT(BKPRINFO.BKPR_INFO_REVNT_12, 8)) AS EXT,
RTRIM(SUBSTRING (BKPRINFO.BKPR_INFO_REVNT_12, 9, 16)) AS CELL,
RTRIM(SUBSTRING (BKPRINFO.BKPR_INFO_REVNT_12, 31, 100)) AS POSIT
FROM BKPRINFO INNER JOIN BKPRMSTR ON BKPRINFO.BKPR_INFO_NUM = BKPRMSTR.BKPR_EMP_NUM
WHERE BKPR_EMP_TERM = 'N'
ORDER BY BKPR_EMP_FNMI";
 
 
//conneccion
 
$conn=odbc_connect('DBA','','');
if (!$conn)
  {exit("Connection Failed: " . $conn);}
$sql=$mydpt;
$rs=odbc_exec($conn,$sql);
if (!$rs)
  {exit("Error in SQL");}
?>
 
<p><a href="javascript:history.back()"><font face="Tahoma" size="2">Back</font></a></p>    
 
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#999999" id="AutoNumber1">
  <tr>
    <td bgcolor="#336699"><p align="center"><font face="Tahoma" size="2" color="#FFFFFF">&nbsp;Dpt&nbsp;</font></td>
    <td bgcolor="#336699"><p align="center"><font face="Tahoma" size="2" color="#FFFFFF">&nbsp;F Name&nbsp;</font></td>
    <td bgcolor="#336699"><p align="center"><font face="Tahoma" size="2" color="#FFFFFF">&nbsp;L Name&nbsp;</font></td>
    <td bgcolor="#336699"><p align="center"><font face="Tahoma" size="2" color="#FFFFFF">&nbsp;Ext &nbsp;</font></td>
    <td bgcolor="#336699"><p align="center"><font face="Tahoma" size="2" color="#FFFFFF">&nbsp;Cell &nbsp;</font></td>
    <td bgcolor="#336699"><p align="center"><font face="Tahoma" size="2" color="#FFFFFF">&nbsp;Position&nbsp;</font></td>
    <td bgcolor="#336699"><p align="center"><font face="Tahoma" size="2" color="#FFFFFF">&nbsp;View&nbsp;</font></td>
  </tr>
<?
//Color Code
$i = 0;
$max = 0;
 
while (odbc_fetch_row($rs))
{
  //Color Code
  $max++;
  $bgcolor = $i ? "#EFEFEF" : "#FFFFFF";  
  $i ^= 1; // This is the bitwise XOR
  //
 
  $DEPT=odbc_result($rs,"BKPR_EMP_DEPT");
  $FNMI=odbc_result($rs,"BKPR_EMP_FNMI");
  $LNME=odbc_result($rs,"BKPR_EMP_LNME").",";
  $EXT=odbc_result($rs,"EXT");
  $CELL=odbc_result($rs,"CELL");
  $POSIT=odbc_result($rs,"POSIT");
  $NUM=odbc_result($rs,"BKPR_EMP_NUM");
?>  
  <tr bgcolor="<? echo $bgcolor ?>">
    <td>&nbsp;<font face="Tahoma" size="2"><? echo $DEPT; ?></font>&nbsp;</td>
    <td>&nbsp;<font face="Tahoma" size="2"><? echo $FNMI; ?></font>&nbsp;</td>
    <td>&nbsp;<font face="Tahoma" size="2"><? echo $LNME; ?></font>&nbsp;</td>
    <td>&nbsp;<font face="Tahoma" size="2"><? echo $EXT; ?></font>&nbsp;</td>
    <td>&nbsp;<font face="Tahoma" size="2"><? echo $CELL; ?></font>&nbsp;</td>
    <td>&nbsp;<font face="Tahoma" size="2"><? echo $POSIT; ?></font>&nbsp;</td>
    <td>&nbsp;<font face="Tahoma" size="2"><a href="emp_info.php?key=<? echo $NUM; ?>">View</a></font>&nbsp;</td>
    </tr>
<?
}
odbc_close($conn);
?>
</table>

Yes. I mixed my pieces together a little too much. The firewall to refuse connections from anywhere but the app on the web server, and secure code for the rest. Verify user, filter/validate all input, change session ids often, block XSS... lots to do, lots to do. Keeps us coders employed
 
 
And how about spanking whomever mixed style in with their markup in that code up above. Not to mention excessive referencing.  

Quote from GasGiant on 06/24/08 at 09:51:59:

 
yes, there are more efficient ways that the code could have been laid out but I'll bet it gets the job done.
 
 
Just for reference for anyone else reading this who might want to do PHP work with databases:
 
Switching from php to html and back again is NAUGHTY. Keep the mode switches to a minimum. This means that lines like:
 
<td>&nbsp;<font face="Tahoma" size="2"><? echo $POSIT; ?></font>&nbsp;</td>  
 
Aren't so kosher. It's actually more efficient to stay in the PHP interpreter and then use:
 
print('<td>&nbsp;<font face="Tahoma" size="2"' . $POSIT . '</font>&nbsp;</td>\n');
 
The only real pain there is that you've got to be exceedingly careful with your use of ' and ". You'll note that I used ' for the quote character in PHP since the original line included "'s in it.

Um... looks like we may have strayed a bit from the original beef, but.. I think the consensus is that connecting to PSQL is funner than messing with MySQL

<?php
/** Generic start for any work with live DBA PSQL database **/
 
     if (!$db = odbc_connect('DBA-090','','')) {exit("Connection Failed: " . $db);}
     $start_trans = odbc_autocommit($db, 0);
?>

Remote? How remote? Is it your server or a commercial web host? Is it co-location or shared?  
 
I'm not sure I'd want to give a shared web server access to my PSQL server.  
 
Sounds like you got yourself into a BHA project. If you get stuck, you can ask me for a quote. My consulting rates are reasonable