I've been working on calling a specific user's photos and placing them in their profile. I'm getting close but it's not working yet. This is my first attempt at such a large modification. Here's what I'm doing so far.
Here's my php page code to get the user's photopost image, which when I load it in a browser window works:
<?php
//Connection statement
require_once('Connections/picConn.php');
// begin Recordset
$query_Recordset1 = "SELECT * FROM photos WHERE photos.userid = ('$userid')";
$Recordset1 = $picConn->SelectLimit($query_Recordset1) or die($picConn->ErrorMsg());
$totalRows_Recordset1 = $Recordset1->RecordCount();
// end Recordset
?>
<img src="mediapost/data/500/<?php echo $Recordset1->Fields('bigimage'); ?>" width="120" height="120">
<?php
$Recordset1->Close();
?>
Here's my connection script:
<?php
# Type="ADODB"
# HTTP="true"
# DBTYPE="mysql"
$MM_picConn_HOSTNAME = "localhost";
$MM_picConn_DATABASE = "mysql:photopost";
$MM_picConn_DBTYPE = preg_replace("/:.*$/", "", $MM_picConn_DATABASE);
$MM_picConn_DATABASE = preg_replace("/^.*?:/", "", $MM_picConn_DATABASE);
$MM_picConn_USERNAME = "username";
$MM_picConn_PASSWORD = "password";
$MM_picConn_LOCALE = "Us";
$MM_picConn_MSGLOCALE = "En";
$MM_picConn_CTYPE = "P";
$KT_locale = $MM_picConn_MSGLOCALE;
$KT_dlocale = $MM_picConn_LOCALE;
$KT_serverFormat = "%Y-%m-%d %H:%M:%S";
$QUB_Caching = "false";
switch (strtoupper ($MM_picConn_LOCALE)) {
case 'EN':
$KT_localFormat = "%d-%m-%Y %H:%M:%S";
break;
case 'EUS':
$KT_localFormat = "%m-%d-%Y %H:%M:%S";
break;
case 'FR':
$KT_localFormat = "%d-%m-%Y %H:%M:%S";
break;
case 'RO':
$KT_localFormat = "%d-%m-%Y %H:%M:%S";
break;
case 'IT':
$KT_localFormat = "%d-%m-%Y %H:%M:%S";
break;
case 'GE':
$KT_localFormat = "%d-%m-%Y %H:%M:%S";
break;
case 'US':
$KT_localFormat = "%Y-%m-%d %H:%M:%S";
break;
default :
$KT_localFormat = "none";
}
if (!defined('CONN_DIR')) define('CONN_DIR',dirname(__FILE__));
require_once(CONN_DIR."/../adodb/adodb.inc.php");
ADOLoadCode($MM_picConn_DBTYPE);
$picConn=&ADONewConnection($MM_picConn_DBTYPE);
if($MM_picConn_DBTYPE == "access" || $MM_picConn_DBTYPE == "odbc"){
if($MM_picConn_CTYPE == "P"){
$picConn->PConnect($MM_picConn_DATABASE, $MM_picConn_USERNAME,$MM_picConn_PASSWORD,
$MM_picConn_LOCALE);
} else $picConn->Connect($MM_picConn_DATABASE, $MM_picConn_USERNAME,$MM_picConn_PASSWORD,
$MM_picConn_LOCALE);
} else if (($MM_picConn_DBTYPE == "ibase") or ($MM_picConn_DBTYPE == "firebird")) {
if($MM_picConn_CTYPE == "P"){
$picConn->PConnect($MM_picConn_HOSTNAME.":".$MM_picConn_DATABASE,$MM_picConn_USERNAME,$MM_pic Conn_PASSWORD);
} else $picConn->Connect($MM_picConn_HOSTNAME.":".$MM_picConn_DATABASE,$MM_picConn_USERNAME,$MM_pic Conn_PASSWORD);
}else {
if($MM_picConn_CTYPE == "P"){
$picConn->PConnect($MM_picConn_HOSTNAME,$MM_picConn_USERNAME ,$MM_picConn_PASSWORD,
$MM_picConn_DATABASE,$MM_picConn_LOCALE);
} else $picConn->Connect($MM_picConn_HOSTNAME,$MM_picConn_USERNAME, $MM_picConn_PASSWORD,
$MM_picConn_DATABASE,$MM_picConn_LOCALE);
}
if (!function_exists("updateMagicQuotes")) {
function updateMagicQuotes($HTTP_VARS){
if (is_array($HTTP_VARS)) {
foreach ($HTTP_VARS as $name=>$value) {
if (!is_array($value)) {
$HTTP_VARS[$name] = addslashes($value);
} else {
foreach ($value as $name1=>$value1) {
if (!is_array($value1)) {
$HTTP_VARS[$name1][$value1] = addslashes($value1);
}
}
}
global $$name;
$$name = &$HTTP_VARS[$name];
}
}
return $HTTP_VARS;
}
if (!get_magic_quotes_gpc()) {
$HTTP_GET_VARS = updateMagicQuotes($HTTP_GET_VARS);
$HTTP_POST_VARS = updateMagicQuotes($HTTP_POST_VARS);
$HTTP_COOKIE_VARS = updateMagicQuotes($HTTP_COOKIE_VARS);
}
}
if (!isset($HTTP_SERVER_VARS['REQUEST_URI'])) {
$HTTP_SERVER_VARS['REQUEST_URI'] = $HTTP_SERVER_VARS['PHP_SELF'];
}
?>
And when I load the page in the browser using this format to switch users, it works...just switch the number of the user on the end.
http://www.allartistaccess.com/profilepics.php?userid=43
How would I get this to be over in the template getinfo?