[RESOLVED] odbc_exec breaks php and apache

[Yemmster]

I've searched around a bit but am unable to find a solution to my problem. I might have missed it, in such case please point me in the right direction.

For starter, while I've worked quite a bit with MySQL and PostgreSQL I'm all new to ODBC. The script I've posted below runs perfectly fine until it gets to the second odbc_exec where is completely breaks not only the script but the apache process running it, apache goes as far as stating there is a "Segmentation fault" (1) before it dies.

If someone could help me, I'd be really grateful

CODE [Wed Jun 30 13:08:40 2010] [notice] child pid 7445 exit signal Segmentation fault (11)[/CODE]

<?php
	error_reporting(E_ALL);
	$conn = odbc_connect('Kassa','','');
	$sql = "SELECT Artikelnr,Kopplat,Antal FROM Artpack";
	$rs = odbc_exec($conn,$sql);
	$packages = null;
	while(odbc_fetch_row($rs)){

	$packName = odbc_result($rs,"Kopplat");
	$artNr = odbc_result($rs,"Artikelnr");
	$artNum = doubleval(odbc_result($rs,"Antal"));
	$row = odbc_connect('Kassa','','');
	$art = "SELECT Artikelnr,InkopsPris FROM Lager WHERE (Artikelnr LIKE {$artNr})";
	$rart = odbc_exec($row,$art); #this is what breaks the script.

	if($rart === FALSE){ /* errors 'n stuff */}
		odbc_fetch_row($rart);
		$artCost = doubleval(odbc_result($artRow,"InkopsPris"));
		$packages[$packName] += ($artCost*$artNum);
		$count++;
}

print_r($packages);
?>

[Yemmster]

Ok, I dugg a bit deeper and found what the error was. Turned out I couldn't keep two connections to the database at the same time, which doesn't come as a surprise when I start to think about it as it is an Access database.

So, I solved it by making sure the connections were all closed as soon as I didn't need them anymore. Not the most beautiful solution, but it works for what I want to do 🙂

[Crowly]

$conn = odbc_connect('Kassa','','');
$row = odbc_connect('Kassa','','');

These two do exacly the same, and the 2nd is also in a loop which would, if it worked, result in reopening the connection over and over.

Something like this, then you open and close once.

<?php 
    error_reporting(E_ALL); 
    $conn = odbc_connect('Kassa','',''); 
    $sql = "SELECT Artikelnr,Kopplat,Antal FROM Artpack"; 
    $rs = odbc_exec($conn,$sql); 
    $packages = null; 
    while(odbc_fetch_row($rs)){ 

    $packName = odbc_result($rs,"Kopplat"); 
    $artNr = odbc_result($rs,"Artikelnr"); 
    $artNum = doubleval(odbc_result($rs,"Antal")); 
    $art = "SELECT Artikelnr,InkopsPris FROM Lager WHERE (Artikelnr LIKE {$artNr})"; 
    $rart = odbc_exec($conn,$art); // use $conn here as well

    if($rart === FALSE){ /* errors 'n stuff */} 
        odbc_fetch_row($rart); 
        $artCost = doubleval(odbc_result($artRow,"InkopsPris")); 
        $packages[$packName] += ($artCost*$artNum); 
        $count++; 
} 

   odbc_close($conn);

print_r($packages); 
?>

Also instead of having the 2nd SELECT within the loop, what you tried to look at JOINS to see if you can get away with one SELECT?