PHP - Does Php Supports Read/write From Linked Tables In Ms-access

I very new to php and all I am simply trying to do is read the contents of a text file and echo it out on the screen.
I have tried many things to see what I am doing wrong but it just simply isnt working for me. I know the server I am using has php enabled as well because I have tried a simple echo and it works fine.

This is the code I am currently using.

<?php
   $file = fopen(file.txt", 'r');
   $read = fread($file, '6')
   echo $read;
?>

also, I have tried this.

<?php
   $file = file_get_contents('file.txt');
   echo $file;
?>

I have a file.txt on the server I am using in the same directory as index.php, I feel like this should be working but I get no result!
Alls I have in the text file is a statement that says "hello world".

Hi,

I want to read image file and write in to word document file using php. Actually i am developing shopping cart site. for that i have created barcode image. i need to take print outs. for example if i click print means same barcode should be generate 64 times in word document. how i do it?

i have tried with COM. please check the following code


<?php
// starting word

$word = new COM("word.application") or die("Unable to instantiate Word");
echo "Loaded Word, version {$word->Version}\n";

//bring it to front
$word->Visible = 1;

//open an empty document
$word->Documents->Add();

//do some weird stuff


for($i=1;$i<=64;$i++)
{
   
$word->Selection->InlineShapes->AddPicture("D:\Program Files\wamp\www\b.jpg ",false, True);

}


$word->Documents[1]->SaveAs("D:\Program Files\wamp\www\Uselesstest.doc");

//closing word
$word->Quit();

//free the object
$word = null;
?>


It works fine in local. but it is not working in server  (it says COM.class is missing). i have checked some forums they said it works with MS based operation system.  i have checked with windows only.


Please kindly any one help me asap the way for read and write image file in word document.

can we do this any other way?

we are reading and writing txt files using php
the same can we do with image file (read and write in word document) ??

Thanks
Prema

Hi, I've been googling for a while now for an example of how to read, edit and write a configuration file.

This part was easy to find...
<?php
$icon_settings = parse_ini_file("test.desktop");
print_r($icon_settings);
?>

...the above code works great, but how do I edit and write back a configuration file like this...
Code: [Select]
#!/usr/bin/env xdg-open

[Desktop Entry]
Version=1.0
Name=Firefox Web Browser
Comment=Browse the World Wide Web
GenericName=Web Browser
Exec=firefox %u
Terminal=false
X-MultipleArgs=false
Type=Application
Icon=firefox
# ... and so on
back to the drive?

Thanks.

I have a MySQL database with each record of a person who has registered for an event, I am displaying the information on a web page for a user, but he wants to be able to print out all the records in alphabetical order by last name, first name later on so he will have a hard copy of each person who has registered at the table when they arrive.  How can I write each record to a Txt file that he can print out later that will be formated with the record contents along with each fields definition (Ex. Last Name - Smith, First Name - John, etc)?

Hey all,

I am in a situation where database management system needs to be up and running very quickly, which would store records of addresses possibly from all the properties in a particular US state. But it would only be 1 US state, not all. These records need to be updated and retrieved for particular campaigns. The programming solution (e.g. PHP) would need to be able to import csv files generated from excel and match the records in the database in order to know which fields to update. It seems like a lot of work to do this from scratch using PHP in the short-term, given time limitations. Hence, I was considering using Microsoft Access as a front end in the interim and then when time is available writing a web-based PHP/MySql application using HTML, CSS, and JavaScript front end to allow users to easily perform data entry. Does anyone think this is a smart course of action? Ideally a web PHP app would be more robust, but considering it needs to be done from scratch, it would be time consuming.

There's no right or wrong answer for this. I'm just looking for opinions. Thanks for any response.

Hi All,

I am using PHP 5.3 and storing php session data to the database using session.set_save_handler callbacks. I see that the write method, strangely treats the Class constant as undefined. All the other methods seem to work fine with the class constant. Any reason why this would happen? Please see code below. I get an error "Use of undefined constant db_table in Sessions.php in line". This seems to be happening only with the write api. Can someone please help?

Thanks


class Sessions {
 //var $life_time;
 var $id;
 var $data;
 const db_table = 'php_mysql_session';
   function PHPSessions() {
      // Read the maxlifetime setting from PHP
      //$this->life_time = get_cfg_var("session.gc_maxlifetime");

      $this->id = session_id();
      $this->data = '';

      // Register this object as the session handler
      session_set_save_handler(
      array( &$this, "_open" ),
      array( &$this, "_close" ),
      array( &$this, "_read" ),
      array( &$this, "_write" ),
      array( &$this, "_destroy") ,
      array( &$this, "_gc" )
      );

   }
function _open ()
// open the session.
{
   Zend_Log::log("opening connection");
   global $_sess_db;
   Zend_Log::log("session db ".$_sess_db);
   if ($_sess_db = mysql_connect(DB_HOST_READ, DB_USER, DB_PASS)) {
      return mysql_select_db('TEST_SESSION', $_sess_db);
   }
   // If there is a failure return false
   return FALSE;

} // open


function _close ()
// close the db connection here
{
   global $_sess_db;
   return mysql_close($_sess_db);

} // close

function _read ($id)
// read any data for this session.
{

   
    global $_sess_db;
    Zend_Log::log("Session db ".$_sess_db);
   //$id = mysql_real_escape_string(session_id());
    Zend_Log::log("Session Id :" .$id);

   $sql = "SELECT * FROM ". self::db_table ."
   WHERE session_id = '$id'";
   Zend_Log::log("SQL IS : ".$sql);
 
     $data = '';
   $result = mysql_query($sql);
   $a = mysql_num_rows($result);
   Zend_Log::log("Record count ".$a);

   if($a > 0) {
      Zend_Log::log("Record Exists!");
      $row = mysql_fetch_assoc($result);
      $data = $row['session_data'];
      Zend_Log::log("Fetching session Data ".$data);
      return $data;
   }
   else
   {
      Zend_Log::log("No Data ".$data);
      return '';
   }


 
}

function _write ($id, $data)
// write session data to the database.
{
   global $_sess_db;
   
 
   $newid = mysql_real_escape_string($id);

   $newdata = mysql_real_escape_string($data);

   $sql = "REPLACE ". self::db_table ." (session_id,user_id,session_data,date_created) VALUES('$newid', '$userid', '$newdata', 'NOW()')";

   $rs = mysql_query($sql);

   return TRUE;
 

} // write

 
function _destroy ($id)
// destroy the specified session.
{
     Zend_Log::log("Destroy method ");
   return TRUE;

} // destroy

function _gc ($max_lifetime)
// perform garbage collection.
{
     Zend_Log::log("GC Method");
   return TRUE;

} // gc

function _destruct ()
// ensure session data is written out before classes are destroyed
// (see http://bugs.php.net/bug.php?id=33772 for details)
{
   @session_write_close();

} // __destruct

// ****************************************************************************
} // end class

I need help connecting to a Visual FoxPro 9 Database and Table via php.

I know this is possible because I've read of people doing this but I still have no resolve on this issue.

Does anyone know of anyway to connect to a VFP9 table via php? I would like step by step instructions on how to handle this including any server dependencies or installations needed to make this work. (Server: Linux,  webserver, Apache, PHP) (Visual Foxpro Database is in another location in a windows machine.)

To access MySql tables from PHP, I use the PHP code and the function below.

If I make these changes, would this code work for SQL Server 2008?

   mysql_fetch_array to mssql_fetch_array
   mysql_connect     to mssql_connect
   mysql_select_db   to mssql_select_db
   mysql_query       to mssql_query



PHP code
--------------------------------------------------------------------------------
$sql = "SELECT mast_id FROM district_mast WHERE mast_district = '".$dist_num."'";
$result = func_table_access($sql);
$rows = mysql_fetch_array($result);



Function
--------------------------------------------------------------------------------
FUNCTION func_table_access($sql)  {
  $db   = "aplustutoru";
  $host = "localhost";
  $user = "root";
  $pass = "";

  IF (!($conn=mysql_connect($host, $user, $pass))) {
    PRINTF("error connecting to DB by user = $user and pwd=$pass");
    EXIT;
    }

  $db3 = MYSQL_SELECT_DB($db,$conn) or die("Unable to connect to local database");
  IF ($sql <> "justopendb") {
    $result = MYSQL_QUERY($sql) OR DIE ("Can not run query because ". MYSQL_ERROR());
    RETURN $result;
    }
  }
                         

Hi again, i'm wondering how can i make Sort (for example a-z) an column in php reading mysql informations.

Here's the script:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="table.css" type="text/css">
</head>
<body style="margin: 0 0 0 0;">
<?
include("passwd.php");
@$start = $_GET["start"];
if($start =='')
    $start =0;
include("lib.php");
$link = mysql_connect($host,$username,$password);
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db($db, $link);
if (!$db_selected) {
    die ("Can't use $db : " . mysql_error());
}
//total number of records in the table
$res = mysql_query("SELECT * from `$table`");
@$rows = mysql_num_rows ($res);

$result = mysql_query("SELECT * from `$table` limit $start,10");
if (!$result) {
    die('Invalid query: ' . mysql_error());
}
 echo "<p align=center class = 'menu'> Ocitana tabela: $table </p>";
$cols = mysql_num_fields($result);
$records = mysql_num_rows ($result);
 echo "<table align='center' width='1200' >";
 echo "<tr bgcolor='BBCCDD' class='menu'>";
 for ($i = 0; $i < $cols;$i++)
 {
    echo "<td align='center'>".mysql_field_name($result,$i)."</td>";
 }
 echo "</tr>";
 while ($row = mysql_fetch_array($result, MYSQL_NUM))
 {
    echo "<tr bgcolor='F6F6F6' class='normal'>";

   foreach ($row as $value)
   { echo "<td align='center'>".$value ."</td>";
   } 


   echo "</tr>";
 }
 $end = $start + $records;
 echo "<tr  align = 'center' bgcolor = 'BBCCDD' class='menu'><td colspan=$cols> Prijema $start  do  $end  od $rows </td></tr>";
 echo "<tr  align = 'center' class='mylink'><td colspan=$cols> ";



    if($start != 0)
    {
    $prev = $start - 10;
    echo "<a  href='tabela.php?start=$prev'> Prethodna </a> ";
    }
    if($start<$rows-10)
    {
    $next = $start + 10;
    echo "<a href = 'tabela.php?start=$next'>Sledeca</a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
    }
     echo "</td></tr>";
     echo "</table>";
 ?>
</body>

</html>

First, I read PHP does not support function overloading. Then later in the book in chapter of OOP, it states:
    PHP supports function overloading, which means that you can provide more than one
function with the same name and different numbers or types of parameters.     So does it support function overloading or not? And of course my definition of function overloading is what you get in the Java programming language.

Hello, I try to get website speed of some website, but i can read only ''domain.com'' i can't read website files like css , js ... why ? i use proxies for this job. here is the php code:

$options = array(
'useragent' => "Firefox (+http://www.firefox.org)", // who am i
'connecttimeout' => 120, // timeout on connect
'timeout' => 120, // timeout on response
'redirect' => 10, // stop after 10 redirects
'referer' => "http://www.google.com",
'proxyhost' =>'85.25.8.14:80'
);
$response = http_get("http://solve-ict.com/wp-content/themes/ict%20theme/js/jquery-1.7.1.min.js", $options , $info);

but it works fine with http://domain.com/ , but with files css or js it gives 404, using some free proxy servers available ? Thanks.

Trying to get this done:

Page_1 has many external links, when certain links are clicked i do not want user to go directly to page, but rather go to a special add page_2 where user must click a second time on the link to finally get there.

The add page_2 must show on screen the name of the initial link from page_1, it must change accordingly with the link it came from page_1,once on page_2 the hyperlink redirects outside the site.

So far i am thinking give an id to the div or "<a href..." on page_1 then somehow have page_2 detect that id and fill in the variable for the final external link. Other wise is there a way to detect a url from incoming?

I guess a similar example is how some domain name sellers landing page will indicate the name of the site. Such as "Thisdomain.com" is for sale. same landing page but the name changes according to the domain that was typed.

I got a question im using izabi for me im one who loves the software. But there some quirks that they forgot to add when making the mail system. I was wondering how it would be possible to code in a peice of php where it says read after someone read the email. If you need a copy of the mail mail script let me know.

Hi all, first time posting here and wondering if anyone can help me.

Ive linked a button in a HTML so that it sends an email to me. But the thing thats really bugging me is that sometimes it sends the persons email address and sometimes it doesnt AND ALSO ive got multiple boxes in my HTML that I want it to send but it will only send 1 and not all 5. This is what my PHP looks like at the moment:

<?php
  $email = $_REQUEST[ 'email_box' ] ;
  $message = $_REQUEST[ 'test1_box' ] ;
  $message = $_REQUEST[ 'test2_box' ] ;
  $message = $_REQUEST[ 'test3_box' ] ;
  $message = $_REQUEST[ 'test4_box' ] ;
  $message = $_REQUEST[ 'test5_box' ] ;

  mail( "test1049@live.com", "Test Feedback sheet",
    $message, "From: $email" );
?>

Can you please tell me where I have gone wrong? I really need this to be sorted out and im completely new to PHP, ive only just gotten past basic knowledge of html