PHP :: Allow Access From Just One IP

PHP & MS Access?
I'm asked to connect an existing Access DB to a site with PHP. There are some programs that work around that DB (CRM etc...), so if I upload the whole bunch to our hosting server, we are no longer able to access the db off-line from within these programs, right? So what might be the solution? Migrating to MySQL, converting the DB and doing everything on-line (I prefer working with MySQL, but what about the other programs then?), or doing everything off-line like we used to and uploading it the whole time (daily, so not very preferable). Or...?

What do you think? Forget Access, go MySQL? Off-line / on-line?

Access DB
I was wondering as a new programmer to PHP if MY SQL is the only DB that PHP will work with, the reason I am asking is I am use to using access DB's when I was programming with iHTML and ASP.

PHP & MS Access
I wasn't sure if this belonged in General Databases or PHP, but I'm putting it here in hopes that some PHP guru's will have a little experience with this.

I'm building a site for a new client and they already have a host and domain configured.

The plan was to use PHP/MySQL for the entire site, except their host doesn't support MySQL on their Windows servers. (It's a Windows 2003 server BTW).

The only DB support they have on my client's current plan is Access, FoxPro and DBase. I have extensive experience with Access but not for web applications. One thing I do know is that Access is far from speedy.

Which brings me to my question -- do you think I should move ahead with Access and PHP, or try to transition over to a Unix server and get MySQL? They already have three domains on this host, all of their email, etc. It's a small business and they can't afford to give up their email for long.

Whil I think Access would suffice for the time being, how much traffic do you think a PHP/Access site could handle and also do you think it would be a smooth transition to move the Access DB to SQL Server if/when the traffic demands the change?

SQL Server requires additional money so it's not a reasonable option at this point without a great reason.

MS Access
I have a database in MS Access; is there any way to use the database
in a PHP script?

PHP And Access
I know PHP can work with MySQL, but does it work with MS Access?

Php/DB Access
Ho un db in Access da mettere in rete. Sono riuscita a fare il
collegamento e a interrogare il DB, sembra funzionare tutto
perfettamente tranne per un importantissimo particolare...non riesco a
visualizzare le immagini. Queste sono in formato jpg e sono state
inserite nel DB tramite collegamento ipertestuale.
Qualcuno riesce a darmi una mano?

Access, Php, Ado
I need to learn how to connect to an access database using ADO with PHP. ODBC is not an option. I anyone could point me to some tutorials, or give me some example code that would be great.

PHP And Access
I have an access database which I used to demonstrate Java - ODBC
connectivity and it works fine.

I tried to access the same DSN (system DSN) thro' PHP and the
following error is displayed.

Warning: odbc_connect() [function.odbc-connect]: SQL error:
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified, SQL state IM002 in SQLConnect in
D:AjithTeachingPHPExamplesphpdbmstest.php on line 8
Connection Failed:

Database is there, DSN is defined, can access the DSN via Java but not
with PHP.

PHP + MS Access
I want to know if PHP can connect to a MS Access 2002 Database? If it is possible what is the script to connect PHP to MS Access?

PHP And MS Access + XML
I have resords in an access database. I want to retrieve them using php
and generate an xml file with them. I can retrieve the records and
generate an xml file but the xml file contains no data.
This is the code im using:
PHP:

