Richard Schroeder
asked on
how to run a php program on a server that receives data and updates a database
I need to be able to connect to a server (using IP address and port) and run a php query that updates a database with a record (add or update)
There are quite a few details that need to be taken care of to do that. Do you know how to write a PHP program? Do you have FTP to the server to upload files? Is the database already set up or is that something you need to do also?
ASKER
all of that is already done
I have a complete web application (Sencha ext3)
I have set up virtual hosts and they are listening
My problem is that I have something wrong that i don't understand about how to execute the php program when hitting the server on a port number.
I have tried a lot of things, but some detail about how to do this is missing
What I am trying to do is write a record to a database (from a desktop application), I am NOT opening the browser.
I have a complete web application (Sencha ext3)
I have set up virtual hosts and they are listening
My problem is that I have something wrong that i don't understand about how to execute the php program when hitting the server on a port number.
I have tried a lot of things, but some detail about how to do this is missing
What I am trying to do is write a record to a database (from a desktop application), I am NOT opening the browser.
Please read the following php example code, you can define the other port from
define("DB_HOST", "localhost:3306") in which 3306 is default port for mysql,
and you can read this php mysql tutorial site at w3schools if need at http://www.w3schools.com/php/php_mysql_intro.asp
define("DB_HOST", "localhost:3306") in which 3306 is default port for mysql,
and you can read this php mysql tutorial site at w3schools if need at http://www.w3schools.com/php/php_mysql_intro.asp
<?php
$db_filename="mydbase";
define("DB_HOST", "localhost:3306");
define("DB_USER", "myaccount");
define("DB_PASSWORD", "mydatabase");
$mysqli=new mysqli(DB_HOST, DB_USER, DB_PASSWORD);
if ($mysqli->connect_errno) {
printf("Failed to connect to server: %s\n", $mysqli->connect_error);exit();}
$db_select =$mysqli->select_db($db_filename);
if(!$db_select) {die("Unable to select ".$db_filename);}
echo "Your database ".$db_filename." is connected";
?>
That is entirely confusing. Everything I find about "Sencha ext3" says that it is a Javascript framework that runs in your web browser. I didn't see anything about PHP. At the very least, you need to give us some more details about what you're trying to do and the error messages you are getting.
ASKER
Php is the server side language
But that is not my problem
My problem is when I send the request it does not run
But that is not my problem
My problem is when I send the request it does not run
ASKER
If I hit nnn.nnn.nnn.nnn:1024 in a browser it should redirect me to var/www/myfolder/cart.php
or at least I thought is should
But it does not seem to work,
So obviously I don't know how to do this
This is what I need to know
or at least I thought is should
But it does not seem to work,
So obviously I don't know how to do this
This is what I need to know
That's better. Is one of the virtual hosts listening at "nnn.nnn.nnn.nnn:1024"? If it is, it might connect you to "nnn.nnn.nnn.nnn:1024/myfo lder/cart. php" but "var/www/myfolder/cart.php " is not a web accessible file path. You should only be able to access a file that is 'relative' to the root of the webserver. Try putting "nnn.nnn.nnn.nnn:1024/myfo lder/cart. php" in your browser and see what you get.
If none of your hosts are listening to "nnn.nnn.nnn.nnn:1024", you won't have access.
If none of your hosts are listening to "nnn.nnn.nnn.nnn:1024", you won't have access.
ASKER
Virtual host is listening (per netstat -ntulp) on 1024 but this thing still does not work.
Details are important. What message are you getting that tells you that it doesn't work?
ASKER
I don't get a message.
I cannot find anything in the apache2 log files that was generated by this program.
Let me explain exactly what I am trying to do. Maybe my approach is totally wrong?
I have a desktop application running on a windows workstation. I want to update a record on the mysql server, either create a new record in the database, or fetch a record or update an existing record.
The workstation is running in a remote location and access to the server is only available through the web.
Advice?
I cannot find anything in the apache2 log files that was generated by this program.
Let me explain exactly what I am trying to do. Maybe my approach is totally wrong?
I have a desktop application running on a windows workstation. I want to update a record on the mysql server, either create a new record in the database, or fetch a record or update an existing record.
The workstation is running in a remote location and access to the server is only available through the web.
Advice?
Ignore the desktop app for the moment. Lets see if it is responding at all. Put "nnn.nnn.nnn.nnn:1024/" (using the real IP address) in your web browser address bar and tell me what you get.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Help was excellent and I am grateful.
Just going for a different solution
Just going for a different solution