Warning: Ocifetch() [function.ocifetch]: Ora-24374: Define Not Done Before Fetch Or Execute And Fetch

Here is my simple search bar for a uni assignment:

Best Secondhand Mobile Phones Geelong<

Solution 1:

I guess you forgot the

ociexecute($stmt, OCI_DEFAULT);

After the

$stmt = OCIParse($connect, $query);

And before the:

while(OCIFetch($stmt))

So it would look like this:

//Perform search$stmt = OCIParse($connect, $query);

// Execute statement
ociexecute($stmt, OCI_DEFAULT);

//And display the results$counter = 0;
while(OCIFetch($stmt))
{
    $counter++;
...

More here