retrieve data from mysql |
Post Reply | Page <12 |
Author | |
Dmit OE
Admin Group Joined: May 31 2012 Status: Offline Points: 5283 |
Post Options
Thanks(0)
|
P.S. And change the Position of the first block to StartDocument.
|
|
tomos81
Newbie Joined: Mar 14 2016 Status: Offline Points: 10 |
Post Options
Thanks(0)
|
You mean first block - non visual block?
I changed to StartDocument, and nothing shown, no error message... I modified Your test script: $sqlTEST = "SELECT 1"; $result=mysql_query($sqlTEST); echo "Test - should show '1': $result <br/>"; but nothing shown on webpage - i dont think it will be shown if it is on non visual code block
|
|
Dmit OE
Admin Group Joined: May 31 2012 Status: Offline Points: 5283 |
Post Options
Thanks(0)
|
add
echo "SOMETHING"; as the first line of your code, to see if SOMETHING is shown. Please give the link to your page. And yes, if you try to test it with OE's local preview, it won't work as the local webserver does not support MySQL (only SQLite), so you should either use a WAMP or publish online. |
|
tomos81
Newbie Joined: Mar 14 2016 Status: Offline Points: 10 |
Post Options
Thanks(0)
|
OK I am trying on my local server - webserver is MYSQL , so can be a problem with that?
I placed all my OE project files to www directory on my local apache webserver and trying refresh page after changes I made, and saved the changes. I downloaded EasyPHP as You suggested, started apache server and MYSQL database... Made a full restore of data to my local MYSQL. But still no connection to database If the code I wrote is OK, i will need to trace why mysql_connect not connecting to my local database. I also created a test user with password and granted him DBA rights to my local database, making selects with him |
|
Dmit OE
Admin Group Joined: May 31 2012 Status: Offline Points: 5283 |
Post Options
Thanks(0)
|
I replied to your private message; you need to set your page to PHP by using Page->Server Scripts->PHP.
|
|
Dmit OE
Admin Group Joined: May 31 2012 Status: Offline Points: 5283 |
Post Options
Thanks(0)
|
P.S. And do not upload the project folder itself, use Export to folder to generate a ready-to-upload website version.
|
|
Post Reply | Page <12 |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |