Hi to all
I can make a presentation of fixed images easily in Flash.
I want to ask if its possible to do it dynamically from a database?
Regards
F
5 2018
You can either have action script access the database or have PHP get it from the database and give it to your flash application.
Dan
I'll get digging into reading.
Best
F
Hi Guys
I have this piece of code that is supposed to produce XML from data retrieved from database Garant. Could anyon tell me why it has stopped working? Its bound to be syntax again but I would appreciate a second pair of eyes to look at it.
Regards FJW - <?PHP
-
// slider.php
-
require("./resources/globals.php") ;
-
// Generate the SQL command for doing a select from the Database
-
$query = "SELECT smallpic,Ref,Pic1 FROM Garant LIMIT 10";
-
-
// Connect to the Database
-
$link=mysql_connect($location,$userName,$passwor d) or die (mysql_error());
-
mysql_select_db($dbname) or die (mysql_error());
-
$results=mysql_query($query) or die (mysql_error());
-
-
// Select the Database
-
if (!mysql_select_db($dbname, $link)) {
-
DisplayErrMsg(sprintf("Error in selecting %s database", $dbname)) ;
-
DisplayErrMsg(sprintf("error:%d %s", mysql_errno($link), mysql_error($link))) ;
-
exit() ;
-
}
-
// Execute the Statement
-
if (!($results =mysql_query($query, $link))) {
-
DisplayErrMsg(sprintf("Error in executing %s stmt", $query)) ;
-
DisplayErrMsg(sprintf("error:%d %s", mysql_errno($link), mysql_error($link))) ;
-
exit() ;
-
}
-
// Display the results of the query
-
//header("Content-type: text/xml");
-
$linkID = mysql_connect($localhost, $userName, $password) or die("Could not connect to host.");
-
mysql_select_db($dbname, $linkID) or die("Could not find database.");
-
-
$resultID = mysql_query($query, $linkID) or die("Data not found.");
-
$xml_output = "<?xml version=\"1.0\"?>\n";
-
$xml_output .= "<images>\n";
-
for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){
-
$row = mysql_fetch_assoc($resultID);
-
$xml_output .= "<image src=\"images/tn/";
-
$xml_output .= "".$row['smallpic']."";
-
$xml_output .= "\" title=\"\" url=\"images/";
-
$xml_output .= "".$row['Pic1']."";
-
$xml_output .=" \">\n";
-
}
-
$xml_output .= "</images>";
-
echo $xml_output;
-
?>
- echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
-
$xml_output .= "<images>\n";
-
for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){
-
$row = mysql_fetch_assoc($resultID);
-
$xml_output .= "<image src=\"images/tn/";
-
$xml_output .= "".$row['smallpic']."";
-
$xml_output .= "\" title=\"\" url=\"images/";
-
$xml_output .= "".$row['Pic1']."";
-
$xml_output .=" \" />\n";
-
}
-
$xml_output .= "</images>";
-
echo $xml_output;
-
?>
thread closed as I got it all working fully automatically
Sign in to post your reply or Sign up for a free account.
Similar topics
by: JesusFreak |
last post by:
From: us_traveller@yahoo.com (JesusFreak)
Newsgroups: microsoft.public.scripting.jscript
Subject: toolbar script problem
NNTP-Posting-Host: 192.92.126.136
Recently, I downloaded the following...
|
by: Yuk Cheng |
last post by:
<<<start index.htm>>>
<html>
<head>
<script>
function perform(action){
}
</script>
</head>
|
by: Guadala Harry |
last post by:
AFAIK, when placing an object into the Cache with no special instructions
(no dependencies, sliding expirations, hard expirations, etc), it will just
sit there in the Cache until the system decides...
|
by: Alberto La Pera |
last post by:
Hi!
I'd like to realize a Custom Web Control for a sliding menu, but i really
don't know how to control the client-side "animation" of the menu.
Can anyone help me?
Thank you a lot in advance......
|
by: Viktor |
last post by:
Hello,
I started to rewrite the lightbox code for a different layout. The main
advantage would be to have a sliding image bar, but I can not get the
sliding motion.
The html code:
<div...
|
by: wsharad |
last post by:
Hi,
I have got a requirement. In my application, i have a JSP which includes an Applet. On top of that i have a Menu option, on click of which a sliding menu comes up. The problem is, the menu...
|
by: CKich30 |
last post by:
When viewing my page (siuehockey.net) in Firefox, it's setup how I want it to look. When i viewed it using IE, the menu at the top runs into the "Cougar Hockey/cougarhockey.net" at the top left....
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
| |