Solved

how to run a php program on a server that receives data and updates a database

Posted on 2014-09-10
13
173 Views
Last Modified: 2014-09-20
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
Comment
Question by:rcschroeder
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 5
13 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40315996
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
 

Author Comment

by:rcschroeder
ID: 40316027
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
 

Expert Comment

by:ghjkl ghjkl
ID: 40316047
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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40316118
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
 

Author Comment

by:rcschroeder
ID: 40316134
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
 

Author Comment

by:rcschroeder
ID: 40316208
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
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40316222
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
 

Author Comment

by:rcschroeder
ID: 40322079
Virtual host is listening (per netstat -ntulp) on 1024 but this thing still does not work.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40322098
Details are important.  What message are you getting that tells you that it doesn't work?
0
 

Author Comment

by:rcschroeder
ID: 40322220
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
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40322246
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
 

Accepted Solution

by:
rcschroeder earned 0 total points
ID: 40323231
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
 

Author Closing Comment

by:rcschroeder
ID: 40334179
Help was excellent and I am grateful.
Just going for a different solution
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Enable SPF on IMSVA 6 67
Not listening to where 1 43
sed command 3 31
SQL Function 4 38
It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
This article was originally published on Monitis Blog, you can check it here . Today it’s fairly well known that high-performing websites and applications bring in more visitors, higher SEO, and ultimately more sales. By the same token, downtime…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question