PHP - Mysql Database Read-only

This topic has been moved to Microsoft SQL - MSSQL.

http://www.phpfreaks.com/forums/index.php?topic=319147.0

MOD: Thanks for moving to the correct forum - much appreciated!

OK, I've taken a look around and cannot find a complete tutorial on how to do this.

I have created a database with a table and the following fields;

id, day, month, year, event, type

What I am trying to do is read the data held in the table by referencing the type field (unique data), have it populate data firleds which are user editable and then once all changes are made have it update into the table.

I can't imagine that this is that hard at all, but I cannot for the life of me figure it out!

Anybody got a tutorial or some code which will do this?

I am working on a simple web app in which I want to store about 20 variables in a MYSQL table so when I hand off the project the variables can be easily edited by the end user. Is it easy to store variables in a MYSQL table then query those and make them PHP variables? Really I just need to read a MYSQL table and pull two columns; AppOption and AppOptionValue then create PHP variables for each of the results making the AppOption the variable name and the AppOptionValue the value of said varible.

Any Ideas?

Thanks!

Sean

I am having trouble trying to save my image file names to mysql after reading a dir. I am trying to use the file below. Any help would be appreciated. I was originallly getting the files to list but they we not showing up in the database. Now the page shows up blank.

<?php
require("config_0.php");

// Connect to server and select database.
mysql_connect($dbhost, $dbuser, $dbpass)or die("cannot connect");
mysql_select_db("test")or die("cannot select DB");


$files = glob("images/*.jpg"); 
for ($i=1; $i<count($files); $i++) 
	{ 	
		$num = $files[$i];
		$sql="INSERT INTO images (url) VALUES ('$num')";

			if (!mysql_query($sql))
			  {
			  die('Error: ' . mysql_error());
			  }
		echo '<img src="'.$num.'" alt="random image">'."&nbsp;&nbsp;";
	}
?>

Once upon a time needed help on March 12, 2008 this community helped me, I am still a learner tried to help back but all the problems posted here beyond my skills to solve them so I kept quiet.  and Now I need help once again hope I will get it done.

Its PHPPOS developed in Codeigniter This code below is from application\controllers\inventory_summary.php file

Code: [Select]
<?php
require_once("report.php");
class Inventory_summary extends Report
{
function __construct()
{
parent::__construct();
}

public function getDataColumns()
{
return array($this->lang->line('reports_item_name'), $this->lang->line('reports_item_number'), $this->lang->line('reports_description'), $this->lang->line('reports_count'), $this->lang->line('reports_reorder_level'));
}

public function getData(array $inputs)
{
$this->db->select('name, item_number, quantity, reorder_level, description');
$this->db->from('items');
$this->db->where('deleted', 0);
$this->db->order_by('name');

return $this->db->get()->result_array();

}

public function getSummaryData(array $inputs)
{
return array();
}
}
?>

And this partial code below  is from application\controllers\report.php file


Code: [Select]
function inventory_summary($export_excel=0)
  {
    $this->load->model('reports/Inventory_summary');
    $model = $this->Inventory_summary;
    $tabular_data = array();
    $report_data = $model->getData(array());
    foreach($report_data as $row)
    {
      $tabular_data[] = array($row['name'], $row['item_number'], $row['description'], $row['quantity'], $row['reorder_level']);
    }

    $data = array(
      "title" => $this->lang->line('reports_inventory_summary_report'),
      "subtitle" => '',
      "headers" => $model->getDataColumns(),
      "data" => $tabular_data,
      "summary_data" => $model->getSummaryData(array()),
      "export_excel" => $export_excel
    );

    $this->load->view("reports/tabular",$data); 
  }
 
}
?>
Together they get the job done as follow:



Item Name   Item Number   Description   Count   Reorder Level   (Count is quantity in stock)
Item 1                   0002            xyz                    5                  3
Item 2                   0s00            xyz                    5                  3
Item 3                   0005            xyz                    5                  3
Item 4                   0006            xyz                    5                  3


The output I want need to be like this:

