Thread: problem with PHP

problem with PHP

From
"Francisco Mosse - (Zivals)"
Date:
Hi!!
 
I found your email addresses in www.postgresql.org
 
I am working in a PHP search engine made with PHP and Postgres...
The database has one table called "findmaan" with the following info
 
   Column    |          Type          | Modifiers
-------------+------------------------+-----------
 url         | character varying(255) |
 title       | character varying(255) |
 keywords    | text                   |
 description | text                   |
 category    | integer                |
 rating      | integer                |
 cache       | text                   |
 
 
and there is another table called "categorias_findmaan"
 
   Column    |          Type          |                            Modifiers                           
-------------+------------------------+-----------------------------------------------------------------
 idx         | integer                | not null default nextval('"categorias_findmaan_idx_seq"'::text)
 descripcion | character varying(255) |
Unique keys: categorias_findmaan_idx_key
 
well.. what´s my problem? : I want to call the name of the category from the idx of the table "categorias_findmaan"...
for example, if I add one site in the table "findmaan" whose category is number "5", then the search engine would have to search in table "categorias_findmaan" and find, por example, that that number category is for "Culture web sites"...
 
So.. I can´t understant how do I have to do this...
 
and secondly... how do I add data to the table "categorias_findmaan" if the type is a integer?? I mean, how would I add the number 1=tennis web sites   or 2=educational web sites  etc...
 
I hope you can help me...
 
-------------------------
Francisco Mosse
Coordinador de www.TangoStore.com
Zivals S.A. - Tangostore.com
Av. Callao 395
C1022AAD Buenos Aires
Argentina
Tel 54 11 4371 7500
Fax 54 11 4371 7437

Re: problem with PHP

From
Keary Suska
Date:
on 11/20/02 3:26 PM, fmosse@zivals.com purportedly said:

well.. what´s my problem? : I want to call the name of the category from the idx of the table "categorias_findmaan"...
for example, if I add one site in the table "findmaan" whose category is number "5", then the search engine would have to search in table "categorias_findmaan" and find, por example, that that number category is for "Culture web sites"...

So.. I can´t understant how do I have to do this...

and secondly... how do I add data to the table "categorias_findmaan" if the type is a integer?? I mean, how would I add the number 1=tennis web sites   or 2=educational web sites  etc...

What you seem to be asking here are basic SQL concepts. The list can't really teach you SQL. There are many good books that can teach you SQL, or you can try the tutorial at www.postgres.org.

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"

Help...

From
"Francisco Mosse - (Zivals)"
Date:
Hi!
 
What is wrong? My server has PHP and Postgre
I can´t understand hoy do I get this error... look
I start with a value ($quebuscototal) and I should get an array like this ("'abc', 'def', 'ghi', 'jkl') ?
but with this code, what I receive is an array where the first element is 'abc', 'def', 'ghi', 'jkl'
instead of being 'abc' (and the second one, 'def', the third one 'ghi', etc.)
 
$quebuscototal = "abc def ghi jkl";
$quebuscototal = str_replace(' ',' \', \'',$quebuscototal);
$quebuscototal = "'$quebuscototal'";
$quebuscofinal = array($quebuscototal);
$quees = "$quebuscofinal[1] ";
 
What is wrong with my code? Thanks!!
Francisco
-------------------------
Francisco Mosse
Coordinador de www.TangoStore.com
Zivals S.A. - Tangostore.com
Av. Callao 395
C1022AAD Buenos Aires
Argentina
Tel 54 11 4371 7500
Fax 54 11 4371 7437

Re: Help...

From
"scott.marlowe"
Date:
On Mon, 16 Dec 2002, Francisco Mosse - (Zivals) wrote:

> Hi!
>
> What is wrong? My server has PHP and Postgre
> I can´t understand hoy do I get this error... look
> I start with a value ($quebuscototal) and I should get an array like
> this ("'abc', 'def', 'ghi', 'jkl') ?
> but with this code, what I receive is an array where the first element
> is 'abc', 'def', 'ghi', 'jkl' instead of being 'abc' (and the second
> one, 'def', the third one 'ghi', etc.)
>
> $quebuscototal = "abc def ghi jkl";
> $quebuscototal = str_replace(' ',' \', \'',$quebuscototal);
> $quebuscototal = "'$quebuscototal'";
> $quebuscofinal = array($quebuscototal);
> $quees = "$quebuscofinal[1] ";

The array() construct is not a function, so it's generally used
only to create arrays without variables.  I'm not sure if it can handle
vars inside it.  There are maybe some tricks to get around this, but
implode/explode are better for mucking with arrays anyway.

I'll try to give a little help.

$quebuscototal = "abc def ghi jkl";
$quees = explode(" ",$quebuscototal);

should result in an array like this:

$quees[0]="abc";
$quees[1]="def";
$quees[2]="ghi";
$quees[3]="jkl";

There are lots of fun ways to manipulate arrays in PHP, by the way.  Look
at explode, implode, array_pop, array_push and some of the others listed
in the docs.