$query1="SELECT * FROM cust";
$result=odbc_exec($conn , $query1)or die("Query failed: $sql<br
/>Error: ".mysql_error()."<br />");

$xml = ''
$xml .= '<?xml version="1.0"?>'."
";
$xml .= '<!DOCTYPE customer SYSTEM "customer.dtd">'."
";
$xml .= '<shop>'."
";

while($row = odbc_fetch_row($result))
{

$xml .= '<customer>'."
";
$xml .= '<customerId>'.$row['custonerId'].'</customerId>'."
";
$xml .= '<name>'.$row['name'].'</name>'."
";
///$xml .= '<address>'."
";
$xml .= '<addressline1>'.$row['address1'].'</addressline1>'."
";
$xml .= '<addressline2>'.$row['address2'].'</addressline2>'."
";
$xml .= '<addressline3>'.$row['address3'].'</addressline3>'."
";
///$xml .= '</address>'."
";
$xml .= '<phone>'.$row['phone'].'</phone>'."
";

$xml .= '</customer>'."
";

}
$xml .= '</shop>'."
";
$xmlfile = "C:phpdevwwwjimcustomers.xml";
$myfile = fopen($xmlfile,"w+");
fwrite($myfile,$xml);
fclose($myfile);

odbc_close($conn);

and this is the XML it generates

<?xml version="1.0" ?>
<!DOCTYPE customer (View Source for full doctype...)>
- <shop>
- <customer>
<customerId />
<name />
<addressline1 />
<addressline2 />
<addressline3 />
<phone />
</customer>

PHP To MS Access?
i'd like to know if PHP can be used to connect to MS Access? and if it can be used, is it the same way to connect to MY SQL?

Log In Access
i needed a login page for my website, so i found a code on gooogle, http://www.devshed.com/c/a/PHP/Creating-a-Secure-PHP-Login-Script/ that is what i found, i know i am probably using this rong but can some one tell me how to put it all together.

No Access To Php.ini
I have script which requires some of the php.ini settings to be modified.

eg error reporting etc.

I dont have direct access to the php.ini file on the production server

I know I can override the .ini settings using

<? ini_set("error_reporting", "some value"); ?>

So what value can I use in my script to replicate the setting below?

My .ini file on my testing machine has

error_reporting = E_ALL & ~E_NOTICE; display all errors, except notices

Access And PHP3?
Is it possible to use a MS Access database with php3?
If "yes" any help how to begin?

Root Access
If I want to add a column in a existing table in a php script, do I have to have root access?

MySQL Vs MS Access
Thats right, I did say MS Access...

Excuse me for not putting this in its proper MySQL forum, but I have seen some great debates recently transpire regarding technology choices, and I am in desperate need of expert opinions!

My employer was recently bought out by another web development co. that unfortunately (for me) they specialize in ASP development... The funny thing is they don't even utilize MS SQL Server, they use MS Access. At first, I was astounded... Did they know something that I did not... Even Microsoft themselves have put huge warning signs all over their MSDN regarding Access's use over the internet...

I was scared to even suggest this to the managers, for fear that they knew some way of avoiding the fact that Access does not possess the power that MySQL or SQL Server (for that matter -at least) do!

In fact, I was dead wrong... They didn't know a thing! I even got in a debate with the lead Access "developer(?)"... He didn't consider MySQL to be a relational database because it 'did not support cascading modifications or referential integrity'... As well as it does not have a GUI considerable to MS ACCESS... I really just wanted to laugh at him, but I instead argued the usual points regarding portability, cost, as well as its close partnering with all of the available PHP functions for MySQL.which lead to a faster more effecient development process.

I know that this message seems a bit on the immature side, but I am honestly not sure how long this company will survive if they are telling their customers to use Access (we just got contracted to do a large financial provider's website today - the managers are actually considering to advise Access!)...

Anyone that can help me bomb these clowns with success stores (MySQL) or disaster stories (Access), as well as any other info, I would greatly appreciate it.

Limit Access
I have a admin page (password protected) and many other auxialary files the admin center needs all in the same directory. Is there a way to make the auxilary files accesible to the php script but not to other users?

We Can Use/access ActiveX?
1- I have heard that we can use/access ActiveX
components in PHP. So how can i access them?

2- I want to use DataGrid/FluxGrid kind of ActiveX in
my page for displaying Records, So can i use
DataGrid/FluxGrid for this purpose?
if (yes)
{
How?
}
else
{
Why Not? and which other Availabe component can help
me like DataGrid in PHP.
}

3- What is the Strength of PHP? Means that to how much
extent we can go in it.

User Access
Can anyone help me with user access? I want to have different levels of access for users. For example; when I create accounts for users to og into my websitem, I want to be able to specify the level of access they will have. Let's say user A can access pages 1,2&3 and user B can access pages 3,4&5. I would like to have check boxes that I can check to allow them access to the specified pages!

Access Previous URL
I want to know what was the previous page my users browsed, is this possible? I though I could do this with getenv('HTTP_REFERER'); but that only seems to have a value when the user clicked a link. Is it possible to know the previous site no matter how the user landed on the page? Also, is it possible to retrieve the url of a frameset that is loading my page (either through normal frames or iframes)?

PHP And Microsoft Access
Is it possible to use php to interface with an ms access database?

Our current database (customers, suppliers etc) is in ms access format and we need to run msaccess. I dont feel like converting the whole database over to mysql and we still need the original system, the idea will be that the staff can access the database on the road thru a webpage.

Access Rights
i want to know whether we can programatically give access rights to users while creating them. for eg.in the HR package i have three categories of users i.e. employee,Head of the Departments and director Personnel.

all three will have different access rightsfor each form.i want to make a system which when creating a user asks for the access right for each form to be given.and then displays the menu according to that.

DB Access To DB MySQL
How is the simply way to transfert a DB Access with PHPMyAdmin to a DB
MySQL? Exporting each table from access in format .csv, I have a little
problem to insert them correctly with PHP my admin.

Page Access
I have a 3 page PHP script. I only want people to be able to access the
first page of the script by URL. The other 2 pages need to return a
message such as "This page can not be accessed directly." if someone
tries to call it up by URL.

I did this a month or so back using an If statement at the beginning of
the PHP code. Something along the lines of:

if (access_method=POST){
Perform PHP Code
}

Else{

echo "This page can not be accessed directly.";
}

I just can remember the correct method to call to check against, and I
can't find the old script I worked on previously.

Dbase Access
I'm using Apache+php+win98. I need to access some dbase tables from my
scripts eventually adding/modifying records. I know I can use
succesfully a Microsoft Visual Foxpro ODBC driver, already installed
with win98, in order to read records. But I'm not sure whether is it
possible to lock dbase tables when adding/modifying records with this
kind of drivers. Can someone give me a hint?

An alternative approach would also be welcome

Access In Conjunction
I'm using the myODBC driver to get my MySQL database into access, but have a couple of minor issues there, can download it once, but can't seem to perform an "update" of the existing tables..etc.. perhaps something simple I need to do..

Other things I seem to be having problems with are creating list boxes.. I can make the box, and get "part" of what I want, but can't seem to get the value to "properly" match up to the keyID value from the "table".

Access Protection -how To
I need to query a database for users with password and retrieve these
with a third variable, "level". That's easy.

username, password, level

If entered username and password exist, get these and the
corresponding level from the db.
This array of data should then be used in order to access one of four
web folders ONLY. This folder should only be accessible for those with
username and password and level matching from the row in the db.

It would be easy to limit access with .htaccess / .htpasswd in the
folder, but it's hundreds of records with users and passwords which
belong to one of four levels.

So how to solve this access protection?
(I am a really newbie, please be patient. I jus't need a solution to
this, hopefully with code. The server runs Apache - Fedora and php
4.3.9).

I Haven't Access To Mysql NG
I haven't access to Mysql NG, so let me ask here.

Query:

select distinct a,b from a left join b on a.id = b.id

table b:
id datefrom dateto
1 2005-01-01 2005-01-15
2 2005-01-02 2005-01-16
1 2005-01-17 2005-01-31

In my case, I'd like to show the last date for any ID.
So the result:
1 2005-01-31
2 2005-01-16
3 -

How to do so ? In my case, I get two rows for ID 1

Must I run 2 queries ? It's really hard to create a query with GroupBy, as
the real query takes 20 fields

Htpasswd And Ht Access
1.I created a password file named passwords and also an htaccess file naming Accessfilename.ht access.
2.My Accessfilename.ht access is placed in the folder where my php scripts are saved.
3.Now, when i try to run my php script, it does'nt pop out for an user and a password.

I dont see any errors when i restart my apache. I followed step-by-step procedure, but still it does'nt work.sounds really weird!!

File Access
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:

Using PHP To Pull From MS Access DB
I've been trying to create a simple (I hope) PHP application to send
emails to a membership list. I have yet to successfully connect to my
database to pull the names and email addresses. I'm running XP Pro,
PHP Version 4.3.2, Access 2000. I have created an ODBC System DNS
connection to the database file I want to access, And I get this error:

Warning: SQL error: , SQL state 00000 in SQLConnect in connecttodb.php
on line 2
Whoops! Could Not Connect to ODBC Database!

Here is my code:

<?php
$odbc = odbc_connect ('DFWMembershipDB', '', '') or die('Whoops! Could
Not Connect to ODBC Database!');
?>

Connect To MS Access
I am trying to connect to a MS Access database with PHP. I have set up the dNS but cant seem to open the database. Do I have to make any adjustments in my php.ini file.

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).

Chmod Access
I have root access to my LINUX server and I want to know what I need to set up on the server to allow me use PHP coding to perform chmod functions via the web Can some one point me in the right direction with either some samples or URL describing this.

Access Database And Php :(
I have a problem. I've found a web hosting place, and in the site
have created a microsoft access database. But for the life of me I
can not find out how to connect and input data using php! There seems
to be not tutorials on the internet :(

Basically I have a response form, people fill it in and hit submit
then the data is stored in the database.

I'm thinking using php, would it be easier to use another language,
e.g. asp?

PHP - Data From Access Db
I'm using the code below as a base for a connect to an access
database.
This works well, but I have an issue...

<?php
$db = "./access.mdb" ;
$pass = "1234" ;

$conn = new COM("ADODB.Connection") ;
$sql = "DRIVER={Microsoft Access Driver (*.mdb)} ;
DBQ=". realpath($db) ." ;
uid=admin ;
pwd=$pass ;" ;
$conn->open($sql);
$rs = $conn->execute("SELECT * FROM TableName");
while (!$rs->EOF) {
echo $rs->Fields['FieldID']->Value ;
echo $rs->Fields['FieldName']->Value ;
$rs->MoveNext() ;
}
$rs->Close() ;
$conn->Close() ;
?>

using this:
while (!$rs->EOF) {
echo $rs->Fields['FieldID']->Value ;
echo $rs->Fields['FieldName']->Value ;
$rs->MoveNext() ;
}

Dsn Less Connection With Access Db
Can anyone give me an example how to make an dsn less connection with an Access database and Php.

POP3 Access
I have a script that will access a smtp server and send mail via it, but I'm looking for a code that will let me pop authenticate first so that it will let me send.

Access Array Key
[myarray] => Array
(
[10] => 1
[7] => 1
[6] => 1
)

How would I access the array and loop through the key, what I want to be able to do is, print to scrren the following The array keys are:

10
7
6

Shell Access Through PHP
I am in need of shell access like SecureSHell(ssh) or telnet via a PHP/PERL script to a remote server. Is there a way to do it without doing an exec("ssh hostname")?

Connecting To Access Db
i was working with asp but the site is launched in linux server.had to switch to php.
i had a access db admin.mdb i need to connect to admin.mdb and insert and retrieve data from it.

Restricted Access
I am really embarassed with the following. I would like to integrate access restriction in my pages, but it doesn't work with this script model. I adapted the $UserName but it doesn't work. Do I have to add something, but where?

<?php
$hostname_oui = "localhost";
$database_oui = "qsdfdsqfds";
$username_oui = "sdfdqs";
$password_oui = "sdfsdf";
$oui = mysql_pconnect($hostname_oui, $username_oui, $password_oui) or trigger_error(mysql_error(),E_USER_ERROR);?>

<?php
session_start();
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";

// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;

// When a visitor has logged into this site, the Session variable MM_Username set equal to their username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}

$MM_restrictGoTo = "http//www.dfdsqfdsqf";
if (!((isset($_SESSION['MM_UserName'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_UserName'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>

How To Access Mp3 Id3-tags
Have anyone seen/got functions that can read id3-tags from mp3-files...?

File Cannot Be Access
I am trying to access a series of files in one directory. Currently there is only one file located in it. But the coding that I am trying to use can not access it for some reason Here is the coding of which I am having problems with PHP Code:

Ask About Root Access
Can anyone tell me how to access root on localhost?

Restricted Access
1st time poster here and newbie all around.

I am in the midst of making a dynamic php site for World of Warcraft, i
have most of the forms to enter data into the database made and am
starting to think about the security for the members data.

I want to be able to let a member come back to the site to check more
checkboxes when they need to, but only let the member who submitted
that form be able to edit it later.

The site is up for testing at

If you go there to test, after registering, do not try submitting to
Leatherworking or Tailoring, those 2 are not uploaded yet.

To view the data after submitting, go to the home button (top left)
then select View database, then the profession you submitted to.

all that should be enought for you to get an idea of how I want and
need the secuirty features setup.

So if anyone could point me the right direction, i would be greatful,
as i don't "think" that the default restrictions in Dreamweaver MX 2004
is enough to do this...?

Allow Access From Just One IP

Do I need PHP in order to allow access to one certain file from just ONE IP? Or is it possible to solve this with a .htaccess file?