Item Name   Item Number   Description    cost price         Count        Reorder Level
Item 1                   0002            xyz                       250                5                  3
Item 2                   0s00            xyz                       120                5                  3
Item 3                   0005            xyz                       300                5                  3
Item 4                   0006            xyz                       500                5                  3
                                                                                   
                                                Total Stock Value  5850  Total Count 20  <-- this doesn't require any formation just needs to be at bottom of all the queries  like shown here.
           

This is what I want mainly >>>>>>>>>>  Total Stock Value (cost price * count foreach and then sum of all results ) and  sum of all count


cost price table and column is different than one used above in the code which is:

databse table is ' receivings_items '
Column is 'item_cost_price'

example php code to fetch is :


Code: [Select]
$sql = "SELECT `item_cost_price` FROM `receivings_items`";
config.php contains all the connection variables to MySQL



Please Help me   

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>

At the moment  I am creating a search function for my website.
The approach I have in mind is a pseudo-PHP database. To give an example:

A HTML form will submit the results to a PHP file.

HTML FORM - Colour: Black
PHP RESULT PAGE - if ($_POST['color'] == 'Black') {readfile("./products/black/*.html");}
HTML FORM - Price: <$50
PHP RESULT PAGE - if ($_POST['Price'] == '<$50') {readfile("./products/less50/*.html");}

The problem here is if there is an item that is black and costs less than $50, then its going to be listed twice. There is probably some code I can write to ommit the listing of duplicate entries, but it is probably going to be messy, so I am wondering if its better to use a centralized MySQL database, rather than a pseudo-PHP database? I've never used MySQL and don't know much about it and this is my first real attempt at using PHP.

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.

How would I go about doing the following:

I have a csv like this
Quote

"Division","Section","Group","Product Code","Description","Description + Secondary Description"
"Division 1","Section 1","Group 1","BMSLPL25","Test Name","Test Description"
"Division 1","Section 1","Group 2","BMSLPL26","Test Name 2","Test Description 2"
"Division 2","Section 2","Group 2","BMSLPL27","Test Name 3","Test Description 3"



I have a database structured like this
Quote

Divisions
---
id
name
parent_id

Groups
---
id
name
division_id

Products
---
id
code
description
secondary_description



Section is a sub division. What is the best way to get the information from CSV into this database? Should I have another table and store the CSV data as is and then query that to make the other tables.
Any help much appreciated.

For some reason Im not able to connect to mysql database, when i fill in the form and select search, it just basically refreshes the page but does not come up with no error messages or any results from my database. any help is appreciated.

HTML Code

Code: [Select]

<table id="tb1">
<tr>
<td><p class="LOC">Location:</p></td>
<td><div id="LC">
<form action="insert.php" method="post">
<select multiple="multiple" size="5" style="width: 150px;" >
<option>Armley</option>
<option>Chapel Allerton</option>
<option>Harehills</option>
<option>Headingley</option>
<option>Hyde Park</option>
<option>Moortown</option>
<option>Roundhay</option>
</select>
</form>
</div>
</td>

<td><p class="PT">Property type:</p></td>
<td><div id="PS">
<form action="insert.php" method="post">
<select name="property type" style="width: 170px;">
<option value="none" selected="selected">Any</option>
<option value="Houses">Houses</option>
<option value="Flats / Apartments">Flats / Apartments</option>
</select>
</form>
</div>
</td><td>
<div id="ptype">
<form action="insert.php" method="post">
<input type="radio" class="styled" name="ptype" value="forsale"/> For Sale

<p class="increase">
<input type="radio" class="styled" name="ptype" value="forrent"/> To Rent
</p>
<p class="increase">
<input type="radio" class="styled" name="ptype" value="any"/> Any
</p>
</form>
</div>
</td>
</tr>

</table>

<div id="table2">
<table id="NBtable">
<tr>
<td><p class="NBS">Number of bedrooms:</p></td>
<td><div id="NB">
<form action="insert.php" method="post">
<select name="number of bedrooms">
<option value="none" selected="selected">No Min</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select> to

<select name="number of bedrooms">
<option value="none" selected="selected">No Max</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select>
</form>
</div>
</td>

