DaniWeb Forum Index > Web Development > PHP

Basic PHP - MySQL Value into Variable

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2009

Posts: 3

Reputation: revata is an unknown quantity at this point

Solved Threads: 0

revata

Offline

Newbie Poster

Basic PHP - MySQL Value into Variable

Oct 18th, 2009

I'm building a few simple CMS variables into an Dynamic site that I half-built with Dreamweaver. The following code is the initiation of a paginated recordset display generated by Dreamweaver:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$currentPage = $_SERVER["PHP_SELF"];
 
$maxRows_creditsList = 6;
$pageNum_creditsList = 0;
if (isset($_GET['pageNum_creditsList'])) {
  $pageNum_creditsList = $_GET['pageNum_creditsList'];
}
$startRow_creditsList = $pageNum_creditsList * $maxRows_creditsList;
 
mysql_select_db($database_conSkye, $conSkye);
$query_creditsList = "SELECT title, `year`, `role`, flv, link FROM media ORDER BY `orda` DESC";
$query_limit_creditsList = sprintf("%s LIMIT %d, %d", $query_creditsList, $startRow_creditsList, $maxRows_creditsList);
$creditsList = mysql_query($query_limit_creditsList, $conSkye) or die(mysql_error());
$row_creditsList = mysql_fetch_assoc($creditsList);
 
if (isset($_GET['totalRows_creditsList'])) {
  $totalRows_creditsList = $_GET['totalRows_creditsList'];
} else {
  $all_creditsList = mysql_query($query_creditsList);
  $totalRows_creditsList = mysql_num_rows($all_creditsList);
}
$totalPages_creditsList = ceil($totalRows_creditsList/$maxRows_creditsList)-1;
$currentPage = $_SERVER["PHP_SELF"];

$maxRows_creditsList = 6;
$pageNum_creditsList = 0;
if (isset($_GET['pageNum_creditsList'])) {
  $pageNum_creditsList = $_GET['pageNum_creditsList'];
}
$startRow_creditsList = $pageNum_creditsList * $maxRows_creditsList;

mysql_select_db($database_conSkye, $conSkye);
$query_creditsList = "SELECT title, `year`, `role`, flv, link FROM media ORDER BY `orda` DESC";
$query_limit_creditsList = sprintf("%s LIMIT %d, %d", $query_creditsList, $startRow_creditsList, $maxRows_creditsList);
$creditsList = mysql_query($query_limit_creditsList, $conSkye) or die(mysql_error());
$row_creditsList = mysql_fetch_assoc($creditsList);

if (isset($_GET['totalRows_creditsList'])) {
  $totalRows_creditsList = $_GET['totalRows_creditsList'];
} else {
  $all_creditsList = mysql_query($query_creditsList);
  $totalRows_creditsList = mysql_num_rows($all_creditsList);
}
$totalPages_creditsList = ceil($totalRows_creditsList/$maxRows_creditsList)-1;

What I want to do is swap the value here:

Help with Code Tags

PHP Syntax (Toggle Plain Text)

$maxRows_creditsList = 6;

...for something like this:

Help with Code Tags

PHP Syntax (Toggle Plain Text)

$maxRows_creditsList = $valueFromDb;

This is just one variable in a table (cms_vars) that contains 2 columns; (variable_name), and (variable_value). I tried this but it didn't seem to work:

Help with Code Tags

(Toggle Plain Text)

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_creditsList = $mediarows;
$pageNum_creditsList = 0;
if (isset($_GET['pageNum_creditsList'])) {
  $pageNum_creditsList = $_GET['pageNum_creditsList'];
}
$startRow_creditsList = $pageNum_creditsList * $maxRows_creditsList;

mysql_select_db($database_conSkye, $conSkye);
$mediarows = "SELECT variable_value FROM cms_vars WHERE variable_name='medialist_rows'";
if (!mysql_query($mediarows,$conSkye))
  {
  die('Errorrr: ' . mysql_error());
  } 
$query_creditsList = "SELECT title, `year`, `role`, flv, link FROM media ORDER BY `orda` DESC";
$query_limit_creditsList = sprintf("%s LIMIT %d, %d", $query_creditsList, $startRow_creditsList, $maxRows_creditsList);
$creditsList = mysql_query($query_limit_creditsList, $conSkye) or die(mysql_error());
$row_creditsList = mysql_fetch_assoc($creditsList);

if (isset($_GET['totalRows_creditsList'])) {
  $totalRows_creditsList = $_GET['totalRows_creditsList'];
} else {
  $all_creditsList = mysql_query($query_creditsList);
  $totalRows_creditsList = mysql_num_rows($all_creditsList);
}
$totalPages_creditsList = ceil($totalRows_creditsList/$maxRows_creditsList)-1;

•

Join Date: Jul 2009

Posts: 226

Reputation: CFROG is an unknown quantity at this point

Solved Threads: 14

CFROG

Offline

Posting Whiz in Training

Oct 18th, 2009

Query the database for the value you want to substitute.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$new_value=mysql_query("SELECT something FROM cms_vars WHERE something='$something_else' ");
while($nv=mysql_fetch_array($new_value)) {
$valueFromDb = $nv['variable_value']; }
 
$maxRows_creditsList = $valueFromDb;
$new_value=mysql_query("SELECT something FROM cms_vars WHERE something='$something_else' ");
while($nv=mysql_fetch_array($new_value)) {
$valueFromDb = $nv['variable_value']; }

$maxRows_creditsList = $valueFromDb;

Unless I'm missing something here this would work just fine.

Thread Tools	Search this Thread
Show Printable Version Email this Page

DaniWeb Message

Cancel Changes