Data Integration :: Create A Slideshow That Pulls Information From A Database?
Apr 22, 2011
I want to create a slideshow banner that will showcase our products. The slideshow will contain the image of the product, the name, the price, the item code and the link when someone clicks on it. Each week we update the best sellers and it can be from 5 to 15 different products. Similar to what we have now in our website www.deiequipment.com which now is static, we want to animate it and rotate the products like a slideshow.The problem we are encountering is that we have to manually update the slideshow content.
We would like to know if there is a way through scripting or catalyst to connect to a database and simply update all these fields automatically. So for example if the database has 5 items, automatically will pre-fill each field listed above and the slideshow will have 5 products.
If we update the database now with 10 products, to update automatically. That way we can create 1 slide show, the time it takes to rotate to the next product, and add simple button controls to the slide show for next and back that will simply go through the loaded items.I tried to do a research on how to do it online but some takes me to scripting, others to catalyst dabases, but none are specific to what I need.As a note, the image will just be an image holder that will be updated with the image field in the database that points to the URL location of the image.
I use Flash CS4 (AS2) to develop an application where the swf pulls XML data from my database. I basically used the same script (AS & PHP) in a file which was done in Flash 8(AS2) which is NOT WORKING!.
I have a table (Excel File) about 1000 rows and 3 columns. I want to load this table to the Flash and then be able to fetch data by referring to the first column.
i'm remodeling a website i've done ([URL]). i want to exchange information between XML and Flash files. i almost did it, but where shoul display information about one item, the whole content of this 'field' is shown. i'll explain better. this swf displays works of an artist. but the field 'date' (or any other text field) display the content of all works (separated by commas). i'll post the xml code and the actionscript code.
I am in the process of creating a flash site for friend of mine. He wants to be able to have a guest list for his events in DC. I have created form boxes and have given them all "instance names". But I have absoultely NO clue how to have the text entered by people trying to get on the guest list sent to my server so we can all read it.
I have a book on Flash but it really doest explain how to do it at all. I'm guessing I need to do some actionscript?
I want to create a Flash file so a user can check boxes to filter what images are displayed--the (unfiltered) images would come from an XML file. Or, a MySQL database if that's easier. Is this possible? If so, how?
I have an SQL database setup which contains Herbal Information such as CommonName, LatinName, MedicalUse etc, and need to display the information in a Flash DataGrid Component. I also have the corresponding PHP script to connect, retrieve, add and delete items from the database. Although I am familiar with Flash in a design sense I have limited experience using Action Scripts and am unable to complete the connection myself.
I have a question about the loader class.I was reading some of the documentation on the follow web page:http:[url]....And I didn't get very far before I had my first question about how the loader class pulls in external information:
Quote:The loaded display object is added as a child of the Loader object.
Question one: By "display object" they are referring to your external content (.swf / .jpg / .mp3) correct?
Question two: "is added as a child of the Loader object" Dose this mean that you could define one instance of the loader class, and then have several URLRequests that plug into that one loader class.So in other words can you have multiple forms of content from different directory's being loaded through ONE loader class instance?I'm a visual person so I mapped my current understanding of this process in the follow Img.
I've made a flash page with user input for email and comments. The thing is I am working with a aspx.net server. The programmer has written out a aspx coding for the server side. Now all i have to do is write a script in the input fields in flash to connect to the aspx server. The progammer said that I would have to create variables inside the flash program to call to the aspx page he created. I am faily new to aspx and have no clue to writing a script with variables.
I am running CS3. I want to access and update a MS SQL database through ASP but I could not find data components to download for CS3. I found Phil Heinz's tutorial[URL] but it is for MX Pro 2004. Should I be using Flex to do this or will the Flash 8 data components work on CS3?
I would like to build a dynamic webdatabase.(One form that updates text and bit-maps.)I must use Microsoft ACCESS or mySQL.Is it possible and is there any video tutorials out there?I heard a lot of "tissling and tassling" that flash is not well suited to work with databases.
I am creating e-learning material that will be accessedonline by students. Is there anyway that Flash can write to adatabase to tell us how long the student was logged in for and how long there were on a page?
where you can load an image from a SQL database ? I would like to show this image in Flash, but i don't know how to load in from a SQL database using ASP.
I have made a .swf file that scrolls boxes- these boxes willin the end contain products contained in a ASP database. Here isthe problem, I don't know how to get the Flash movie I have made toSince I don't know flash that well, I have made transparentbuttons to go over the scrolling boxes to open a URL with theaction scripting -----on (release) {getURL("http://www.myurl"); } This works finebut I would like the content in the scrolling boxes to changedepending upon items in an ASP database. In the database, there isan area to specify "featured" items, which are dynamically put onthe site in specified areas where tags(anchors) for the "featured"items are placed. What I think I should do is code the tag(anchor) for the"featured" item into my flash movie but I don't know how to dothis.
I am trying to create a 'Password' database with flash to push both to and from an external database, the only problem is that I do not want to have to run IIS or Apache or any other web server. Is there any way to read a non localhost/web based type database within flash? If so can someone point me to a tutorial or at least in the right direction?
Is it possible for flash to accept value from a database?There is a database storing values "postions" and "descriptions" (there are 2 coloumns named so to store the values).In flash I want to accept the values entered in these 2 coloumns. How to go about it? If I create 2 dynamic text boxes with variable names "p" and "d" respectively and an "accept" button on the scene, what script should I add to the button so that these text boxes accept the values?
so my 2 queries are:
1) how do I send the value from the database to flash?
im trying to figure out if there is a way to use flash as a front end for a database. i need flash to be able to search the database for part numbers and match the part number with an excel file and be able to open the excel file from flash.
Is there a tutorial somewhere that tells/shows how to display an image from a db. I have my image paths in a mysql db and I am using php to display my other text fields. I just haven't been able to get my images to show. Below is the code that I am using so far. Here is my actual goal, I am trying to have a flash document the has a list in the datagrid that is connected to a mysql db. I have successfully done this. When a user clicks on a product in the datagrid it populates the details below the grid and I have done so successfully. What I now need is to show a picture of the product in the details section. I would also like to see how to show different images for different vendors, each vendor has its own image size, so if I put just one image placeholder then some of the images will be scewed. I need something that shows image in placeholder 1 if company=1, show image in placeholder 2 if company=2, etc.
It will not load the image from the database using ASP. I set Images as a variable from ASP. It was displaying "images/img1.jpg" instead of image visually.
I'm working on Flash project for which I have to conenct to Oracle database, retrieve data and display it.Is it possible to connect to Oracle database from Flash?
how to store the data in to a database using flash form(actually i created the frontend ie all input text feelds, but iam unable to save the data into the same system. i dont need to send the data through the net to any server or idont need to email it.
I need to create a login page in my flash site that relates to information input to a mysql database. after the submit their information we want to send them a link to a differnt flash page with a login screen they will use their first name and a password (already in our database) to gain access to this "new" page. on that page there will be a welcome message that says "Welcome, User First Name" so I guess i have two questions
1: how do i set up a login page?
2: how do i pull that login info to a welcome page?
I have a standalone flash app that needs to get user inputand send it to a remote server / database. When I use the methodbelow, a browser window opens which I don't want to happen - I wantthe data to be sent but not display the page.
This works fine when I test the movie from Flash (on my local machine) and if I type the query string directly into my browser, I get the correctly formatted information. The problem arises when I post the swf to my server and test. From my server, I get nothing The swf files and the data are on different servers. Is this the problem? What is a good quick solution.