Storing XML
I'm designing a website that will use XML to store all the content of my
web pages. I will use a PHP script to parse the XML. Should I store the
XML in a MySQL database or should I simply store the XML in *.xml files
on my server? Which would would yield better performance? And would
using one PHP script to parse all the pages be too much on one script
(I'll have about 600 pages)?
View Complete Forum Thread with Replies
Related Forum Messages:
Storing Vs Not
printing $database[somevar] a couple times in your code or manipulting it, such as multiplying it by 2, or storing it under $myvar and using $myvar.
View Replies !
Storing Data
Say I have a number: number = 34043923, this represents a wordID, so the word belonging to this wordID is say: forum (whatever). This can be stored in 4 bytes (so i am told ) BUT when I save it with fopen/fwrite it takes up 8 bytes (1 for every character) and the file can be read (when opening the file it just reads 34043923). How can I store this data so it takes up only 4 bytes AND how can I do this storing it in a textfield of a mysql db?
View Replies !
Cookie Storing
I have this script so far: <? session_start(); if (!isset($_SESSION['track'])) { $_SESSION['track'] = 0; } else { $_SESSION['track']++; } ?> Which sets a cookie. I can also check if the cookie exists when the user goes to another page. How do you store information in the cookie? For example if I want to store a number like 1200, and then get that information from the cookie again when they go to another page?
View Replies !
Storing Classes
I have a script which calls up a class stored in a file FormatText.class . I don't want my .class files to be accessible if anyone types the URL of the class - I only want my class file accessible by a PHP script called by my server. I use require_once "FormatText.class";o get the class. Where do people typically place the class files when designing software? Shoud I put it in the root folder? I also have a text file I often call that contains sensitive database information. I placed that file in the main directory, (one up from the www directory). How safe is that file? Is that standard practice?
View Replies !
Storing Dates?
i am trying to design a script for sending mot reminders out 2 clients they sign up online then 10days before there mot expires the script sends a e-mail out reminding them what would be the best way to store the dates in my database?
View Replies !
Storing Array In A Row
I run a site with staff-submitted reviews, and most of them are written by one author. However, we also do "multiple" reviews. Up until now I just had a userid for a 'Multiple' account and submitted them under that, but this makes it harder to print lists of all the reviews by one person, so ideally I wanna make a multiple select form so we can just select all the contributors and have the values saved in the database - in one row (something like "56,34,21" etc). I've coded a multiple select form with all the authors of articles for my site on, and I want to store the results of this in one row so I can grab them as an array later - how can I go about doing this? I just googled and came across using <select name="author[]"> in my HTML, and then using serialize() to process it, but it fails. When I run the following code, the value for 'multiplearray' remains at 0 whether I select single OR multiple values on the form: <?php $dbhost = ### $dbuser = ### $dbpass = ### $dbname = ### $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); mysql_select_db($dbname); if(isset($_POST['save'])) { $author = serialize($_POST['author']); $query = "INSERT INTO review_test (multiplearray) VALUES ('$author')"; mysql_query($query) or die('Error ,query failed'); echo "Query successful!"; } echo "<form name='test' method='post' action=''>"; $query2 = "SELECT Staff_id, displayname FROM users WHERE userlevel !=0 ORDER BY username"; $result2 = mysql_query($query2) or die('Error : ' . mysql_error()); echo "<select name='author[]' id='author[]' multiple='multiple' size=ཆ'>"; while($row2 = mysql_fetch_array($result2, MYSQL_NUM)) { list($Staff_id, $displayname) = $row2; echo "<option value='$Staff_id'>$displayname</option>"; } echo "</select>"; echo "<br><br><input name='save' type='submit' id='save' value='Post Review'>"; echo "</form>"; ?>
View Replies !
Storing Dates In DB
What do you think is the best way to store Dates into a database ? If you want to keep logs or buckups.... I am using date('dmYHis') but I doesn't work really well ... Is it better to use date(U) ?
View Replies !
Session Not Storing ID
I am attempting to create a login in script using a session variable to hold the user id. I have got the log in facility working. Just before I redirect the user I set the session variable to the ID. Then when I get to the next page I check to see if the session exists, if it does then I output it. The only problem is that instead of outputting the ID I keep getting 'Session ID: Resource id #7' Code:
View Replies !
Storing Sessions
Can anyone tell me what is the best way to store sessions into database in order to recognize that user next time he access the site?I thought about IP address but then I remembered that it is different every time.What thing regarding a user is always the same?
View Replies !
Storing Results For Later Use?
Is it possible to store results that are parsed from an xml file and then use them on a different web page? Basically I want to store the data within the nodes and then use that data on another web page. Kinda like adding pagination but instead of gettign the info from a db I am getting it from a xml file. Code:
View Replies !
Storing Sessions...
Does it matter how and where they're stored? I was reading through this tutorial and I can across a discussion on where sessions are stored. I was under the impression that this wasn't something I had to worry about..
View Replies !
Storing SQL In A XML File
I'm trying to store a sql statement in a xml file like so: <sql>"SELECT customers.customers_email_address, customers.customers_password,can_seller_profiles.seller_social_name,manufacturers.manufacturers_imag e FROM customers ,can_seller_profiles ,manufacturers WHERE customers.customers_id = '$acc_id' AND can_seller_profiles.seller_customers_id = '$acc_id' AND manufacturers.manufacturers_id = '$seller_man_id'"</sql> but when I echo the the sql in php the vars aren't being populated. I'm trying to avoid hard coding the statements do theres something like 30 plus statements.
View Replies !
Storing The Value Of A Textbox
I have a form with a textbox and A submit button. I want the value of the textbox to be stored in a variable so as to pass through to other pages. I have reached this point: page 1 <?php session_start(); if (isset($_POST['txtusername']))    $_SESSION['test'] = $_POST['txtusername']; $_SESSION['test'] = ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> Im testing it both on localhost and web server. Unfortunately, the opening page is blank.
View Replies !
Mp3 / Pdf Storing Into Database
What's disadvantages of storing mp3/pdf/doc files into database instead of uploading to a folder . If you store into database its very easy to restrict user to download the files.
View Replies !
Storing Passwords
How do you guys go about filtering passwords before storing name. I have my username filter set to only allow numbers and letters but not how to implement a filter for passwords as people may prefer using characters, for better protection, which may inadvertently lead to cross scripting vulnerabilities.
View Replies !
Storing Arrays
Im trying to figure out a good way to store an array in mysql, and be able to retrieve the entire array, back into an array. Im building a form that allows authors to submit "Tags" for their books, so people can search on these "Tags" and it will search the Authors table in mysql for matching tags, so that readers can simply enter a tag, and find books that match the tags. For example: Thru a form, an author might type php,mysql,development - Those would then by submitted by a form, So what function could i use to put those into an array? Then how would i store the array in mysql and be able to retrieve it back into an array, for example /author.php?author=mike If mike's tags were php,mysql,development id like to list that on the php page next to his book. So what im trying to do is, 1. Get comma seperated values and put them into an array. 2. Store the array in mysql, and be able to retrieve it back into an array(i know database functions, just not sure what datatype i should use for the column to store these in).
View Replies !
Storing Settings In A DB
I have a table containing two fields, `name` and `value`. Is it possible to loop through all rows in the table, and assign a variable of with the name stored in `name` and value `value`? It's the storing variables when you don't know the name of the variable you're creating that's a problem.
View Replies !
Storing XML In MySQL
What I am trying to accopmlish is to somehow store XML data into MySQL (using PHP I'm guessing). Can anyone point me in the right direction to get started?
View Replies !
Storing Translations
-translations for different languages are stored in .ini files. -the choosen language is stored in a $_session['lang'] variable. -for every file accessed i load the .ini file representing the $_session['lang'] and store it in the _strings() array.and use those strings for substitution. The Question: is it better if i store the translated text once in a similar $_session variable for use during the whole session.or better to create a new instance of the i18n class and reload the .ini translation file for every new page the user access?
View Replies !
Storing App Settings
storing settings in php files like this: File : settings.php <?php $settings['cacheDir']='cache_directory' $settings['templateDir']='template directory' ?> File: index.php require_once("settings.php"); is is secure enough or should i store those settings in constants instead? i mean is there any chance that the user can override those settings when accessing the index.php page from the web?
View Replies !
Storing _FILES
how do you store all the information inside _FILES[] when you do a post. How long does a file stay in the temp dir before you have to move it or it gets deleted. I need to know this because I want one php file to have the upload GUI and another to actually store the file on the server but I do not know how to pass the file information between the two.
View Replies !
Storing An Image
<?php header('Content-type: image/jpeg'); $filename="downloads/Image/large/21-47-110-1.jpg"; $img_temp = imagecreatefromjpeg($filename); $img_thumb=imagecreatetruecolor(132,99); imagecopyresampled($img_thumb,$img_temp,0,0,0,0,132,99,imagesx($img_temp),imagesy($img_temp)); imagejpeg($img_thumb, "", 60); //this is the bit I am not sure about. $handle = fopen("downloads/Image/large/test.jpg", "a"); fwrite($handle, $img_thumb); fclose($handle); imagedestroy($img_thumb); ?>
View Replies !
Storing Same Values
I'm working with my MySQL database and had a question. How would you store two of the same values within the same column? I have three: loginName, id (auto_increment), and Image. How would I make it so that loginName can store the same values multiple times? Does it have anything to do with primary, unique, and index keys? Becuase I'm in phpMyadmin right now and I'm tempted to start pressing buttons to find out what they do.
View Replies !
Storing MySQL
I need to store results from a MySQL call to a multidimensional array. My code is as follows: Code: $db = mysql_connect("localhost", "admin", "password"); mysql_select_db("myDatabase",$db); $query = "SELECT * FROM content WHERE filetype LIKE 'URL'"; $result = mysql_query($query); for($i=0;$row = mysql_fetch_array($result);$i++){ $multiResults[$i] = array(mysql_fetch_row($row)); }
View Replies !
Storing Data For Use
I want to store an array on the server for use across multiple pages. I know and have been using sessions, but it just kills me to know that if the user turns cookies off, this is all gonna stop working unless I want that big session id in all urls. Also, the info in this array is by no means specific to each user, its the same for all of them. Is there any alternatives to this? Some way of storing an array which would be accessible by multiple pages.
View Replies !
Storing Object Into Array - OOP
Can I store objects into an array? $anArray[$index] = $anObject; $anArray[$index]->aMethod(); I have problems executing the above code. Does anyone knows a better/correct way of doing it? How do I invoke a method belonging to that object?
View Replies !
Storing Image Into BLOB
I am having one problem which is that: - I can upload and store image into BLOB field normally on one machine-winXP where installed Apache 2 and php 4.x - exactly same php code not functioning on the another machine-winXP where running Apache 1.3 and php 4.x What is problem, can I have help from some one? When I check the data stored in BLOB field (by means of saving into Desktop using MySQL Control Center) it were always stored 77 bytes of image/jpeg data, and 66 bytes of image/bmp files!
View Replies !
Storing Object In Session
I'm trying to figure out how to store an object in session. To try this, I have apache2 and php5 running on my windows machine. I used the 2 files below. First i run test.php, which creates the object, puts some data in it, and stores it in the session. test2.php retrieves the object from the session and prints the data. Works fine on my windows machine. However, when I upload these 2 files to my hosting provider, then it does not work anymore. I get no errors, but the object seems to be empty. The provider is running php4.3 ... Can someone help me find a way to fix this? Code:
View Replies !
Storing Current Url In A Variable
I want to store the current page url in variable $link I used $link=$_SERVER['PHP_SELF']; But it gave me only pages.php if the current link is [url]http://www.example.com/pages.php?catid=1&id=3 This is required as i am storing the url in a social bookmarking site ...
View Replies !
Storing A Hierarchy In An Array
I am having some troubles. What I am doing here is dealing with an employee hierarchy that is stored in an array. It looks like this: $employees = array( "user_id" => array( "name", "title", "reports to user id", "start date in the format: mm/dd/yyyy" ) ); How can I display this hierarchy in simple nested <li> tags in the most efficient way possible? I realize that the way this is setup, the hierarchy is essentially a tree. But I am at a loss as to how to pull this data out, sort it, and display it wit nested <li> tags. I am thinking that this is more of a computer science problem.... What I mean by displayed as a hierarchy, is that the nested <li> tags will indent themselves to look like that. Like this: - CEO -- Manager --- Manager's secretary --- Minion -- Manager That sort of thing. I am just lost as to how I can analyze the structure of the array and turn it in to output like that.
View Replies !
Storing Months In Mysql 4
I'm using PHP 4 and MySQL 4. I want to store the month and year as a single row but I am having difficulty figuring out the best data type to use. I suppose I could use 'DATE' and then always have the day value be equal fto 1, but I figure there's a more elegant approach. I leave it to on e of you experts to recommend one.
View Replies !
Storing Sessions In Mysql
I'm working on a shopping cart which uses sessions and I'm battling with a couple of decisions ... 1) Allow users who don't use cookies Currently I'm passing the SID's in the url for those not allowing cookies. Is there anything I should be considering when displaying SID's in the browsers address? Should I just disallow those not allowing cookies? 2) Store the session ID's and cart contents in mysql for non registered visitors. I can see that there might be a reason to obtain statistics on visitors who fill a cart and don't register, but I can see a lot of redundant data being left in the db. Currently I'm storing everything in an array and then once the visitor has created an account I'm going to input the contents of the array into the db. Does anyone have any personal preference over these design considerations which I may have overlooked?
View Replies !
Storing Information Without Cookies.
I am trying my hand at writing a forum in PHP. I wanted to know how is it possible to save information such as the visited threads so that the correct icon is displayed. I know how to do this using cookies, but how can I do that without using them so that when a member deletes cookies from his system, his activity information is still preserved?
View Replies !
Session Variables Not Storing
i recently read the tutorial on this site about e-commerce. im completing the second lesson and i cant seem to get any of the session variables to store. im sure there isnt a problem with the code as its directly from the tutorial. ive played around with settings in my php.ini file but cant seem to get anywhere. im a real novice at this stuff so any info would be great!
View Replies !
Storing Error Messages
I know how to turn off error reporting to stop php from printing the error messages but what if I also want to store the error messages into an mysql table? What's the variable that stores the error message?
View Replies !
Storing Files From Database.
I have a file put into a MySQL database. And when I get this certain file out of the database, the save-as dialogbox wants to save the file as phpgetter.php (this is the same name as the php-file that gets the certain file out of the database). Does anybody know how I can change this? I want to change this "save-as" phpgetter.php into output.ps .
View Replies !
Storing And Retreiving Dates
I've been trying to store an form inputted date into a database and then retreive it, but it doesn't come out the same when I pull it out of the database. I have noted that MySQL has date column types which store dates in reverse sequence to the mktime() function in php, so I tried using a MEDIUMINT column for storing the date. Do I need to reverse the order of the date and then store it in one of the DATE type columns in MySQL or what?
View Replies !
Storing File In Oracle
How can I store a binary file into Oracle using PHP? I have some word docs that I want to upload. Also, I would like to know how to download it from the Oracle and load it in my IE automatically.
View Replies !
Storing/Retrieving/Executing Php
I want to creating an application where all my php(with html) is stored in the database. So my index.php would find the appropriate the php file associated with the index page. It should execute this new code as part of the original index.php. Can you please let me know if it is doable?
View Replies !
Storing 2 Values In 1 Cookie
I am writing some forum software, and I would like to add the feature so that people can have the option for the forum to remember their username and password. Can I store both the username and password in one cookie, or do I have to do it with two cookies? I thought that I could separate the username and password with a pipe symbol then store them in a cookie, and then when I retrieve the cookie, I could spilt the data at the cookie forming an array or something like that, I'm not too familiar with this stuff.
View Replies !
Storing Credit Cards In The UK ?
I have to rewrite the ordering section of a site in PHP (it's currently ASP). I heard it's illegal to store the 3 verification digits AT ALL. Is that true in the UK? Apparently they are storing credit card numbers in the database, with a 2-way encryption and they don't want to change it so... How can I encrypt/decrypt the numbers? There was a crypt/decrypt function in the PHP manual user notes, but it's far too SLOW.
View Replies !
Storing Files On A Database?
I wrote this script to display different files from a database and properly display them by their respective MIME types. I have two questions: the first is that it just so happens not to work, and I'm just wondering if there are any discrepancies that I can't see that maybe someone else can, and the second is what would be the benefits and the drawbacks of storing different types of files in a database, for example files like jpeg and gif images, flash files, and mpeg videos? Code: <?php error_reporting(E_ALL); require 'config.php' $id = $_GET['id']; $dbTable = $_GET['tb']; dbConnect(); $query = "SELECT content, mime_type FROM ".$dbTable." WHERE id=".$id; $result = mysql_query("$query") or die("Invalid query: " . mysql_error()); $data = mysql_fetch_array($result); header("Content-type: ".stripslashes($data['mime_type'])); echo stripslashes($data['content']); dbDisconnect(); ?>
View Replies !
Storing Text As It's Typed
I have a comments box (textarea) on my site and want to know how to store the text written exactly as it's typed! For example everything i'm writing here will appear as i've typed, all the line breaks will be in place etc... With my script it only stores the text and not any line breaks etc.. How do I do this? Do I need to create a parser to recognise line breaks?
View Replies !
Storing Text With Variables
I am storing text in a blob in SQL, then generating the variable values in code then bringing up the text, the text however shows blank where the variable are although en echo after the text display will show the var displayed correctly. heres an example. Stored text : This is a test to show the variable <? echo $variable ?>, if this works it should be displayed as below. I set $variable="test"; echo the stored text and i get This is a test to show the variable, if this works it should be displayed as below. when I want to see This is a test to show the variable test, if this works it should be displayed as below. Code:
View Replies !
Storing Variable In Mysql
i have stored a variable into my database, i would like it to be a variable instead of being plain text, eg. i store $teazer in the db right, and then before i read the database i populate the vaiable $teazer rite, then i want it to come after a certain paragraph on some other page, so i figured the way to do it was to put it inside the db and it will be invoked by that variable.
View Replies !
Storing A File In A Php Array?
I have been searching the internet for examples of how to transmit data to a given server (for example a simple .php server). At the moment im not interested in how the server side deals with it but just how the client side does. The front end gives the user the abiltiy to upload a fie (say in this case an image .jpg). Basically the file is selected into an upload field and then a submit button hit. From here is where I need help How will the image will be stored so it can be transmitted? I know in java you can use byte arrays, but I dont seem to be able to find anything useful on the web to do this in php?
View Replies !
Array For Storing The Values
I have used an array for storing the values but i think it is initializing the array again and again. I am making an application in php in which when a user clicks any other user his particular id gets picked up in an variable and i am putting that value in an array but i want to to append an array means the previous value remains as it is. I am using this code:
View Replies !
Storing Variables In A Session
I'm sending a number of variables between 2 pages using the form GET method, and I want to store them in a session. The variables are basically called after dates and they will equal "yes" if the user has selected them. Eg. they might have selected 3 tickboxes in page 1: $07042007 = yes $18042007 = yes $22042007 = yes which get sent to page 2 via the URL is there any way of storing these in session variables of the same names?
View Replies !
|
TRACKER