<td><p class="PR">Price range:</p></td>
<td><div id="PR">
<form action="insert.php" method="post">
<select name="price range">
<option value="none" selected="selected">No Min</option>
<option value="50,000">50,000</option>
<option value="60,000">60,000</option>
<option value="70,000">70,000</option>
<option value="80,000">80,000</option>
<option value="90,000">90,000</option>
<option value="100,000">100,000</option>
<option value="110,000">110,000</option>
<option value="120,000">120,000</option>
<option value="130,000">130,000</option>
<option value="140,000">140,000</option>
<option value="150,000">150,000</option>
<option value="160,000">160,000</option>
<option value="170,000">170,000</option>
<option value="180,000">180,000</option>
<option value="190,000">190,000</option>
<option value="200,000">200,000</option>
<option value="210,000">210,000</option>
<option value="220,000">220,000</option>
<option value="230,000">230,000</option>
<option value="240,000">240,000</option>
<option value="250,000">250,000</option>
<option value="260,000">260,000</option>
<option value="270,000">270,000</option>
<option value="280,000">280,000</option>
<option value="290,000">290,000</option>
<option value="300,000">300,000</option>
<option value="310,000">310,000</option>
<option value="320,000">320,000</option>
<option value="330,000">330,000</option>
<option value="340,000">340,000</option>
<option value="350,000">350,000</option>
</select> to

<select name="price range">
<option value="none" selected="selected">No Max</option>
<option value="50,000">50,000</option>
<option value="60,000">60,000</option>
<option value="70,000">70,000</option>
<option value="80,000">80,000</option>
<option value="90,000">90,000</option>
<option value="100,000">100,000</option>
<option value="110,000">110,000</option>
<option value="120,000">120,000</option>
<option value="130,000">130,000</option>
<option value="140,000">140,000</option>
<option value="150,000">150,000</option>
<option value="160,000">160,000</option>
<option value="170,000">170,000</option>
<option value="180,000">180,000</option>
<option value="190,000">190,000</option>
<option value="200,000">200,000</option>
<option value="210,000">210,000</option>
<option value="220,000">220,000</option>
<option value="230,000">230,000</option>
<option value="240,000">240,000</option>
<option value="250,000">250,000</option>
<option value="260,000">260,000</option>
<option value="270,000">270,000</option>
<option value="280,000">280,000</option>
<option value="290,000">290,000</option>
<option value="300,000">300,000</option>
<option value="310,000">310,000</option>
<option value="320,000">320,000</option>
<option value="330,000">330,000</option>
<option value="340,000">340,000</option>
<option value="350,000">350,000</option>

</select>
</form>
</div>
</td>


</tr>

</table>

PHP Code
Code: [Select]

<?php
$server = "";      // Enter your MYSQL server name/address between quotes
$username = "";    // Your MYSQL username between quotes
$password = "";    // Your MYSQL password between quotes
$database = "";    // Your MYSQL database between quotes

$con = mysql_connect($server, $username, $password);       // Connect to the database
if(!$con) { die('Could not connect: ' . mysql_error()); }  // If connection failed, stop and display error

mysql_select_db($database, $con);  // Select database to use

$result = mysql_query("SELECT * FROM tablename");  // Query database

while($row = mysql_fetch_array($result)) {     // Loop through results
  echo "<b>" . $row['id'] . "</b><br>\n";      // Where 'id' is the column/field title in the database
  echo $row['location'] . "<br>\n";            // Where 'location' is the column/field title in the database
  echo $row['property_type'] . "<br>\n";       // as above
  echo $row['number_of_bedrooms'] . "<br>\n";  // ..
  echo $row['purchase_type'] . "<br>\n";       // ..
  echo $row['price_range'] . "<br>\n";         // ..
}

mysql_close($con);  // Close the connection to the database after results, not before.
?>

To connect to my database I an entering mysql database details just at the first top lines server,username,password and database. is thats correct?

Thank You for your help in adavance.

