PHP Question/MySQL

[KhuBann]

And how do I put a query in a list view?

[TIMAI2]

@KhuBann

how do I put a query in a list view

Put your query/queries in a list, and set the list to the elements of a listview

[KhuBann]

@TIMAI2

Put your query/queries in a list, and set the list to the elements of a listview

and how? D:

[TIMAI2]

[KhuBann]

what I mean is to make a query for example "select * from table_users" and that the result appears in a listview

[TIMAI2]

Well you do much the same thing with the

RESULTS

returned

FROM

a query.

Converts the results to a list, and show in a list view.

If you are returning multiple columns, you will get a better "view" if you use the TableView extension

[KhuBann]

i can't, u can show me pls

[TIMAI2]

Show what you have tried. Include your responseContent(results) as text

[KhuBann]

[TIMAI2]

Seems you did not read/follow Taifun's mySQL guide correctly.

Where is your Web1.GotText event block?

very basically...

[KhuBann]

Hi again, any can help with the tableview?

[TIMAI2]

Not sure I understand what all this is for:

based upon your raw response content, you should be able to feed this directly to the Tableview.Datastring

Also, ensure you have set the row delimiter to \n in the designer properties

[KhuBann]

Thank you very much, I did it, the last two things, how can I accommodate this in a uniform way, and the other, how can I add an upstream ID data automatically and not manually?

[TIMAI2]

@KhuBann

how can I accommodate this in a uniform way,

Stretch to Fit in the designer

@KhuBann

how can I add an upstream ID data automatically and not manually

Do not understand....

[KhuBann]

@TIMAI2

Do not understand

my table have the column "ID" what is auto_increment
pero no se como hacer para no tener que no ingresar un dato en la columna id

[Taifun]

MySQL AUTO INCREMENT a Field

Taifun

[KhuBann]

is that in mysql admin I can add data but from my app inventor I can't if I don't put an id manually, besides that column appears in a label and it's the same query but not in the tableview

[Taifun]

@KhuBann

from my app inventor I can't

Show your create table statement and a screenshot of your INSERT INTO query

Taifun

[KhuBann]

@Taifun

Show your create table statement

Cita
CREATE TABLE tabla_usuarios (
id int(11) NOT NULL AUTO_INCREMENT,
usuario varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
clave varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
nombre varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
apellido varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
correo varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
telefono varchar(12) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

and query is "Insert into tabla_usuaros VALUES ('id', 'usuario', 'clave', 'nombre', 'apellido', 'correo', 'telefono')

[KhuBann]

@TIMAI2

Stretch to Fit in the designer

It is activated and it is not ordered when it has 7 columns