Chunter

I'm writing a component that adds jobs to a database from a search API that I've paid to be part of. I have most of the component done actually.

http://www.kmbassoc.com/

Then click on job search.

Anyways. I have a members only link that adds jobs to a table which has all the info about the job that the search returns. That part is working.

Now this might be a noob question, but does anyone have a link to some code that simply returns the $rows that are in the table that correspond to their user_id which is also stored in the database. Like I said its probably a simple function, I'm just not all that skilled with MySQL and PHP yet.

Thanks!

Chris

stewie

This is partly a PHP question, partly a MySQL question and partly a mambo question.

First, in your function, you need to
global $my, $database;

This will allow you to access the $my object. The user's id is accessed through:
$my->id

Then you need to set up a query.

$query = "SELECT * FROM #__table"
. "\n WHERE user_id='".$my->id."'"
;

$database->setQuery( $query );
$rows = $database->loadObjectList();

That should do it. Let me know if you have any questions.

Ian

Chunter

Thanks stewie! I was on the right track but I forgot my global variable declarations. For some reason I thought they were passed automatically.

Also, I'm assuming to print the rows I'll need some sort of foreach loops and check the keys.

Is there a URL you know of that I can use to find the syntax of how to check the key (user_id) and when there are no more keys. I know that at I can do a $keycount++; statement in there, and an echo "<tr><td>". $rows->user_id ; or something like this to print the rows, but the logic to cycle through the each row in the array is a little bit of a mystery to me still. I'm sorry if this is a very basic question. But I still need help!!

I really thank you for taking the time so far.

Chris Hunter.

Chunter

I figured it out.

I did something like this, this is obviously not the end all, I'm still writing, but this works for now.

if ($task == 'showJob') {

$query = "SELECT user_id, job_id, job_title, job_desc, job_url, job_st, job_company, job_city FROM #__jobsearch_job_id"
. "\n WHERE user_id='".$my->id."'";

$database->setQuery( $query );
$rows = $database->loadObjectList();
if ($rows[0]) {
echo "<table>";
echo "\n<tr>";
echo "\n<td width=\"5%\">" . "Job ID" . "</td>";
echo "\n<td width=\"20%\">" . "Job Title" . "</td>";
echo "\n<td width=\"50%\">" . "Job Description" . "</td>";
echo "\n<td width=\"15%\">" . "Job City" . " " . $row->job_st . "</td>";
echo "\n<td width=\"10%\">" . "Job Link" . "</td>";
echo "</tr>\n";

//echo highlight_string(print_r($rows,true),true);
foreach ($rows as $row) {
$COLORCOUNT++;

if ($COLORCOUNT % 2 == 0 ) {
$CELLCOLOR = "p1";
} else {
$CELLCOLOR = "p2";
}
echo "\n<tr>";
echo "\n<td class=\"" . $CELLCOLOR . "NiftyBody\">" . $row->job_id . "</td>";
echo "\n<td class=\"" . $CELLCOLOR . "NiftyBody\">" . $row->job_title . "</td>";
echo "\n<td class=\"" . $CELLCOLOR . "NiftyBody\">" . $row->job_desc . "</td>";
echo "\n<td class=\"" . $CELLCOLOR . "NiftyBody\">" . $row->job_city . " " . $row->job_st . "</td>";
echo "\n<td class=\"" . $CELLCOLOR . "NiftyBody\">" . "<a href=\"". $row->job_url . "\">View Job</a></td>";
echo "</tr>\n";

}

echo "</table>\n";
}else {
echo "You Have No Jobs In Your List.<br> You can use our search and click the <b>Add to My Jobs</b> Link on each search result.";
}
echo $database->getErrorMsg();
}

If anyone sees anything that I should change lemme know.

Chris