Okay, I have been following this tutorial: http://www.freewebmasterhelp.com/tutorials/phpmysql/1 to achieve exactly what I wanted to get done. I also followed the way to have it formatted in tables and added extra columns that I needed, included an "Options" column which houses three links, including "edit" and "delete"

Now, I have everything working fine but I am stumped on how to get the "edit" and "delete" links to work for each individual entry that is listed. I have to have these features so the entries can be edited and deleted without having to physically go into the MySQL database to do it. The tutorial explains how to do it in Step 6, but I am confused. I'm not quite sure where to place the code for the links, which are generated automatically every time a new entry is inputted into the database.

Anybody available to help me out? Thanks!

Hey guys,

I'm working a project that requires sessions be stored within the database, as the project I'm working on is on a shared host. But I'm having a problem with getting the data of a session in the database, the other fields like session_id, session_updated, session_created are working fine. I think I've got a bug in my code, but I just can't detect it (frustrating).

Database connection

class db extends mysqli {
private $host;
private $user;
private $pass;
private $db;

function __construct( $host='localhost', $user='user', $pass='pass', $db='website' ) {
$this -> host = $host;
$this -> user = $user;
$this -> pass = $pass;
$this -> db = $db;

parent::connect( $host, $user, $pass, $db );

if( mysqli_connect_error( ) ) {
die( 'Connection error ('.mysqli_connect_errno(  ).'): '.mysqli_connect_error(  ) );
}

}

function __destruct(  ) {
$this -> close(  );
}
}


Session handler

class sessionHandler {
private $database;
private $dirName;
private $sessTable;
private $fieldArray;

    function sessionHandler() {
        // save directory name of current script
$this -> database = new db;
        $this -> dirName = dirname(__file__);
        $this -> sessTable = 'sessions';
    }

    function open( $save_path, $session_name ) {
return TRUE;
    }

    function close() {
//close the session.
        if ( !empty( $this -> fieldarray ) ) {
            // perform garbage collection
            $result = $this->gc( ini_get ( 'session.gc_maxlifetime' ) );
            return $result;
        }
        return TRUE;
    }

    function read( $session_id ) {
$sql = "
SELECT *
FROM sessions
WHERE session_id=( '$session_id' )
LIMIT 1
";
$result = $this -> database -> query( $sql );
if( $result -> num_rows > 0  ) {
$data = $result -> fetch_array( MYSQLI_ASSOC );
$this -> fieldArray = $data;
$result -> close();
return $data;
}
return "";
    }

    function write( $session_id, $session_data ) {
//write session data to the database.
        if ( !empty( $this -> fieldArray ) ) {
            if ( $this -> fieldArray['session_id'] != $session_id ) {
                // user is starting a new session with previous data
                $this -> fieldArray = array();
            }
        }

$this -> fieldArray['session_id'] = $session_id;
$this -> fieldArray['session_data'] = $session_data;
$this -> fieldArray['session_updated'] = time();
$this -> fieldArray['session_created'] = time();

$session_id = $this -> database -> escape_string( $session_id );
$session_data = $this -> database -> escape_string( $session_data );
$session_updated = time();
$session_created = time();

$sql = "
INSERT INTO sessions ( session_id, session_data, session_updated, session_created )
VALUES ( '$session_id', '$session_data', '$session_updated', '$session_created' )
";
if( $this -> database -> query( $sql ) !== TRUE ) {
return FALSE;
}
return TRUE;
    }

    function destroy( $session_id ) {
$sql = "
DELETE FROM sessions
WHERE session_id=('$session_id')
";
if( $this -> database -> query( $sql ) !== TRUE ) {
return FALSE;
}
return TRUE;
    }

    function gc( $max_lifetime ) {
return TRUE;
    }

    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();
    }
}


The call

$session_class = new sessionHandler;
session_set_save_handler(
array( &$session_class, 'open' ),
array( &$session_class, 'close' ),
array( &$session_class, 'read' ),
array( &$session_class, 'write' ),
array( &$session_class, 'destroy' ),
array( &$session_class, 'gc' )
);
if( !session_start() ) {
exit();
}


Any help at all would be appreciated.

Kind Regards
Mike