Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • Last Modified:

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)
0
rcschroeder
Asked:
rcschroeder
  • 7
  • 5
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
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?
0
 
rcschroederAuthor Commented:
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.
0
 
ghjkl ghjklCommented:
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
<?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";
?>

Open in new window

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Dave BaldwinFixer of ProblemsCommented:
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.
0
 
rcschroederAuthor Commented:
Php is the server side language

But that is not my problem

My problem is when I send the request it does not run
0
 
rcschroederAuthor Commented:
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
0
 
Dave BaldwinFixer of ProblemsCommented:
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/myfolder/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/myfolder/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.
0
 
rcschroederAuthor Commented:
Virtual host is listening (per netstat -ntulp) on 1024 but this thing still does not work.
0
 
Dave BaldwinFixer of ProblemsCommented:
Details are important.  What message are you getting that tells you that it doesn't work?
0
 
rcschroederAuthor Commented:
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?
0
 
Dave BaldwinFixer of ProblemsCommented:
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.
0
 
rcschroederAuthor Commented:
We are giving up on this. We are using a different way to do it
Using virtual host seems to be too difficult to implement.
We will hit the remote server directly on port 3306 using  MYDAC.

I feel that we  could have gotten this working if we spent enough time on it, but it is not worth the effort in this case. I appreciate you efforts to help me.
0
 
rcschroederAuthor Commented:
Help was excellent and I am grateful.
Just going for a different solution
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now