Help!

shyam13 · August 10, 2012

I am trying to pull data from a database using the insect_id which is sent to the url, below is my code:

insect.php:

<?php

require_once('includes/php/require.php');

$insect = mysql::select('insects',NULL, condition::where('insect_vis')->is(1)->and(condition::where('insect_web')->is(2)));

if (isset($_GET['insect_id'])) $insect->condition->and(condition::where('insect_id')->is($_GET['insect_id']));

$insect = $insect->order('insect_slug asc')->limit(10)->execute()->row(0);

?><!DOCTYPE HTML>

<html>

<head>

</head>

<body>

<?php include('fragments/header.php'); ?>

<?php include('fragments/navigation.php'); ?>

<div class='left small articles'><ul><h1>insects</h1>

</div>

<h2>Insect</h2>

<ul class='insecttable'><?php

$insect = mysql::select('insects', NULL, condition::where('insect_web')->is(2)->and(condition::where('insect_vis')->is(1)));

foreach($insect->order('insect_science')->execute()->data as $insect) { ?>

<div>

<?php echo $insect['insect_com']; ?>

</div>

</a>

<?php if (mysql::select('insects', 'insect_id', condition::where('insect_id')->is($insect['insect_id'])->and(condition::where('insect_vis')->is(1)))->limit(10)->execute()->row()) { ?>

<a href='/insectcientific/<?php echo $insect ['insect_id']; ?>' class='button inline'>Details</a>

<?php }?>

</form></li>

<?php } ?></ul>

</div>

<?php include('fragments/footer.php'); ?>

</div>

</body>

</html>

insectscientific.php:

<?php

require_once('includes/php/require.php');

if(isset($_GET['insect_id'])){

$insect = mysql::select('insect', 'insect_slug, insect_science, insect_com, insect_mdes', condition::where('insect_id')->equalto($_GET['insect_id']))->and (condition::where('insect_vis')->equalto(1))->execute();

?>

<?php } ?>

<html>

<head>

</head>

<body>

<?php include('fragments/header.php'); ?>

<?php include('fragments/navigation.php'); ?>

<div class='left small articles'><ul><h1>insects</h1>

</div>

<?php

$data = mysql::select('insect','insect_slug, insect_science, insect_com, insect_mdes', condition::where('insect_web')->equalto(2)->and(condition::where('insect_vis')->equalto(1)))->execute()->row();

?>

</div>

<?php include('fragments/footer.php'); ?>

</div>

</body>

</html>

I can access the other page but when I select an item from my insect page the id is sent to the url but the data is not retrieved from the database using the url.

Any help?

Christian F. · August 10, 2012

Please use the [code][/code] tags around your code. It helps not only on the readability of the code, but also your post.

Thank you.

Sign In

Help!

Recommended Posts

shyam13

Link to comment

Share on other sites

Christian F.

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information