How To Get Data From A Database To My Local Machine?
I have a process that runs on my local machine which requires information from a database to be used in a dos batch file.
Currently, I have a setup where a query string is sent to the web server with the id number of the record I want to get and a page on the web server writes a file to the server which is then downloaded using httpget to be used by the batch file.
Is there a better way to do this? In other words, how can I have a dos batch file interact with the database directly to get the info in the record?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Backing Up The Database On Local Machine.
I'm currently getting on with the security checking of my site, but how about backing up the database. Currently I'm using a hosted service, so all my data and code is on the internet. I have only one database online with multiple tables, so I need to put them somewhere (on an daily basis preferably, with new backups each day). The code I can handle it's just the databases that are tricky. Is there any tool out there that'll do this quick and smart and would I need a local MySQL database running in order to put them on a local machine.
View Replies !
View Related
PHP On Local Machine
Back in 2004 I installed PHP, Apache and MySQL on my local machine to do some testing. I have not used it since. I just tried to browse one of my .php test files in IE and it opened up in Dreamweaver! Everything seems to be in place where I left it, I restarted Apache just in case - but no joy. Is there something simple that I have forgotten to do? - something I should have started up? - or something I can check? I would like to avoid reinstalling the software if possible as I recall having a few "teething problems."
View Replies !
View Related
PHP Copy To Local Machine?
I am building a small page to copy files from our server(s) to our users local machines. It's very simple... (below, "f" is a mapped network drive) <?php $source_file = 'f:somefile.whatever' $destination_path = (I want to move it to the USERS C:somedirectorysomefile); copy($source_file, $destination_path); ?>
View Replies !
View Related
Getting Unlink() On My Local Machine
I am having trouble getting unlink() to work on my local machine (win 2000, Apache, php 4.2.2) when I invoke unlink() in order to change a file name during a 'picture edit' change from a form upload on my local machine using simple stuff like: <?php if(file_exists($new_file_name)){ unlink($new_file_name); } if($new_pic){rename($old_file_name,$new_file_name) ;} } ?>........
View Replies !
View Related
Local Machine Time
Echoing <?php echo date('Y-m-d h:i:s'); ?> seems to give the server time. Is there a way to echo the local machine time of the user/by time zone? The user is entering values based on the time (this is a web based calendar). Currently, the above could be a max. of 2 hrs off for users in the United States, in may case.
View Replies !
View Related
$_FILES From The Server - Not Local Machine
I'm just playing with someone else's code and was wondering how to get details of a file that's already uploaded to my server into the $_FILES super global. the code I have is: ...$uploadedFileName = $_FILES['filename']['name']; if($_FILES['filename']['size'] > $maxSize) {... all the checks are done using this and I just want to parse all this info without the user having any control / knowledge of it at all. It's for an image upload script which has been built already, but I want lots of differing quality thumbnails to be generated, but the current code keeps asking the user to input size variables and path details to upload a file from their local machine.
View Replies !
View Related
Writing Files To Local Machine
Does anyone know how to, using PHP or other, to automatically write files from a mySQL database on a server to a local machine? Basically the reason I need it, is that the database will be continually getting new data from various users, and I want the information to be copied to a local file on my own computer every 15 minutes or so (just continually rewriting the file on my local machine, with the newest data). This way, if there is a server error, or internet connectivity issues, I will still always be able to access the latest data by opening the file on my local machine.
View Replies !
View Related
Test CRON On Local Machine (WAMP)
How could I test-run a CRON on a local machine? Com-line or Putty does not find local host or 127.0.0.1 I never tried that before so I am clue less! don't even know if it is possible? How can I manage it on a local machine/localhost run by a WAMP
View Replies !
View Related
Copying File From Hosted Remote Sever To Local Machine
I am trying to use php to automate the copying of a file from my remotely hosted directory to my computer. I have put together the following but it will only do the copying from one directory to another on the remote server. Reading the postings on these functions they suggest that it can be done but it appears to be the case if your are hosting your site on the same machine you want to copy the files to. Does anyone know if there are functions in php to do the transfer from remote server to my machine or if the code below will acheive this with modification? <?php $ftp_server = "xxxxxxxx"; $ftp_user = "xxxxxxx"; $ftp_pass = "xxxxxx"; $local_file = 'myfile.txt' $server_file = 'myfile.txt' // set up a connection or die $conn_id = ftp_connect($ftp_server) or die("Couldn't connect to $ftp_server"); $login_result = ftp_login($conn_id, $ftp_user, $ftp_pass); // check connection if ((!$conn_id) || (!$login_result)) { die("FTP connection has failed !"); } // try to change the directory to myfilesdirectory if (ftp_chdir($conn_id, "myfilesdirectory")) { echo "Current directory is now: " . ftp_pwd($conn_id) . ""; } else { echo "Couldn't change directory"; } if (ftp_get($conn_id, $local_file, $server_file, FTP_BINARY)) { echo "Successfully written to $local_file"; } else { echo "There was a problem"; } // close the connection ftp_close($conn_id);
View Replies !
View Related
LOAD DATA LOCAL INFILE - Workaround For Local-infile=0
I'm using a PHP script for updating my database which relies on the "LOAD DATA LOCAL INFILE" command. As my provider recently updated the MySQL-database, he changed the "local-infile" setting to zero, i.e. my update-script doesn't work anymore (=> "The used command is not allowed with this MySQL version"). Is there a work-around to fix this problem? I though about the mysql_options command, but to frankly speaking, I have no clue how to use it and couldn't figure out how to properly use it even after reading the manual ... anyone who could help?
View Replies !
View Related
Connecting To Local Database
I'm not sure if this is possible. I would like to have a PHP app on the Internet connect and write to a local database (Intranet). For example, users would go to a web site http://www.internet.com to run the app. The app requires an internet connection and is outside of the user's network. The app would have the option to either store data locally or on the Internet. I would like to give users the option to store data locally because some may hv privacy/security concerns if the data is stored on the Internet or kept/maintained by another company. Would the connection string below work from the Internet to connect to the user's local database? I don't have my web hosting service up yet so I can't test. <?php $server='localhost' //or whatever the client db server name is $c=new mysqli($server,'user','passwd','db'); ?>
View Replies !
View Related
LOAD DATA LOCAL INFILE
SQL Version: MySQL 3.23.49 PHP Version: 4.3.11 Tearing my hair out with this 1. My PHP script was woking perfect until I moved to a different hosting server. When my page loads a PHP script imports the data into a MySQL table. Code:
View Replies !
View Related
Cannot Access Local MySQL Database
I'm having a huge problem getting PHP on IIS to access the MySQL server (running on the same server). I get a 10061 error when trying to issue a simple connect: Warning: mysql_connect(): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10061) Username, password and IP are correct - and the MySQL server is actually running and working perfectly. I can access it just fine from the same server using ASP or my home Linux box running PHP 4.3.8 on Apache. Let me clarify that: The EXACT same mysql_connect command works from my (remote) Linux/Apache box, but not on the (local) IIS server. The server I'm having trouble with is running IIS, PHP 4.4.0 and MySQL 4.0.22-nt. PHP is running in CGI mode and reports MySQL Client API version 3.23.49. Anyone have a clue what my problem could be? I've just about googled myself to death on this issue. It seems that basically the only advice I've found is that people need to make sure MySQL is running (it is), that the username/password is correct (it is), that the correct port is being tried (everything at default, so it is) and that a firewall isn't blocking the request (it isn't).
View Replies !
View Related
Importing To Mysql Without LOAD DATA LOCAL
I've just gone through the learning curve of realizing most virtual hosts have "LOAD DATA LOCAL" disabled :( I have a two meg delimited ascii file I need to import on a regular basis (26 fields) Anyone have a nice import routine using fopen they are willing to share before I attempt to hack one out myself? I can't seem to find such an animal out there (though some are close). Such a shame, from what I have read, load data is much faster...
View Replies !
View Related
Transferring A MySQL Database From Local PC Onto An ISP Server
If I have an MySQL database on my local w2k, how do I transfer it onto my ISP server? The ISP gave me the name of an empty MySQL database they set up for me, the username and the password with no further explanations. I came here from ASP/Access where I was just uploading a mdb file into my webspace. But with MySQL there should be a different procedure,
View Replies !
View Related
Connect Page (local) To Remote Database:
I'have Easy PHP in localhost and i need connect php page (local) to remote database: $db_host = "62.149.225.23"; $db_user = "gfo"; $db_password = "gfo"; $db_name = "gfonline"; $db = mysql_connect($db_host, $db_user, $db_password); The browser show this message: Warning: mysql_connect(): Can't connect to MySQL server on ེ.149.225.23' (10061) in e:phpgfonline.itprovaremoto.php on line 7
View Replies !
View Related
Save Html-forms Data To Local Disk?
A question on html-forms: We have an application where users will get a CD with, among other things, some html-forms for them to fill in. When they click the submit-button, the data is transferred to a webserver php-script that will then process the info. The forms-definition looks something like this: <form action="http://www.ourdomain.com/receiver.php" method="post"> <p>Question 1: <p><textarea name="reply01" cols="40" rows="5"></textarea> <p>Question 2: <p><textarea name="reply02" cols="40" rows="5"></textarea> <p>Question 3: <p><textarea name="reply03" cols="40" rows="5"></textarea> ... etc ... <p><input type="submit" value="Submit answers!"> </form> Now, my concern is (since there might be quite a lot of data filled in), if e.g. the internet-connection for some reason is broken at the moment when the user clicks the submit-button, there is a risk they will lose all the text and would have to re-type it, which I would like to avoid, of course. How can I best solve this issue? Ideally, I would like to store the info on their local C: drive before submitting, and automatically retrieve the text if they later return to the page, but I guess that's not possible from an html doc, right? If so, any other suggestions how to resolve this issue?
View Replies !
View Related
Challenge: LOAD DATA LOCAL INFILE Command Used From
they have a limit on 36000 inserts to my mysql database. User 'user' has exceeded the 'max_updates' resource (current value: 36000) This happen when importing a cvs file with 61000 lines. Then I realized that using phpmyadmin works just fine, using the feature: Insert data from a text file into the table Code:
View Replies !
View Related
Common Prob With Mysql LOAD DATA LOCAL INFILE ...
i have most recent php & mysql versions running on a linuxmachine i want to use LOAD DATA LOCAL INFILE and pass it from php to mysql. - the file i load is given with full path and the directory is readble - On MySQL local-infile = ON - From PHP i connect using client flag (128) to allow passing a file over that connection: mysq_connect( $host, $usr, $pwd, false, 128) Ive followed all advice from php & mysql sites and deja.com ... But i still get the message: The command is not allowed with this MySql Version or something ... any ideas where i should look further? what are *all* the requirements for a LOAD DATA LOCAL INFILE to work seamingly?
View Replies !
View Related
Local Access Database To Shared PHP/MySql Hosting Export
My client has an MS Access database application on her local machine. I have full access to that in terms of changing the design. I've got a simple PHP/MySql application on shared hosting, so no direct access to the db server. I'd like to give her the facility to export the information in her local Access application to the shared PHP/MySql site. From one command button (or similar) in the Access application. It would be probably be a complete overwrite. That is to say all the information on the shared site would be overwritten with that from the local machine. I'm assuming that I'd have to make an HTTP request to some PHP page which would then run the SQL to delete all the records, then append all the new ones. Is this the right approach? I don't want to spend weeks finding out that this is fundamentally flawed in some way. The client has an ADSL connection.
View Replies !
View Related
Passing Form Data To An Email Address/Excel Sheet On A Local Computer
I am right now learning PHP & want to know if there is a way to send web form data to an Excel sheet located on a network. My windows xp PC doesnot have a copy of Excel. Also i am not connected to the internet, its a local computer. What i am trying to do is to make a PHP script which will send a simple form data to an excel sheet (or create a new Excel sheet) on another PC on a network. Since i am not connected to the internet, i will not be able to send an email (anyway, sendmail is not available on Windows OS), nor do i have any server on windows. Is it possible to send form data to Excel sheet on local computer? Even my PC is a local PC. Some one was saying its possible thru Windows Scheduler.
View Replies !
View Related
Is It Data From The TEST Or From PROD And Will It Be Data From Database1 Or From Database 2?
<?php I have a question about 2 connection strings to a ms sql database. # TEST DATABASE $connecttest = MSSQL_CONNECT("TEST", "sa", "123456") or exit("Unable to connect to MS SQL Server at 10.0.10.58"); $select = mssql_select_db ("database1",$connecttest) or exit("Unable to select database TEST"); # PRODUCTION DATABASE $connectprod = MSSQL_CONNECT("PROD", "sa", "654321") or exit("Unable to connect to database at 10.0.10.59"); $select = mssql_select_db ("database2",$connectprod) or exit("Unable to select database PROD"); $SQL = "SELECT * FROM table1"; $RESULT = mssql_query($SQL); // What data will i find here? Is it data from the TEST or from PROD and will it be data from database1 or from database 2? ?>
View Replies !
View Related
Comparing Database Data And New Data
I am trying to create a PHP script that reads in a file, parses it for the data I want and compares it to the data I have in a database. The data is points and ranking information for a Folding@Home Team. Every week someone creates a news item with points gained by each team member for that week and other info. This is done manually and takes a lot of time. I hope for my script to automate as much of it as possible. The script was to run as follows: Download and parse latest statistics into 2D array Compare usernames in array to usernames held in Database Any new usernames and their respective points/rank to be added to database Compare points in 2D array of each user to those held in database. Output username and points gained I thought I had a working script until I actually tested it on real data, and realised I missed something rather obvious - the order of usernames from the parsed file is not going to be the same order as in my database - due to people moving up and down the ranks. So i can't just get a recordset from the db and run a simple loop to compare it to the parsed data. I am not sure how to go about comparing the database information with the parsed data that works around the fact the data could be in any order. The only thing i can think of is: foreach item in $parsed_data_array query database for $parsed_data_array=>username if(number of results == 0) build new insert query for current username else continue I don't know if this works [haven't tested yet] but I can't help feel it is a little DB intensive. There could be up to 200 queries being sent to the database. This can be minimized by adding extra criteria, like ignoring inactive users of course. Is this a viable solution or is there a much better way of doing this?
View Replies !
View Related
V4 And V5 On The Same Machine
We want to set up a PHP server for instructors to teach PHP, but different instructors have different needs. Is it possible to install PHP 4.3.8 *and* PHP 5 on the same machine? Perhaps using different ports or something to keep them separated? I have a Windows 2003 Server running IIS6.
View Replies !
View Related
Get Machine Name
I have a survey on my company website. I want to only allow each person to vote once a day. I can use $_SERVER['REMOTE_ADDR'] to get the IP address but we have a proxy server and that is the ip address that is showing up. Is there any other way to do this? I have been looking for a way to get the client machine name but have not had any luck.
View Replies !
View Related
Getting Data Into Database
I have a script which calls and displays items from my database, each item has a unique product id. The idea is that the user views the page full of items and clicks a checkbox or any efficient method (suggestions) to select one or more items they want to purchase. For each item they select i want the product id of each to be sent into my database into one field separated by commas. What i need for the next part of the script is some code which will work with the $ProductId's to do what i want it to. Code:
View Replies !
View Related
Data From A Database
I want to be able to use: <form action="arch.php" method="post"> List:<br /> <select name="list"> <option value="a">Ascending</option> <option value="d">Descending</option> </select> <input type="submit" name="submit" value="Go" /> </form> ?>
View Replies !
View Related
Data In Your Database
Firs of all, I'm thankful the programer for this code ( Storing Checkbox Data In Your Database ), it is very good, and I have tested it it was excellent, but there is two problems: always appear this message when I'm browsing your code : ( Warning: Missing argument 5 for make_checkbox_html() in c:apachehtdocscheckboxcheckbox.php on line 59 ) I did as you said, and I have designed the database and the tables name as you mentioned, and I have tested your code on your table that you mentioned, but nothing stored in the (lookup_skills) table, so please help me about these problems.
View Replies !
View Related
Data From Database Lag
I am having trouble on my photo gallery. Users have the ability to comment on a picture. That works fine, the info is put into the DB no problem. however when the page is reloaded or refreshed the last entry does not show up until another comment is made, at which point the newest comment still doesnt show up. I am not ready to just give out a password for everyone to try it to help me trouble shoot(site not secure at all yet). So I would like to PM someone a username and password. Let me know if you would like to. (preferably someone with quite a few stars under thier name).
View Replies !
View Related
Validation Machine
i created some php/mysql code, and want to offer it to ppl, but if they want to use it i want there to be a link at the bottom of the page, going to my site. here's the trick, i want the code not to work if the link is taken away. Code:
View Replies !
View Related
Installation Win Xp Pro Sp2 Machine
I've setup my pc as a development webserver with the following installed (on a win xp pro sp2 machine): apache - apache_2.0.54-win32-x86-no_ssl php - php-5.0.4-Win32 phpmyadmin - phpMyAdmin-2.6.3-pl1 tomcat - apache-tomcat-5.5.12 mysql - mysql-4.1.12a-win32 myodbc - MyODBC-3.51.11-2-win smtp (IIS) - XP SP2
View Replies !
View Related
Problem With COM On Just One Machine?
Running PHP 5.1.6 on a Windows Server 2003 machine, running as a CGI under IIS 6. I call a class in each of my pages that performs an LDAP query to automatically look up user name / email / other details (this is taking place on a company intranet). This works fine on every machine tested, except 1 - on which the code throws the following error: Code:
View Replies !
View Related
Ghost In The Machine
this is the second time this has happen now on two seperate products and it's very strange. I'll be coding away and then previewing my work through a browser when all of a sudden I get an number 1 appearing on the screen. it is not in the any of the php files but it shows up in the browser window.
View Replies !
View Related
Checkbox Data In The Database
I want to display the checkboxes taken from the database from table “const_skills”, but the checkboxes and its values do not appear ($html_skills). Can anyone figure this out. Below is the codes that I’ve been using. Thanks in advance. <?php include "dbinfo.php3"; function get_checkbox_labels($table_name) { /* make an array */ $arr = array(); /* construct the query */ $query = "SELECT * FROM $table_name"; /* execute the query */ $qid = mysql_query($query); /* each row in the result set will be packaged as an object and put in an array */ while($row= mysql_fetch_object($qid)) { $array[count($arr)] = $row; } return $arr; } /* Prints a nicely formatted table of checkbox choices. $arr is an array of objects that contain the choices $num is the number of elements wide we display in the table $width is the value of the width parameter to the table tag $name is the name of the checkbox array $checked is an array of element names that should be checked */ function make_checkbox_html($arr, $num, $width, $name, $checked) { /* create string to hold out html */ $str = ""; /* make it */ $str .= "<table width="$width" border="0">n"; $str .= "<tr>n"; /* determine if we will have to close add a closing tr tag at the end of our table */ if (count($arr) % $num != 0) { $closingTR = true; } $i = 1; if (isset($checked)) { /* if we passed in an array of the checkboxes we want to be displayed as checked */ reset($arr); while (list(, $ele)=each($arr)) { $str .= "<td><input type="checkbox" name="$name" value="$ele->id""; reset($checked); while (list(, $entry)=each($checked)) { if ($entry == $ele->id) { $str .= "checked"; continue; } } $str .= ">"; $str .= "$ele->value"; if ($i % $num == 0) { $str .= "</tr>n<tr>"; } else { $str .= "</td>n"; } $i++; } } else { /* we just want to print the checkboxes. none will have checks */ reset($arr); while (list(, $ele)=each($arr)) { $str .= "<td><input type="checkbox" name="$name" value="$ele->id">"; $str .= "$ele->value"; if ($i % $num == 0) { $str .= "</tr>n<tr>"; } else { $str .= "</td>n"; } $i++; } } /* tack on a closing tr tag if necessary */ if ($closingTR == true) { $str .= "</tr></table>n"; } else { $str .= "</table>n"; } return $str; } /* get the checkbox labels */ $skills = get_checkbox_labels("const_skills"); /* create the html code for a formatted set of checkboxes */ $html_skills = make_checkbox_html($skills, 3, 400, "skills[]",$checked); ?> <html> <body bgcolor="#ffffff" text="#000000" id=all> <br> <form name="skills" method="POST" action="insertskills.php3"> Check off your web development skills: <? echo "$html_skills"; ?> <br> <br> <input type="submit" value="Submit"> </form> </body> </html>
View Replies !
View Related
Inserting Data Into The Database:
I just don't get it, I have searched everywhere and can not find what I am doing wrong. I am familiar with SQL, but I typically use ASP, Access so this MySQL thing is very new. Here's my attempt at inserting data into the database: // Connection Strings $username = "-------"; $password = "-------"; $hostname = "localhost"; $dbConnect = mysql_connect($hostname, $username, $password) or die("Unable to connect to the Database, please try again."); mysql_select_db("database1") or die(mysql_error()); $theSQL = "insert into table (Item1, Item2, Item3) values "; $theSQL = $theSQL."('".$Item1."','".$Item2."','".$Item3."')" mysql_query($theSQL, $dbConnect) or die(mysql_error()); I know my connection is good, the problem is with the mysql_query line. I've tried it with and without the $dbConnect and neither works. What am I doing wrong?
View Replies !
View Related
|
TRACKER
