xmlString ="<Chart:Bullet xmlns:Chart='http://yoursite.com' values='100,200' size='100x20' shading='5' ></Chart:Bullet>";
XmlDocument doc = new System.Xml.XmlDocument();
doc.LoadXml(xmlString);
//Instantiate an XmlNamespaceManager object.
System.Xml.XmlNamespaceManager xmlnsManager = new System.Xml.XmlNamespaceManager(xmldoc.NameTable);
//Add the namespaces used in books.xml to the XmlNamespaceManager.
xmlnsManager.AddNamespace("Chart", "http://yoursite.com");
If you have an input element of type="file" whose name="photo" then you should be using $_FILES['photo']['name'] since $_FILES['photo'] would actually be an array.
there is not "garbage" added "automatically". Most likely the data you are reading are on lines by themselves. Each line ends with a newline character, so when you read it in, that newline character (\n) is also included as part of $userPrefs[0] and $userPrefs[1] .
Ids must be unique, so you will need to change the id of at least one of them or you will likely experience cross-browser incompatibilities. However, it is OK to have multiple elements with the same class name. So, if you change those id='myid' to class='myid' then use $('.myid:eq(0)').html() to get the innerHTML of the first div. For the second div, change the zero to a ONE.
<?php
include "connecttodb.php";
$name = mysql_real_escape_string( $_POST['name']);
$email = mysql_real_escape_string($_POST['email']);
$password = mysql_real_escape_string($_POST['pass']);
$query = "INSERT INTO Account( username,password,email) VALUES('$name', '$password', '$email')";
mysql_query($query)
or die('There was an error in your registration');
echo'Registration Complete!';
mysql_close();
?>
You can incorporate checkboxes to the left of the name lists. Let's call it a DELETE column. If an item is checked, then delete that item. So your interface can be:
/*
Delete Name
[] John
[x] Bob
[] Sue
Assignment: [_Select an assignment_]
Person: _Frank__
{Submit}
Your checkboxes would basically be:
*/
<input type="checkbox" name="delete[]" value="1"/> John
<input type="checkbox" name="delete[]" value="12"/> Bob
<input type="checkbox" name="delete[]" value="34"/> Sue
Where the values 1, 12, AND 34 are the UNIQUE use ids for John, Bob, and Sue respectively.
On the above, when you submit, you should first look for the checked items and delete them from the SELECTED assignment:
It seems that $row[0] and $row[1] contain Arrays, NOT the numeric value you think they have. Try using: assuming they are INDEXED arrays, try $row[0][0] and $row[1][0] instead.
Let's say that you are browsing "aboutUs.asp" AND that it contains one of those problematic links. Look at the browser's source code. Does the link in question have href="http://liveserver.com" ?if so, it is not a server configuration problem. Otherwise, also look for <base href="http://liveserver.com"> . if you find it then it is not a server configuration problem, in which case you wil need to make the needed changes within your scripts
All you need is a list of all the assignments AND an empty field for your to enter/add Bob to Person. As soon as you add Bob to Person, get the new id for Bob and add it to GroupAssignment along with the id of his assignment:
<?php
if( isset($_POST) && !empty($_POST) )
{
$assignment=intval($_POST['assignment']);
//connect to db here
//...
if( $assignment > 0 )
{
//update your Assignment title here
mysql_query("Update Assignment SET title='".mysql_real_escape_string($_POST['title'])."' WHERE id=".$assignment) or die( mysql_error() );
echo "Assignment Title has been updated<br />";
}
if( $assignment > 0 && isset($_POST['person']) && !empty($_POST['person']) )
{
mysql_query("INSERT INTO Person('Name') VALUES('".mysql_real_escape_string($_POST['person'])."') ") or die(mysql_error());
mysql_query("INSERT INTO GroupAssignment(Person_id,Assignment_id,SubmissionDate) VALUES(" . $assignment . "," . mysql_insert_id() . ",'".date('Y-m-d')."')" or die(mysql_error());
}
echo 'New member added<br />';
}
$result=mysql_query("SELECT id,title FROM Assignment") or die( mysql_error() );
$assignments='<select name="assignment"><option value="">Make a selection</option>';
while( $row=mysql_fetch_assoc($result) )
{
$assignments.=sprintf('<option value="%s">%s</option>', $row['id'], htmlentities($row['title'], ENT_QUOTES) );
}
$assignments='</select>';
echo <<<FORM
<form method="post" action="{$_SERVER['PHP_SELF']}">
Assignment: {$assignments}<br />
Person: <input type="text" name="person" value="" /><br />
<input type="submit" name="Send" value="Add and Update"/>
</form>
FORM;
?>
On those string parameters, include the size of the fields as the fourth parameter. EX: assuming that NameStr is defined (in your DB Table) to be of size 100, try: call sp.addParam("@NameStr", 200, 1, [B]100[/B],"Stuff and Things")
<?php
//your page must start by calling session_start() first:
session_start();
//THEN you can begin saving data onto $_SESSION
//assuming that in YOUR example, $details is an array - ex:
$details=array('firstName'=>'john', 'lastName'=>'doe');
//then you just assign the array to $_SESSION
$_SESSION['ecart']=$details;
?>
page2.php
<?php
//If you need to retrieve the $_SESSION in page2.php, you MUST call session_start() first
session_start();
echo $_SESSION['ecart']['firstName'];
?>
No! a.) To delimit the strings you can use either DOUBLE QUOTES (") OR APOSTROPHES('). You are using the backtick(`) which is NOT correct b.) On the document.write() you need to separate different string using a comma(,) NOT a semicolon( ; )
<?xml-stylesheet type="text/xsl" href="cdcatalog.xsl"?> should appear only ONCE in the document. Currently you are appending that within your WHILE construct, so you are generating that multiple times. Move it OUTSIDE you while construct so that it is BEFORE the root/top-most element (basically between lines 8 and 9 in your markup).
Ideally `Group Member` should have just ONE value. So instead of one RECORD such as : Title 1 John, Sue, Amir 2010-10-10 You would need to enter THREE (each separately):
Title 1 John 2010-10-10
Title 1 Sue 2010-10-10
Title 1 Amir 2010-10-10
(pay special attention to the "Repeating Groups" section). My suggestion would be:
Person
id Name
1 John
2 Sue
3 Amir
4 Bob
Assignment
id title
1 Title 1
2 Title 2
3 Title 3
GroupAssignment
Assignment_id Person_id SubmissionDate
1 1 2010-10-10
1 2 2010-10-10
1 3 2010-10-10
2 1 2010-10-09
2 2 2010-10-09
2 4 2010-10-09
3 4 2010-10-06
3 2 2010-10-06
3 3 2010-10-06
And as far as the multiple selection box goes, Yes, you can still use it. You just need to make sure that when you receive those multiple selected values, you "break" them apart and insert each value as its own record in GroupAssignment.
i've detected the problem where my sql statement only call once for each assignments
You are seeing the correct results. Your query is returning all the relevant rows. The problem is in your DB design.
I hope anyone can help me without changing or upgrading my database..
Why would you want to impose this restriction when your DB design is the problem? If you really want to stick with your flawed design, what you need to do is when you retrieve the result, for every row, you will need to split 'Group Member' at the comma and then generate the rows you seek.
create cookie (ex: lastPageLoaded), and whenever you make an ajax request, upon successful retrieval of your content, update the cookie to the url you used last.
So, upon page load you just need to see if the cookie exists, If yes, load the page/content from whatever url is in the cookie. If not, then load your default page/content.
AFTER successful execution of line 11, $sql contains a resource NOT a string - so line 28 doesn't make sense. You need to extract the data from the resource ($sql) returned by your query. It is not clear to me which field in $sql you are interested in , but assuming that in your DB Table you have a field named 'mysteryField', then what you need to do is:
//try not to doe SELECT * if you are NOT going to use all your fields
$sql = mysql_query("SELECT `mysteryField` FROM `user` WHERE `username` = '$username'") or die( mysql_error() );
$row=mysql_fetch_assoc($sql);
...
$uploadfile=$row['mysteryField'].$ext;
/* you don't need this. If I upload 'hi.txt' and you want it renamed to 'bye.rtf' you just need to specify the NEW name as the second argument to move_uploaded file which you are ALREADY DOING.
//rename the file to the new one
@rename($file,$uploadfile);
*/
if(move_uploaded_file($_FILES['userfile']['tmp_name'], $uploadfile)){
...
}
wat to do i want to show particular image from database.
You need to know the id of the image you are interested in ahead of time. So if you know that you are interested in the image whose id=3, assuming that the code I posted above is named imageRetriever.php, then in you HTML page you need to put:
On line 34 you are attempting to submit the hidden form, BUT at that point, there is no such form defined/seen by the browser yet because you begin the definition until line 45. What you need to do is call that function AFTER you have closed the hidden form
What you need to do is make sure that the [B]SRC[/B] attribute points to some php page (let's call it imageRetriever.php) and that each url contains a unique ID to the image you want - ex:
<!-- You need to update the code you posted above so that it generates the following markup for EACH of the images. Given my example below, the assumption is that there would be only three images in your query result, but in your case it may be more or less. The 3, 12, and 47 I chose at random, but in your case these would be the unique ids for each of your images. -->
<img src="http://yoursite.com/imageRetriever.php?id=3" alt=""/>
<img src="http://yoursite.com/imageRetriever.php?id=12" alt=""/>
<img src="http://yoursite.com/imageRetriever.php?id=47" alt=""/>
Then in imageRetriever.php you need to use $_GET['id'] and use that value to query the db and send the binary data with the appropriate content-type (basically what you have above, but you need to do it for the reqquested image)
$str = "I will go to the store with <# one/two/three #> people<# four/five/six #>.";
if( preg_match_all( '![<]#([^#]+)#[>]!',$str,$matches) )
{
$id=0;
$prefix='place_';
foreach($matches[1] as $group=>$str)
{
$parts=explode('/',$str);
foreach($parts as $v)
{
++$id;
$v=trim($v);
echo PHP_EOL.'<input type="radio" id="'.$prefix.$id.'" name="'.$prefix.$group.'" value="'.$v.'" /><label for="'.$prefix.$id.'">'.ucfirst($v)."</label>";
}
}
}
