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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
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 Replies !
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() ; }
View Replies !
Using PHP To Access WinAmp Data
Does anyone know of a way to use PHP to display on a web page the playlist (m3u) information for a file currently being played by winamp? Note this is not about *controlling* winamp, but accessing data in real time to display current file / playlist name being played.
View Replies !
Access Data In Webpage
I have a data base in access having 6 columns and around 120 entries. I want some script or some coding through which I can extract the data into a webpage. for example say if I create a link with TTT and on clicking this TTT the next page should display the results from database in a webpage in table format ..
View Replies !
Data Access Class
I'm working on a class to access a MySQL database. One function I'd like to have is one that lists the records in a table. But, I'd like to be able to read from a loop. Ex: while ($x = $class->function()) { echo $x['fieldname']; }
View Replies !
Enter Data To Ms-access
i have a problem to enter information(record) to ms-access in php i have a error: "Warning: odbc_do() [function.odbc-do]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in C:Documents and SettingsAdministratorMy Documentsdb7.php on line.
View Replies !
How Can I Restrict Access To Data File?
I have a php script that processes a form and then posts the user input to a data file on the server in a comma delimited format. For simplicity call the file "data.csv." The script is working well and the data is posted correctly to the data file. The big problem is that anyone can point their web browser to...
View Replies !
Access Those Session Data Through Cookie
Now I just want to know if this is correct, if i store information in my session and i have a javascript cookie class, i can access those session data through cookie, correct because all a session really ism is a cookie, right?
View Replies !
Access Anonymous Ftp And Parse Data
Hello everyone. I'm definately a newbie at this so go easy. I am trying to get together a script to access some aviation weather from noaa. They have an anonymous ftp server that you can access txt files with weather data in them. I'd like to make a script to access the airports from a specific state (which are defined in the script which airports for which state) and echo that to an html file. The script would have to 'find' the airports in the txt file then parse out the info. Here is an example of what's in the data files. Code: 2006/01/18 17:00 GCFV 181700Z 190024 35006KT 9999 SCT030 BECMG 0911 10007KT TEMPO 0818 VRB03KT 2006/01/18 17:00 GCLP 181700Z 190024 01010KT 9999 FEW030 BECMG 0911 06008KT TEMPO 0818 VRB03KT 2006/01/18 17:00 GCRR 181700Z 190024 35006KT 9999 FEW030 BECMG 0911 09007KT TEMPO 0818 VRB03KT 2006/01/18 17:00 GCTS 181700Z 190024 05008KT 9999 SCT030 BECMG 0911 15008KT TEMPO 0024 VRB03KT Can someone kind of point me in the right direction on how to do this?
View Replies !
Access A Website, Fetch The Data, And Then Logout
I need to access a website, Fetch the data, and then logout. Please tell me where I am wrong. I dont think its logging out properly. <? include "Snoopy.class.php"; $snoopy = new Snoopy; //Logging in $submit_url = 'http://www.sortingcodes.co.uk/FormsLogin.asp?action=login&URL=Default%2Easp' $submit_vars["Username"] = "Username"; //my username $submit_vars["Password"] = "Password"; //my password $submit_vars["Submit"] = "Go"; $snoopy->submit($submit_url,$submit_vars); //Requesting for info $snoopy->setcookies(); $submit_url = 'http://www.sortingcodes.co.uk/Results.asp?type=Sortcode&Page=1&Sortcode=402343' $snoopy->fetch($submit_url); echo $snoopy->results; //loggin out $snoopy->setcookies(); $snoopy->fetch("http://www.sortingcodes.co.uk/logout.asp"); ?>
View Replies !
Multi-dimensional Arrays - Use Foreach() To Access The Data?
If I have a 2-dimensional array where the top key is year numbers (e.g. "2003"), the second key is month numbers (e.g. "8" to represent August), and the data stored is some cardinal number, how can I use foreach() (or anything else) to access the data? I want to write one line of HTML for each year, along the lines of: 2003 [ 8(23) ] assuming that 23 would be the cardinal number stored at $array[2003][8]. I s'pose what I'm trying to do is use the key, which is an array, as a string to print out. Or maybe I'm just confused? PHP Code:
View Replies !
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.
View Replies !
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.
View Replies !
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
View Replies !
Mysql Db To Access Db
im working with access databases... so i tried converting the code but im have a little problem... im probably making a mistake in the functions... does an1 one know where i screwed up? Code:
View Replies !
Access MySQL
I have phpdev working fine for php, but I am trying to set up a database now, and it seems like I remember setting up a password back when I installed it, but I have no idea what that was now. How do I find out what it was, and what the other information is?
View Replies !
Access DB To MYSQL
i need to convert an access db to mysql, how do i tell mysql to read an access file? Also the date table in the access is in a different format then in the mysql? Acess format: Month/day/year mysql: year:month:day so i tried changing the date column through phpmyadmin by typing in "'%c/%e/%Y'"in the values field. However the default still shows as 000-00-00.
View Replies !
Access To Mysql
I have an access database and some of the columns are Yes/No checkboxes (that is, in Access they appear in the "Datasheet View" as checkboxes). When I exported the database to a .csv file, I get 0's for unchecked and 1's for checked boxes. In my Mysql table, I'm using the enumerated data type for the corresponding fields ('y','n'). It appears that what's happening is that when I upload the .csv file to Mysql, I get the first enumerated selection on all fields imported.
View Replies !
PHP + MySQL Access Denied
I keep getting an access denied error when trying to connect to mysql using user@localhost. I can connect just fine if I use the IP address instead (ie user@192.168.1.5). I granted "user" privileges for everything so I don't see why that's the problem. Is this an issue where "localhost" is not getting resolved correctly? I'm on Linux, BTW.
View Replies !
PHP, MySQL & Limiting Access
I have a project for work, and I'm not sure how to efficiently do what I need to do. I'm hoping someone out there can help. Project is this: I'm creating a web-based interface where people at my company (operators) can enter data for service calls. All data entered is run thru one or more PHP scripts for error checking and then stored in a MySQL database on a server here in the office. What I'm looking to do is to limit access to certain operators so they can only do certain functions (ex: add a service call, but not delete one), whereas admins such as myself would have full access to everything. Ideally, at some point in the future, we plan to roll this interface out to our clients so they may do the same features within their company. Obviously, they would only gain access to data related to their company, as to protect the privacy of others. Hierarchy would be something like this: 1. UberAdmins (such as myself) -Have access to everything and to all commands. 2. Operators -Have access to everything, but not all commands. 3. Our clients -Have access to their data only, and to all commands. 4. Our clients' operators -Have access to their data only, but not all commands. The difficult thing is that our clients may run several businesses, so they would have to have access to several groups. In essence, they'd have multiple groups (their businesses) within a group (their group) within a group (everything). What is the easiest and most secure way to do something like this? I'm not looking for actual code but merely suggestions. Please reply if there is something I wasn't clear on.
View Replies !
Access Pictures From MySQL.
I'm planning on letting my users add pictures to their pages using the browser upload method. My question is, which is better? adding the picture to the database? or storing them on a separte directory and add a link to the page? I also will be letting each user have quota on the disk space.
View Replies !
Remote MySQL Access
Some partners of mine and I are writing a host-based application, which would greatly benefit if we could take advantage of a web services-like function we are formulating. Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers. In my experience, typically web hosting providers only allow localhost access to MySQL databases. Are there any providers who either allow remote access or does anyone know of providers specifically designed for this function? I did find one, but it is a "giveaway" when their product is purchased: http://www.navicat.com So far, I'm on page 8 of my 110,000-item result from a Google search.
View Replies !
Export Access To Mysql
I have the code to display the tables in Access now I need to take the data from access and replace the data in mysql The Access DB is the master and controled via are Doc Mang software blah blah The day-to-day users and testing Equi.... us the mysql DB. I have all the code to trigger the script for update once the DB is changed now just working on the mysql update side. I was thinking of placing the data from Access (at the same time it is being displayed) into an array then take that array and dump it into mysql Code:
View Replies !
MS Access To MySQL Conversion
I have a new host, and thus I now have the ability to use MySQL instead of Access. I have a simple script, which I need to convert the code to utilize the new database. I will worry about migrating the content aft er I get teh script working. Code:
View Replies !
MS Access Database To MySQL
I have a database fully populated in MsAccess and need to transfer to MySQL. I have tried to save the databse as .tab .csv .txt but nothing seems to work. Everytime I upload the file with PHPMyAdmin i get a bunch of garbley gook!! Any ideas?
View Replies !
Linking MySQL To Access
I installed mysql-connector-odbc-3.51.14-win32 and then I connected to my database. The problem occured because I have Cyrillic letters in MySQL database and the data I see in Access is illegible, and those signs can't be read or understood. How can I solve this situation.
View Replies !
Mysql Access Denied
Whilst trying to log into a new script I get the following error. (The mysql setup is OK and working) Warning: mysql_connect(): Access denied for user: 'testuser@localhost' (Using password: YES) in /home/eitpqnet/public_html/pqinvoice/login.php on line 3 Unable to connect Can anyone help?
View Replies !
Access Denied With MySql
I work with RH7, Mysql 3.23.58 and PHP 4.3.4. Some of my mysql users are configured with any host. Since this afternoon, I can't connect to Mysql with an user configured with any host (%) and a password. When I change password to "no password", I can connect to the server. All users configured with localhost have a password and work fine, only users with "any host (%)" don't work. I work with PhpMyadmin to modify and create users/databases. I tried to connect via phpmyadmin and via a simple PHP-script. Dos anyone have an idea ?
View Replies !
Transfer My MS Access DB To MySQL?
How do I transfer my MS Access DB to MySQL? One issue though, in Access I have some special character such fraction, backquote, etc. how do I replace those characters to ASCI equivalent when transfering to MySQL, or do I have to do it outside MySQL?
View Replies !
Import CSV, Access To MySQL
Anybody knows how to convert ASCII CSV files (comma separated values) to mysql or Access to MySQL? I want to import a big database to mysql. I have this database in CSV and access.
View Replies !
Storing Mysql Access
what is best practice method of storing mysql access credentials. my current method is through including them as environmental variables through apache config although cannot be the most secure method im sure you are aware.
View Replies !
Protect Local Mysql DB Access
I just password-protected an intranet site by including a password authentication script in each page of a private section. The script checks the login against the mySQL database. Appropriate file permissions have been set up on the private directory. My concern is now about protecting the Mysql password. Let's assume I use Apache to protect the access to this password (<files></files> or SetEnv in httpd.conf). In my intranet directory, I have a public folder where I let users put their html/php files to build their own pages. How can I prevent a user from creating a php file like this : $conn = mysql_connect($_SERVER['SQL_DB'],$_SERVER['SQL_USER'],$_SERVER['SQL_PASS']) or die(mysql_error()); $sql = 'update user set private_access= Ƈ' where username = 'myself'' $result = mysql_query($sql) or die(mysql_error()); In that way, without knowing the Mysql pwd, any user can finally have access to the private section.
View Replies !
Possible Migration From MySQl To Access Or MSSQL
I have a site that is running PHP off a mySQL database. However my company is going to be switching to a new web host and one of the candidates is using a Win2000 server. They do have PHP byt the two database options are Access or SQL Server 2000. I have not used PHP with either of these two databases and was wondering if it is possible to do so, and if so are there any difficulties in changing over to them. Any information is appreciated. I really do not want to switch to ASP, and would like to give my company a good argument for not switching to Access or SQL Server.
View Replies !
|
TRACKER
