Ms-access Database Question - Allowing Web Access to the Informaton
kudmus
Apr 25 2008, 07:02 AM
Hi. I wanna know if there is a way of accessing an MS-Access database so that my site can extract data from it and make it avilable online. I have an accounting package that saves everthing in an MDB file and I want that info available for my clients from whereever thay are.
There seems to be an example of how to do this here, but it doesn't seem to work with the latest versions of PHP, and I can't find a lot of info about how to get it working. If you are desperate to have the information available, then you could just upload the database file, but it would only be accessible to people with Microsoft's Access application. Of course, you could also switch to another accounting program which stores its data in a MySQL database, or something else more easily accessible to PHP.
Hey thanx for the reply. That was real quick. Does it mean if I need to use MS-Access I have to use the old PHP? On the T17 sites is PHP not installed by T17. Do I get to choose? Forgive me if I'm asking silly questions but I havent started building my site yet. I'm just trying to understand so that i can start planning what my site will be about.
Hey thanx for the reply. That was real quick. Does it mean if I need to use MS-Access I have to use the old PHP? On the T17 sites is PHP not installed by T17. Do I get to choose? Forgive me if I'm asking silly questions but I havent started building my site yet. I'm just trying to understand, so that i can start planning what my site will be about.
I'm learning php in class right now, but I'm still not that good at it, what I'm
wondering is when I write the php so that it can connect with a database, can I at the same time
have it that it is able to display back images that I choose. Like, I want a search feature, where
you can search for a keyword, and it will bring back a list of all the possible entries with that
keyword, but each of these entries will have a photo associated with it. Now, do I put these image
files directly into the database, or do I write the code to link them from my files to th...
A search engine is provided to facilitate the user with undemanding and clear-cut search options.
The search facility includes simple search, search by title, search by word/phrase, ect… Thus, the
user is at a safe distance from the risk of selecting files/folders ambiguously. In addition, a
history of recent searches can be preserved for future perusal. Now
day’s visitors have a large option for his needs on internet and so visitors are not vesting their
time by following the dead links on your site. So a search engine is essential for your...
Hi all, I am sure all of you are great programers but First i am no code programmer i am just
trying to learn to run my sites, will the problem is i got a code from the web to protect my files
,1st i want to know how to work it out then i will try other things but can't let it go without
a fight thanx all php: CODE <?php if ( ! defined( 'myname' )
) { print "You cannot access this file directly."; exit(); }
customer data here ?> now i can't access my files what is the meth...
Can database column names start with a number or must they start with a letter like php vars? Like
my_table.1fieldname ? Does this vary from db system to db system? Is it considered good/bad form? ...
Ultimately simple script that allows you getting google search results to your localhost. This is
the first part of the Crawler script i'm developing, and if you are interested in developing the
script with me, IM me @icq328866661@msn/evil_matak/ a \hotmail-com. Here's the form
part... QUOTE search.php QUOTE if (@$_POST ==""){ echo "What are you
doing?"; } else{ $query =
file_get_contents("http://www.google.com/search?q=".urlencode($_POST
)."&num=100&hl=en&ie=UTF-8&filter=2"); //needs to be added with more queries ...
Hey all. Now i have a DB, an SQL DB, and i need to auto prune the data there to delete rows lder
than a certain time, lets say 2 months for now, the question is how do i do this? The obvious thing
is just to add a field which is the numerical representation of the month when the data is entered
and every time the DB is accessed it will check this number against the current month,in a numerical
format, and if the difference is two or greater that row is deleted, so if the month is January, it
would be O1 and if the current month is march then it would be O3 and the diff...
hi all , i have one big problem i need to know , how i can read xml file and then save strings in
xml in database for example its my xml CODE <?xml version="1.0"?>
<numbers> <arash>1</arash> <kiarash>2</kiarash>
</numbers> i want my soruce read this xml file and then save string into arash field in
mysql database for example in this source arash string is " 1" and kiarash string is "2" my fields
in mysql are standard and we have 2 field with names "arash" and "kiarash" please help me , if yo...
Hi all i want write backup system like Phpmyadmin export in single file , my question is what is
backup query ? i must write manul query for backup for example loop query to get string form
database and write into one file or php have backup query ? thanks /wink.gif"
style="vertical-align:middle" emoid=";)" border="0" alt="wink.gif" /> ...
I need help with a couple of things. First, I need to know how to retrieve information from a mysql
database and edit it then re add it to the database. I also would like to know how to easily delete
a mysql row. And I want this done without going to phpMyAdmin. Thanks for the help!...
I need help importing a .csv contents into a Mysql database. I have this. But its not working.
CODE <?php connection = mysql_connect("******", "**********",
"********") or die ("Unable to connect to server"); $db =
mysql_select_db("b9_259782_CC", $connection) or die ("Unable to select
database"); fopen ('csvranks.csv', 'r');
mysql_query("INSERT INTO test_table (id, name, guild, level, exp) ?> What
am I doing wrong? The mys...
Please help me. I'm building a group of database fro a program. the situation is like this:
'user' may have 1 or more class(es). 'class' itself may have 1 or more user in its
classroom. I'm bad at explaining... maybe like this: A program is made to write data of
classroom. Hikaru has a math class at Monday and statistic class at Tuesday. The math class itself
consists of about 50 students in a classroom. So, Hikaru (user ) may have one or more class at
time, math class (class) may have one or more students at time. So, basically I must mak...
I was looking for a quick solution so i could check a string for any symbols and stuff (basically
anything that isnt numbers and letters) in it. One of the first google searches that came up were
for a forum called "sitepoint". The thread was talking about the same thing I was trying to do.
This was their solution: CODE if (ereg("[a-zA-Z0-9]+",
$username)) { echo 'OK.'; } else { echo 'Invalid characters.';
} So i tried it out. Didn't work. I played with the code and i still couldn't get...
Hi all i write this code i want when you see download.php (this code) my file goes for download for
user sorry my english is not very good its a file database project for my university but when i
browse this code my soruce file (.zip) echo in my page and dont goes for download my next querstion
about safe mode i saw (php.net and zend) when safemode is on file databaseing and header() is not
working . is it true ? if is it true i save my file at hosting and no (database) i want write
standard script . plz help me thanks more and more CODE include("config.php&...
Can anyone show me example code of how to install a database table instead of me having to upload an
file with it in, so i can do it from a php page? Thanks in advance ;-)...
Right now, if i go to the cpanel of my site, I can access webmail of any of the email addresses I
have. Unfortunatly, I would prefer it if the administrators did not know the password to the
cpanel. I want them to be able to access mail from 1 of the email accounts. I have tried letting
all the admins access the account through their own cliants, but it became a mess, not knowing wich
admins have responded to which emails, because most emails are hosted localy when received by
cliants such as outlook. Then I had the idea of making one page, with webmail on it. Where...
I have a database, and need to know how to show the numbers of entries. So, if there are 10 entries
in the selected database table, it will show the number 10 . I'm pretty sure this should be
easy, but I don't know how to do it. Can someone tell me? /smile.gif"
style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />...
I have a folder on my hosting space..(i.e. public_html), i want to add this folder on my php page..,
. how it should be done that, when i add some file in the folder using ftp or anything , the folder
on that page automatically includes that file.for example , if the folder has 5 files..and on page
it says "folder has 5 files" and shows the files...and when i have uploaded 2 more files ,it should
automatically say that folder has 7 files.. ...
Is there any way to make such database where I can write like name and passwords.. Then make an
login box, and when somebody trys to acces the login he needs to write the name and password.. Then
it is verifyed if is there such name and password and if it is then acces the page.. I think there
is posible something like that with MySQL (db).. but can anybody say me a script or way to make
something like that? Alredy thanks.....
i'd like to make an automated database backup as following: 1- i would like to optimize my
databse's tables. 2- I would like to remove any existing backup tarfile. 3- I dump the database
to a /tmp file. 4- I tar the database dump and then delete it. i wrote the following shell: CODE
#!/bin/sh rm -rf /tmp/mybackup.sql.tgz mysqldump -uroot -pmypass --opt mybackup >
/tmp/mybackup.sql.backup cd /tmp/ tar -zcvf mybackup.sql.tgz mybackup.sql.backup rm -rf
/tmp/mybackup.sql.backup ...
I'm planning on a site redesign, and I'm going to add some very basic php includes in there,
because I've managed to figure out how to do them. I wanted to use them to do includes of my
navigation, so I'd only have to update in one place when new links are added, as opposed to
having to update several pages all at once. I'm not sure what else php can be used for, and I
did a search on it, and it pretty much all said includes and databases. Well, databases, I
don't know how to make, and I was wondering if it's really worth my time to figure i...
The code below is suppose to restrict access to pages without proper username and password.
I've copied it word for word from a book I bought and I've tested it offline. I've
already entered appropriate values in the database and nothing is wrong when I query. The problem
is when I enter a wrong combination of username and password nothing happens when it should go back
to index.html. Also when I correctly entered the username and password secretpage.php doesn't
display anything. I'm guessing it has do with the setcookie function in login.php or ...
Hi PHP geeks, Do you know if php has Database extraction layer? like Java has. Which is used for
development of database layer, so it become easy to change the database if you wish to without
modifying so much code underneath.... Any ideas is welcome. I am sure there should be something
which is being used and reliable and mature. I am new to PHP so want to use it if it is there. Good
to know from experienced developer about there developing experience. Thanks in advance....
I have just made a script that deletes a row in a mysql database using an image as a button.
However it will only work in FireFox and not in IE. Can any one see away around this and help me
root out the problem. This is the script in short: PHP Code: CODE $query_products =
"SELECT * FROM manufacturer ORDER BY name ASC";
include('external_files/pagination.php'); // If the form was submitted, delete
the items selected from the database
if(isset($_POST['delete'])){ $query = 'DELETE FRO...
Okay, after a week, I have successfully created a personal web blog. I first created it using a flat
text file, I but realized that it was just too limited like that. So, I redid it in a
database-compatible manner. NOTES: CODE - This blog does not support comments yet. If you
want, you can build on this script by creating a comment system as well. I may also update it
with a comment system in the future. - You should have an average to intermediate knowledge of
MySQL commands and database manipulation in general, especially if you want to add a ...
Php Classes
- Access the same class instance over multiple pages (1)
Hey everyone. I am having some trouble accessing the same php class instance in more that one page.
This is for my login script and what i need to do is be able to call the classes logout function
from a separate page. What i have tried to do is create a new .php page and include the class file
and then make a new class and call logout. This does not work because it does not log out the
current user which is my problem. Can anyone help me fix this or know of another way to do it?
Below is my class file CODE <?php // member class // handlers member logo...
I am having trouble formatting my table to display the results of a mySQL query the way I want.
Here is the part of my code: CODE $result = mysql_query("SELECT * FROM uploads
WHERE Category='Drama'") or die(mysql_error()); ?> <table
cellspacing="2" cellpadding="2"> <tr> <th>Title</th>
<th>Author</th> <th>File</th></tr> <?php // keeps
getting the next row until there are no more to get while($row = mysql_fetch_array...
I'm making a forum and I've had several problems tonight which I've come here to ask
then found the answer to myself, but this one is stumping me. Whenever it goes to write the post to
the database, it saves the poster, and the time, but the part where the message would go is empty.
Here's the code, with comments about what it's supposed to do (what I wanted it to do and
thought it did): CODE $imsg = stripslashes($_POST['msg']);
//Get message if(strlen($imsg) > 5 && strlen($imsg)...
I have a simple database with a php form thats inserts the info into the database, and another file
that extracts the info to display the info on another page.... Now my question is ......how do i
add the EDIT button to edit the database??? here is my database CODE CREATE TABLE `businesses`
( `id` int(10) NOT NULL auto_increment, `business` varchar(255) NOT NULL
default '', `description` text NOT NULL, `emailaddress` varchar(255) NOT NULL
default '', `website` varchar(255) NOT NULL default '', ...
Looking for ms, access, database, allowing, web, access, informaton
Searching Video's for ms, access, database, allowing, web, access, informaton
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!"
Register FREE for AD-FREE
forum, Create your own topics, Ask Questions, track topics, setup
subscriptions & notifications and Get a Free Website w/ Email and FTP.