Read Data From MS Access Into MySQL In Real-time
I am currently working on a project that involves reading information from a inventory system into Access via ODBC and display the info on the web site using MySQL.
I would like to create a live link between the MS Access(local) and MySQL (remote) whenever the inventory system is updated MySQL will be updated as well.
I know that MyODBC will let me do the opposite of what I would like to accomplish by reading data in MySQL into Access. Is it possible to do the reverse way.
View Complete Forum Thread with Replies
Related Forum Messages:
Email With Attachment - Annot Be Accessed. The File May Be Read-only, Or You May Be Trying To Access A Read-only Location.
It is a basic email with an attachment. The email and attachment are getting sent and received ok. When the recipient tries to open the attachment, the right application opens (eg. Excel) but then throws up an error. I am using base64 encoding. For example: .xls file with base64 encoding: 'testing.xls' cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding. .pdf file with base64 encoding: There was an error opening this document. The file is damaged and could not be repaired. so the file isn't being decoded right. I have tested on Yahoo and Outlook. PHP Code:
View Replies !
Real-time Output?
I'm a relative PHP newbie, so I apologize if this is a simple question. Anyway, here's my problem. I'm using a PHP script to pre-render a bunchload of insert files for an HTML page. Right now there's about 1,600, but that number could get much, much higher when the site goes live. I'll only need to re-render the whole batch once or twice a year (if that) but it's still something I'd like to be able to do in case I have to move the site to a different server, or there's a hard drive crash or etc. Basically what the script does is grab a whole bunch of information from a database and write the insert file. It does this for every single one. The problem of course, is that PHP by default does all this server-side, and then sends it to the browser. Because this process takes like ten or twenty minutes to do, the browser times out long before it's finished. Is there a way to get progressive output with PHP? Or do I need to re-do this in another language like Perl?
View Replies !
Real Time Chat
There's anyone out there that can give me a light on real time chat using sockets. I've seen some using push technics but they all hang up after an elapsed amount of time.
View Replies !
Real-time Clock
Where should I start to write a Real-time Clock? I want it be dynamic, not static. I know how to get the time and display it but how do I keep changing it ?
View Replies !
Real-time Chat
I wrote a PHP chat system similar to gChat which simply uses constant ajax calls to update the chat. This system is fine for a few users, but with potentially thousands of users, it is much too hard on the server. I've been considering taking the 'Comet' route, but have heard that PHP can't handle Comet very well. What would be the best language/API to perform real-time chat for a large user-base?
View Replies !
Real Time Sql Query
I am making a web-based chat but to get the msg from the database i need to refresh the page and that will make load and extra bandwidth on the server so i want to make the query in real time ( only the new msg to be received without refresh the whole page ), Any one in here knows how to get data from sql database without having to refresh page.
View Replies !
Real Time Echo'ing Of Var In A Loop
i have a big loop, and rather then waiting until its done for me too see what happened, every time it runs, how can i get the browser to echo the result, and proceed to keep running the loop. basically this loop takes a long time to finish, and i had to set my max runtime past 30 seconds. i guess incorporating a refresh of some sort like this would eliminate the need for the time extension too?
View Replies !
Real Time Form Update
i have a script that i wrote for my clan/guild/linkshell in this online game i play that keeps track of members, the points they receive from events, items etc. in the admin panel of the script where you can update peoples points i want to know if i can add a button or something similar that if you push it updates the points which is currently in another text box in the same form in real time. I'm sorry if i'm not being clear, what i'm trying to do it make it quicker to update a members points because usually after each event they receive either 10 or 20 so i want to add a button where if you push it then it will put 10 or 20 in the 'add' box in real time. right now when you edit a member it shows their current points in a text box and under that two text boxes, one if you want to add points and another if you want to subtract points. if this isnt possible then i assume that i'd have to make it update the points in the box and keep all the values from before and just reload the page with the new value inside the box. wow, i'm sorry if i'm not very clear, please ask questions if you dont understand what i'm trying to say.
View Replies !
Real-time Action Ala Games??
What would be a proper solution for automated decision making in a PHP script, like a game? That is, without an external application, or any human input. For example, any random event that happens when the player is away from the game. How would one go about implementing that?
View Replies !
Real Time Listbox Update
I have one listbox that I populate with while($row = mysql_fetch_array($result, MYSQL_ASSOC) I need to in real time populate another listbox from a related table based on what they have currently selected in the first listbox. Is this possible with php and if so.
View Replies !
How Can One Get Real Time Stock Quotes For An Online-community?
For one of our web-communities we plan an offer of real time stock quotes incl. advanced notification services. I have the following questions: - Do you know of any services, that already offers such services in a decent way? And more important: - Does anybody know a provider of such services, that offers a real-time stock quote data stream for such a usage at a decent price? I only know of Deutsche Börse offering it for 1駨 Euro per month. That is too expensive for us.
View Replies !
Best MYSQL Data Access?
I was just wondering if anyone had, or knew of a good MYSQL dataaccess layer for PHP. I am using the smarty templating system, which mainly handles arrays and such so if anyone has any ideas.
View Replies !
Hiding MySQL Access Data In Php File ?
If I connect to a mySQL database with php I have to write the access data into the php file,eg.: $hostname = "my_host"; $username = "my_name"; $password = "my_pwd"; $dbName = "my_db"; $userstable = "my_table"; MYSQL_CONNECT($hostname,$username,$password) OR DIE("Unable to connect to database"); Is this secure ? In other words: can it be read by a bad boy ?
View Replies !
Using PHP To Migrate Data From Shared Access Db To MySQL
I've read some online resources that utilize various MySQL command-line actions to migrate data from Access to MySQL. The situation is this: a group of co-workers of mine will be using an Access db in a shared source (for now, a directory.. ???) to be able to generate reports on the fly. What they want to do is to be able to migrate that data to a MySQL db instance that currently exists on a different server. What would be the best way to do this within a PHP wrapper (if even PHP at all, which I prefer); if so, what are the ways I can ensure security as this is US Federal Government data and thus must be locked down tight?
View Replies !
How To Grab MS Access Data Into Mysql And Vice Versa?
I'm developing an online ordering system, using PHP and MySQL database, which requires me to integrate with MS Access database to get some data . for example : application status. fyi, another system is developed using ASP and MS Access database to keep track of the application status since the status are always changing. i have to grab the application status of a particular record and update the MySQL database. this has to be done sort of the 2 databases are 'linked' together. any update/new records inserted into MySQL will be known by MS Access and any status update in MS Access will be known by MySQL. something like that.. is it possible to link the 2 different databases?
View Replies !
Mysql Real
I found this which I think calls for an indepth brain storming. A very good reading [edited by: eelixduppy at 1:06 pm (utc) on Sep. 12, 2007] [edit reason] fixed typo as per request [/edit]
View Replies !
I Am Trying To Read Access Log File
My access log file is has more then 8 lakhs lines. I am trying to read the log file and populate the data in database. But due to long file I am not able to read the file after certain time. It is showing an error: Code:
View Replies !
Read & Full Access
We have a login page that we have people login to access information. We want to be able to deny access to a certain link depending on what password they enter. the login informatin is pulled from the DEALER_NUM and PASSWORD field in the table. I have created a field called PASSWORD2 which is what we will be using for the special access if thats what you want to call it. Code:
View Replies !
Mysql Real Escape
Upon entry into the database, I first clean form input data with html special characters, strip tags, and mysql real escape string. When I retrieve this data from the db, single quotes aren't coming out right on the pages. Some browsers display a question mark, others a blank space, and another (FireFox) totally screws up the text formatting.
View Replies !
Access/read Log Files That Are On Different Servers
I am trying to access/read log files that are on different servers (not web servers) to my scripts but don't seem to be able to access them. I get the following error: Warning: file("IP_Addressdredrent.log") - No such file or directory in c:inetpubwwwrootAutoreportslog_processingcheck_dre_query_log.php on line 15 I am using Windows 2000 and IIS. Code:
View Replies !
Read/write Access To All The Files
I recently made a php app for a company that spiders through a server and finds all files of a specified type (html, etc) and then opens the files and does specified things to them. So, the tool needs to be placed on the server and then it needs read/write access to all the files. It works fine on my local server, but the client says that it fails (message is "failed to write to file" and then it stops). I told him to try it with ALL files and folders set to 777 just for testing purposes and he says that it's still not working. I have no idea what to suggest.
View Replies !
A Real Challenge For Real PHP Programmers
<?php /* A challenge to every PHP programmer.The one who's gonna solve this problem would be deemed as PSP(PHP Supreme Programmer).The problem is this : You have to write a script that displays a list of categories and subcategorieslike this one: <select name="category"> <option value="1">Main</option> <option value="2">Main > Computers</option> <option value="4">Main > Computers > Hardware </option> <option value="8">Main > Computers > Hardware > PC</option> <option value="7">Main > Computers > Hardware > Mac</option> <option value="9">Main > Computers > Hardware > Atari</option> <option value="11">Main > Computers > Hardware > PC > History of Pc</option> <option value="">etc...</option> </select> The categories and subcategories details are stored in these two tables in a MySQL database. -categories : the categories names and ids. -cat_relations : the relations between categories.It shows which subcategory belongs to which category. The belongings between categories can go very deep and the number of categories is unlimited. This script will create the two tables and fill them with sample data. All you need to do is to change the four variables below. You can send the script back to this email : yasbergy@yahoo.com. */ //Here starts the script. Please change the values of these variables to fit your settings $user = "prospective_PSP"; $database = "db"; $server = "localhost" ; $pwd = "" ; //Connection to the database that you created mysql_connect($server,$user,$pwd) ; mysql_select_db($database); //Creation of the two tables : categories and cat_relations $categories = " CREATE TABLE `categories` (`id` INT not null AUTO_INCREMENT, `name` VARCHAR(100) not null , PRIMARY KEY (`id`), INDEX (`id`), UNIQUE (`id`)) comment = 'The categories details' "; mysql_query($categories) ; $cat_relations = "CREATE TABLE `cat_relations` (`id` INT not null AUTO_INCREMENT, `daughter_id` INT not null, `mother_id` INT not null , PRIMARY KEY (`id`), INDEX (`id`), UNIQUE (`id`)) comment = 'Which category is the daughter of which category'"; mysql_query($cat_relations) ; //Filling the two tables with sample data $cats = array('Main','Computers','Countries','Hardware','S oftware','Programming languages','Mac','PC','Atari','Winamp','History of the PC','IBM','Components','High level','USA','NYC','LA','Manhattan','India','Winzi p'); for ($i=0;$i<count($cats);$i++){ $sql = mysql_query("insert into categories (name) values('".$cats[$i]."')"); } mysql_query("insert into cat_relations (daughter_id,mother_id) values (2,1),(3,1),(4,2),(5,2),(6,2),(7,4),(8,4),(9,4),(1 1,8),(12,8),(13,8),(10,5),(20,5),(14,6),(15,3),(16 ,15),(17,15),(18,16),(19,3)"); //Now you can have a look on them through phpMyAdmin ?>
View Replies !
MySQL Result To Real Array In Function
I'd like to create a function which input is the result of a mySQL query. The output should be exactly the same, only not a mySQL result array, but a 'real' array. So it should also get the fieldnames returned by mySQL and use those as keys. I can't get things to work properly: it should return a multidimensional array, like $result_array[1] = array( [field1] => field1 value, [field2] => field2 value, etc. ) somehow my result is (with code below) $result_array[1] = array( [0] => field1 value, [field1] => field1 value, [1] => field2 value, [field2] => field2 value, etc. ) +++++ code ++++++ $get_res= mysql_query(QUERY); if( $res = mysql_fetch_array( $get_res ) ) { do{ $result[] = $res; }while( $res = mysql_fetch_array( $get_res ) ); }; foreach( $result as $key => $value ){ print_r($value); };
View Replies !
Real Life Examples Of Mysql+session_set_save_handler
In my test setup using my own session handlers with session_set_save_handler and mysql, the session handler opens and close mysql connections. But what if my page also requires some mysql queries? Should I open a new connection or use the already opened one (opened by the session handler)? I have made it a good practice to close a connection after a query but if I do it with only connection open no session data will be written to my mysql table. I have seen some scripts using persistent connections but are not sure what would be the best for a real world environment.
View Replies !
Restricting File Read Access To Users But Not Server
I`d like to know if it is possible to place a products.dat file on my website, yet restrict users so that they cannot see or d/l the file, but they can access it through a php file which is run by the web server which has the only access to the products file when browsing. Does this make sense?, its basically client server, but since my php knowledge isnt great yet, Im not sure if this is easy or not?
View Replies !
Save Real HTML Tags Into My Mysql Database.
I want to save real HTML tags into my mysql database. I use $p = htmlentities($content); to convert the strange characters to real html. Then from another page i echo the content from the database and i see real html tags which is what i want.But in the database its still saved as:
View Replies !
Mysql Real Escape String() In Conditional Statements
I created the following bit of code that allows me to pass a MySQL conditional statement to a function. I am trying to figure out where and how would I go about incorporating the mysql_real_escape_string() function? Is there a way to call the mysql_real_escape_string() in the function itself? Code:
View Replies !
How To Search Strings Escaped By Mysql Real Escape String()?
I am currently developing an article script and there are Titles and Contents. To prevent sql injection, people say we must use mysql_real_escape_string(). So let's say if there is a Title that says "My Friend's best friend", if I look into the MySQL table record, the text will be saved as "My Friend's best friend", where the apostrophe is escaped. Code:
View Replies !
In A Loop Read 3 Characters At A Time
I have a string, say it's 26 characters long. How would I read 3 characters at a time then move on to the next 3. For an example: $my_str = "ABCDEFGHIJKLMNOPQRTSUVWXYZ"; How would I read "ABC" then go to the next block "DEF" and so to the end?
View Replies !
Db Update And Real Time Update
i wanted to put together my first pages using prototype but i'm kinda stuck. situation: i got a list of pages in the backoffice. in the list you got pagenames, id's, editors and if they're active or not. the active part part is represented by an in/active image. now instead of having to edit the page and change a checkbox to toggle the active status of the page, i was planning to make it able to click on the image in the list itself to toggle the status of the page. thus updating the db when you clicked and refresh the list using ajax. Code:
View Replies !
Last Access Time
I have a forum script. I set a cookie in the users' computer to record the last access time. Then, I make use of this time to mark certain topics as "new". Meaning, if the topics are created later than the last access time stored in the cookie, that topic is marked as "new" by showing an icon beside the topic. Now, I have a bit of problem. I need to achieve another effect. Let's say I visit the forum now, and there are 3 "new" topics. I clicked on the topic, view the posts, and then I go back to the topics page again. Because the last access time is only updated hourly instead of constantly (meaning it's only updated every hour, not every invocation of the script), the topic I just view is still "new". What I wanted is, if I just viewed this "new" topic, when I go back to the topics page, this topic should no longer be "new" (unless there's a new reply, of course).
View Replies !
File's Access Time
I have devised this simple class that just iterates a directory, looking at the stats() of each file. If the aTime or mTime is different than the last time it checked, then it alerts me to unofficial activity. Good in theory. Problem is that when I download a file with my FTP client, it doesn't update the aTime. Same if I view a live web page, it doesn't touch the file. Seems I misunderstand the meaning of accessTime.
View Replies !
Retrieve Short Time Out Of MS Access
When I retrieve a time field out of MS Access. I get a negitive 1 The Access is 2000 can anyone help? $Query="SELECT * FROM tEvents where start_date between #".$given_b."# and #".$given_e."# order by start_date"; $rs->open ($Query, $DB_Conn, 3 ); // 3=adopenStatic $start_time = $rs->Fields['start_time']->Value; $end_time = $rs->Fields['end_time']->Value;
View Replies !
2 People Try To Access The Same Text File At The Same Time
If 2 people try to access the same text file at the same time to write to it - what happens in PHP. What I mean is - presumably the first will be. But what will the second person actually see in his browser. And what will php do about it if not specifically programmed to deal with it ie whats the default behaviour.
View Replies !
Read Raw Post-Data In PHP
I need to read the RAW DATA that is sent using a HTTP-Post Command in PHP. I cannot User $HTTP_POST_VARS since the Data is not associated with a particular variable.
View Replies !
CGI (in PHP) Can't Read POST Data
I am trying to have a CGI script write text to a file based on input from a form. However my write.cgi's $_POST is empty. Whenever I use write.php for the action of the form $_POST has the correct data. The form uses POST method. I want to use write.cgi because only cgi scripts can write to files in my server (run by suexec) I have been researching this for two days now
View Replies !
Read Data From Txt File
I wanted the script which works as a catalogue page but in php and use txt file as a database . Product name and description is stored in txt files . Result should be display as following Product a Product description Product b Product description and so on if pagination in this script is possible so it would be great. The structure of a file will be like this Product A, Product A description Product B, Product B description
View Replies !
Read Data From File
I need to read data from text file with 20 lines each line with some text In the beging I want to read only the first 5 lines, and insert each line content into object. i.e $line1 = first line $line2 = secound line....... Can someone help me with writing the code?
View Replies !
MP3 :: Read The Data From The Idv3 Tag
I have a fairly large music collection in the form of mp3, what i am wanting to do is store all the tracks, albums and artists in a mysql database. Then manipulate to the data to a presentable format. What i wanted is a php script that would be able to read the data from the idv3 tag in mp3 and then input into the mysql database, to save inputing the data.
View Replies !
Can't Read Data From Array
I have a form having a row of three text fields and under this row an add and a remove button are there. I have declared the names of the three text fields as array. By clicking the Add button a row of these three text fields are created just under the first row with the help of Java Script and increase with each click. And the remove button remove one row per click. The problem is when I fill with more than one row and click submit button I cannot get information from the array of the name of those fields other than first row.I have used count() to read. Code:
View Replies !
Mail Function PHP Must Have Access To The Sendmail Binary On Your System During Compile Time.
i'm almost 100% sure my code is good as I basically copied and pasted the same code I had working on my web server. Now, I have it setup to email a form from a network server php file. The problem is that it isn't working. Neither is a header Location line either for that matter. I'm wondering why this is. Could it be because somehow these require php libraries that they don't have access to? It works fine on my web server. I found this snippet on the mail function: Quote: For the Mail functions to be available, PHP must have access to the sendmail binary on your system during compile time. If you use another mail program, such as qmail or postfix, be sure to use the appropriate sendmail wrappers that come with them. PHP will first look for sendmail in your PATH, and then in the following: /usr/bin:/usr/sbin:/usr/etc:/etc:/usr/ucblib:/usr/lib. It's highly recommended to have sendmail available from your PATH. Also, the user that compiled PHP must have permission to access the sendmail binary.
View Replies !
|
TRACKER
