Ask Question Forum:
Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by rcschroeder
at 2024-09-10 16:38:45
ModifyPoint:0 Replies:13 POST_ID:828301USER_ID:11055
Topic:
Server Software;Linux;MySQL Server
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)
Author: rcschroeder replied at 2024-09-20 02:15:38
Help was excellent and I am grateful.
Just going for a different solution
Just going for a different solution
Accepted Solution
Author: rcschroeder replied at 2024-09-15 07:35:36
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.
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.
Expert: Dave Baldwin replied at 2024-09-14 17:06:44
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.
Author: rcschroeder replied at 2024-09-14 16:40:00
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?
Expert: Dave Baldwin replied at 2024-09-14 13:35:09
Details are important. What message are you getting that tells you that it doesn't work?
Author: rcschroeder replied at 2024-09-14 13:09:34
Virtual host is listening (per netstat -ntulp) on 1024 but this thing still does not work.
Expert: Dave Baldwin replied at 2024-09-10 20:47:07
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.
If none of your hosts are listening to "nnn.nnn.nnn.nnn:1024", you won't have access.
Author: rcschroeder replied at 2024-09-10 20:24:56
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
Author: rcschroeder replied at 2024-09-10 19:03:25
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
Expert: Dave Baldwin replied at 2024-09-10 18:49:52
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.
Expert: ghjkl ghjkl replied at 2024-09-10 17:41:07
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", $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";?> 1:2:3:4:5:6:7:8:9:10:11:12:
Author: rcschroeder replied at 2024-09-10 17:22:10
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.
Expert: Dave Baldwin replied at 2024-09-10 16:56:25
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?
