neotableeditor with mysql
Quote from Phil78 on May 18, 2021, 5:52 pmHello
I am a novice and I am trying to test the neoTableEditor example with my mysql database.
When I connect with the user defined in the user table I get the message "wrong credential".
If I connect with $adminName and
$adminPass defined in config.php I am connected.
When I click on the button load data from db nothing happens, there is no message on the console except "Error: Promised response from onMessage listener went out of scope" that I receive before the login ?
Hello
I am a novice and I am trying to test the neoTableEditor example with my mysql database.
When I connect with the user defined in the user table I get the message "wrong credential".
If I connect with $adminName and
$adminPass defined in config.php I am connected.
When I click on the button load data from db nothing happens, there is no message on the console except "Error: Promised response from onMessage listener went out of scope" that I receive before the login ?
Quote from luishp on May 18, 2021, 6:07 pmHi @phil78 it's very difficult to know what's happening in your project with such a few information. I recommend you to try using a SQLite database first and, once your are familiarized and everything works, use a MySQL database by changing the connection information. We are using MySQL databases with no issues so it should work for you too.
Allways keep in mind where the database is located in order to access it correctly from the .php script.Best regards.
Hi @phil78 it's very difficult to know what's happening in your project with such a few information. I recommend you to try using a SQLite database first and, once your are familiarized and everything works, use a MySQL database by changing the connection information. We are using MySQL databases with no issues so it should work for you too.
Allways keep in mind where the database is located in order to access it correctly from the .php script.
Best regards.
Quote from Phil78 on May 19, 2021, 2:57 pmThanks for your answer. I already have tested with sqllite with succes, but usually I work with mysql and it is important for me to be sure with this configuration before i decide to buy (especially since I only have one day of testing left because my messages were blocked until yesterday by your security system).
My project is your example neoTableEditor I have created the employees and users table in my database.
here is my config.php, is there something wrong ? :
3 questions
- in the video $usersDb is not filled why ?
- How neo know the name of the tables users ?
- NEVER HARDCODE USER AND PASSWORD IN YOUR APP what do we put for $adminName, $adminPass when publishing
$adminName="root";
$adminPass="";//--------------Users database-------------------------------------------------------
//MySQL database to store and retrieve users and other usage.//$usersDb="pha78sql11";
$dbAlias[0]="mydb";
$dbNames[0]="pha78sql11";
$dbServerNames[0]="localhost";
$dbUsernames[0] = "username";
$dbPasswords[0] = "password";$sqlAlias[0]="selectemployees";
$sqlQuerys[0]="SELECT * FROM Employees ORDER by EmployeeId DESC";
$sqlMaxUserLevel[0]=-1;$sqlAlias[1]="deleteemployeesrow";
$sqlQuerys[1]="DELETE FROM Employees WHERE EmployeeId=?";
$sqlMaxUserLevel[1]=0;$sqlAlias[2]="insertemployees";
$sqlQuerys[2]="INSERT INTO Employees DEFAULT VALUES";
$sqlMaxUserLevel[2]=0;
Thanks for your answer. I already have tested with sqllite with succes, but usually I work with mysql and it is important for me to be sure with this configuration before i decide to buy (especially since I only have one day of testing left because my messages were blocked until yesterday by your security system).
My project is your example neoTableEditor I have created the employees and users table in my database.
here is my config.php, is there something wrong ? :
3 questions
- in the video $usersDb is not filled why ?
- How neo know the name of the tables users ?
- NEVER HARDCODE USER AND PASSWORD IN YOUR APP what do we put for $adminName, $adminPass when publishing
$adminName="root";
$adminPass="";
//--------------Users database-------------------------------------------------------
//MySQL database to store and retrieve users and other usage.
//$usersDb="pha78sql11";
$dbAlias[0]="mydb";
$dbNames[0]="pha78sql11";
$dbServerNames[0]="localhost";
$dbUsernames[0] = "username";
$dbPasswords[0] = "password";
$sqlAlias[0]="selectemployees";
$sqlQuerys[0]="SELECT * FROM Employees ORDER by EmployeeId DESC";
$sqlMaxUserLevel[0]=-1;
$sqlAlias[1]="deleteemployeesrow";
$sqlQuerys[1]="DELETE FROM Employees WHERE EmployeeId=?";
$sqlMaxUserLevel[1]=0;
$sqlAlias[2]="insertemployees";
$sqlQuerys[2]="INSERT INTO Employees DEFAULT VALUES";
$sqlMaxUserLevel[2]=0;
Quote from luishp on May 19, 2021, 5:48 pmHi @phil78,
in the video $usersDb is not filled why ?
Because $usersDb is only needed on multiuser applications with different access levels.
User information is stored and retrieved from that database. It can be the same as your data database or not.How neo know the name of the tables users ?
I don't understand this question, sorry. But users are managed using these commands:
neoPhpUserLogin
neoPhpUserLogOut
neoPhpUserInsert
neoPhpUserEraseNEVER HARDCODE USER AND PASSWORD IN YOUR APP
It means do not do it directly on client side (using NeoScript). config.php file is on server side and the code is not visible to the user or web browser. You should be able to hardcode user and password there.
Regarding your sample code, I think this is the key point:
$dbServerNames[0]="localhost";Are you executing your app using neoPhp Server? It does not include a MySQL Server. If you are executing MySQL using your own server it's probably located in a different port for example:
$dbServerNames[0]="localhost:3306";But it depends on how you are set up your system.
Regards.
Hi @phil78,
in the video $usersDb is not filled why ?
Because $usersDb is only needed on multiuser applications with different access levels.
User information is stored and retrieved from that database. It can be the same as your data database or not.
How neo know the name of the tables users ?
I don't understand this question, sorry. But users are managed using these commands:
neoPhpUserLogin
neoPhpUserLogOut
neoPhpUserInsert
neoPhpUserErase
NEVER HARDCODE USER AND PASSWORD IN YOUR APP
It means do not do it directly on client side (using NeoScript). config.php file is on server side and the code is not visible to the user or web browser. You should be able to hardcode user and password there.
Regarding your sample code, I think this is the key point:
$dbServerNames[0]="localhost";
Are you executing your app using neoPhp Server? It does not include a MySQL Server. If you are executing MySQL using your own server it's probably located in a different port for example:
$dbServerNames[0]="localhost:3306";
But it depends on how you are set up your system.
Regards.
Quote from Phil78 on May 21, 2021, 7:47 pmThanks Luishp
Yes I use wamp server and I do not activate neophpserver.
I have tried with $dbServerNames[0]="localhost:3306"; which is the right port but there is no difference (really I use MariaDB).
About the name of users table, I wanted to say is it an implied name ? But with your answer I suppose the name of the table is one of parameters of neophpuser functions, but I'am not able to see now because my try period is ended. Is there a way to get a prologation ?
Thanks Luishp
Yes I use wamp server and I do not activate neophpserver.
I have tried with $dbServerNames[0]="localhost:3306"; which is the right port but there is no difference (really I use MariaDB).
About the name of users table, I wanted to say is it an implied name ? But with your answer I suppose the name of the table is one of parameters of neophpuser functions, but I'am not able to see now because my try period is ended. Is there a way to get a prologation ?
Quote from CDY@44 on May 21, 2021, 8:39 pmHi @phil78,
You can buy it ;)
I can assure you will not regret to buy it ! It is really an excellent tool !!
The most I use it, the most I like it !!
Hi @phil78,
You can buy it ;)
I can assure you will not regret to buy it ! It is really an excellent tool !!
The most I use it, the most I like it !!
Quote from luishp on May 22, 2021, 2:06 pmAbout the name of users table, I wanted to say is it an implied name ? But with your answer I suppose the name of the table is one of parameters of neophpuser functions, but I'am not able to see now because my try period is ended.
You don't have to create a users table, all is done by neoPhp automatically. If the table do not exists it will be created and the required fields too. By default the users table name is "neousers".
Is there a way to get a prologation ?
You can install VisualNEO Web in a different computer or, as @cdy44-2 has pointed out, buy a license. I think there is not any competitor at this prize. Thank you!
Best regards.
About the name of users table, I wanted to say is it an implied name ? But with your answer I suppose the name of the table is one of parameters of neophpuser functions, but I'am not able to see now because my try period is ended.
You don't have to create a users table, all is done by neoPhp automatically. If the table do not exists it will be created and the required fields too. By default the users table name is "neousers".
Is there a way to get a prologation ?
You can install VisualNEO Web in a different computer or, as @cdy44-2 has pointed out, buy a license. I think there is not any competitor at this prize. Thank you!
Best regards.
Quote from Phil78 on May 25, 2021, 3:04 pmTo cdy@44 and luishp,
I also think it's a good product considering its price and for having already used neobook. I'm just a little disappointed that I couldn't use several examples that don't work. I'm going on vacation soon and I'll see when I get back. Thanks to both of you.
To cdy@44 and luishp,
I also think it's a good product considering its price and for having already used neobook. I'm just a little disappointed that I couldn't use several examples that don't work. I'm going on vacation soon and I'll see when I get back. Thanks to both of you.
Quote from luishp on May 25, 2021, 4:28 pm@phil78 all samples should work. Let me know wich one doesn't work for you and I will check it.
Have a nice vacation and take care.
Thank you!
@phil78 all samples should work. Let me know wich one doesn't work for you and I will check it.
Have a nice vacation and take care.
Thank you!
Quote from quimeraec on February 16, 2023, 8:35 pmHola Luis:
Estoy comenzando con Neo y me ha gustado mucho la herramienta, pero sí me hace falta un "how to" dedicado exclusivamente a MySQL que es la base de datos que usamos en mi tienda.
Estoy comenzando a explorar pero sería fantástico disponer de un proyecto de ejemplo dedicado a MySQL.
Sospecho que no lo pusieron dentro de la carpeta Sample Apss porque SQLite es un buen inicio, pero a diferencia de MySQL creo que no se dan situaciones especiales como el uso puertos específicos distintos al 3306.
Por favor, si fueran tan amables de incluir en el paquete de VisualNeoWeb el archivo (.neoapp) de este proyecto que está línea (https://visualneo.com/tutorials/neotablemysql), o mejor, de indicarme dónde puedo descargarlo, les quedaré muy agradecido.
Hola Luis:
Estoy comenzando con Neo y me ha gustado mucho la herramienta, pero sí me hace falta un "how to" dedicado exclusivamente a MySQL que es la base de datos que usamos en mi tienda.
Estoy comenzando a explorar pero sería fantástico disponer de un proyecto de ejemplo dedicado a MySQL.
Sospecho que no lo pusieron dentro de la carpeta Sample Apss porque SQLite es un buen inicio, pero a diferencia de MySQL creo que no se dan situaciones especiales como el uso puertos específicos distintos al 3306.
Por favor, si fueran tan amables de incluir en el paquete de VisualNeoWeb el archivo (.neoapp) de este proyecto que está línea (https://visualneo.com/tutorials/neotablemysql), o mejor, de indicarme dónde puedo descargarlo, les quedaré muy agradecido.
Quote from AlvaroGm on February 17, 2023, 2:33 pmQuote from quimeraec on February 16, 2023, 8:35 pmHola Luis:
Estoy comenzando con Neo y me ha gustado mucho la herramienta, pero sí me hace falta un "how to" dedicado exclusivamente a MySQL que es la base de datos que usamos en mi tienda.
Estoy comenzando a explorar pero sería fantástico disponer de un proyecto de ejemplo dedicado a MySQL.
Sospecho que no lo pusieron dentro de la carpeta Sample Apss porque SQLite es un buen inicio, pero a diferencia de MySQL creo que no se dan situaciones especiales como el uso puertos específicos distintos al 3306.
Por favor, si fueran tan amables de incluir en el paquete de VisualNeoWeb el archivo (.neoapp) de este proyecto que está línea (https://visualneo.com/tutorials/neotablemysql), o mejor, de indicarme dónde puedo descargarlo, les quedaré muy agradecido.
Hola buenas no se si habras visto el videotutorial del uso de MySql aqui te dejo el link a ver si te es de ayuda
https://www.youtube.com/watch?v=MjxJPnu9Lvw&list=PL0I-4WLYvbmjauj2ajQjkga92BKacOqbT&index=21
Un saludo
Quote from quimeraec on February 16, 2023, 8:35 pmHola Luis:
Estoy comenzando con Neo y me ha gustado mucho la herramienta, pero sí me hace falta un "how to" dedicado exclusivamente a MySQL que es la base de datos que usamos en mi tienda.
Estoy comenzando a explorar pero sería fantástico disponer de un proyecto de ejemplo dedicado a MySQL.
Sospecho que no lo pusieron dentro de la carpeta Sample Apss porque SQLite es un buen inicio, pero a diferencia de MySQL creo que no se dan situaciones especiales como el uso puertos específicos distintos al 3306.
Por favor, si fueran tan amables de incluir en el paquete de VisualNeoWeb el archivo (.neoapp) de este proyecto que está línea (https://visualneo.com/tutorials/neotablemysql), o mejor, de indicarme dónde puedo descargarlo, les quedaré muy agradecido.
Hola buenas no se si habras visto el videotutorial del uso de MySql aqui te dejo el link a ver si te es de ayuda
Un saludo