K just been looking at me own login script and realised it's been made in a different way and no use at this time, good luck, happy code, happy day. This may be of use though.. Login.php
<?php
include("dbconnect.php");
// Same checking stuff all over again.
if(isset($_POST['submit'])) {
if(empty($_POST['admin_username']) || empty($_POST['admin_password'])) {
echo "Opps! You have to fill in all forms";
$head_info='<meta http-equiv="refresh" content="2;url=login.php">';
exit;
} // Create the variables again.
$username = $_POST['admin_username']; $password = $_POST['admin_password'];
// Encrypt the password again with the md5 hash.
// This way the password is now the same as the password inside the database.
$password = md5($password);
// Store the SQL query inside a variable.
// ONLY the username you have filled in is retrieved from the database.
$query = "SELECT admin_username, admin_password
FROM admin_login
WHERE admin_username='$username'";
$result = mysql_query($query);
if(!$result) {
// Gives an error if the username given does not exist.
// or if something else is wrong.
echo "Failed " . mysql_error();
} else {
// Now create an object from the data you've retrieved.
$row = mysql_fetch_object($result);
// You've now created an object containing the data.
// You can call data by using -> after $row.
// For example now the password is checked if they're equal.
include("session.php");
echo "login sucessful. Please wait. Redirecting you to our administration page now";
$head_info='<meta http-equiv="refresh" content="2;url=admin.php">';
if($row->password != $password) {
echo "Wrong password.";
$head_info='<meta http-equiv="refresh" content="2;url=login.php">';
exit;
}
}
}
?>
<html>
Might be overly complex os_dev. I've got some easy login script. uses includes -etc.. less variables. Session should always be at the top - no whitespace. thought some 'if isset and so on could smooth things up' Nice work though. I'll be coming back to this one :^)
Ajax/JS would be useful for dynamic update of page (add/edit functions), although not essential.
I've only scanned your code, I'm afraid - long tracts give me a nose-bleed!
You could have a list of posts (headline and bodytext) with a clickable image linked to a js command. This loads a lightbox with a form linked to the post id via hidden field value. The lightbox form is sent to an ajax js function which runs the mysql functions and updates the particular div holding the edited post.
You could also have an 'Add New Post' image which pops up a similar lightbox, but has a value of 'new' in the hidden field. The form is sent to an ajax/js function which adds a new record into the DB and appends a div to the page holding the new info.
The images (add and edit) do not appear if the user is logged out.
Just a thought.
Yea good thought - thanks. A php job just at the moment, but that's a cool thought. :^)
how can i make once button A is clicked, the functions of button B is still present.
You could use two different forms. And to preset a button. Use....
<input type="radio" value="Pick Me" checked />
Or what about check boxes. Here is a quote...
"Radio buttons are used when you want to let the visitor select one - and just one - option from a set of alternatives. If more options are to be allowed at the same time you should use check boxes instead".
a key or primary key is required for anything that is 'auto incremented' so you can 'unlock' the rest of the table. The field should be called something like "table_id" and use "auto increment" and be "primary key" or you will get errors for sure.
Hello. OK won't post my messy code just yet, but the Problem;
A user can UPDATE a text field consisting of a headline and a text field. This is posted into a 'text div' below. when logged out, the form and editable fuctions vanish and we have a normal web page.
A user can add a text field which consists of a 'headline' and a 'text'. But does not then become editable or viewable, just simply posts into the msql database.
So. HOW DO I GET THE ID AND THEN EDIT THE ID ON THE SAME PAGE? Happy to send the code to anyone interested in having a go at this.
Then make or use a 'scripts' folder. In the 'scripts' folder you'll need this file. Copy and paste the whole file and save it as above 'ajax.js'.
var xmlhttp;
function loadXMLDoc(url)
{
xmlhttp=null;
if (window.XMLHttpRequest)
{// code for Firefox, Opera, IE7, etc.
xmlhttp=new XMLHttpRequest();
}
else if (window.ActiveXObject)
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
if (xmlhttp!=null)
{
xmlhttp.onreadystatechange=state_Change;
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
}
else
{
alert("Your browser does not support XMLHTTP.");
}
}
function state_Change()
{
if (xmlhttp.readyState==4)
{// 4 = "loaded"
if (xmlhttp.status==200)
{// 200 = "OK"
document.getElementById('your_id').innerHTML=xmlhttp.responseText;
}
else
{
alert("Problem retrieving data:" + xmlhttp.statusText);
}
}
}
Then to call your new section or 'div' use div id = 'your_id' you can find it in the above code and call it whatever you like. id = 'your_id'.
Then call it in your html page like this...
<div class="something" onclick="loadXMLDoc('your_id')" style="cursor: pointer" onMouseOver="style.color='#6b93fa'" onMouseOut="style.color='black'"><br />Read more >></div>
'your_id' is a file named 'your_id.xml' or 'your_id.html' and you can create in it anything you like. Just leave out html tags for that field and etc..
The 'key' is there to 'unlock' all other fields in the table. It 'auto increments' with a 'unique id' so that records are kept separate and tidy and so that you can access and refer to and update specific records.
<form action="<?php $PHP_SELF;?>" method="post"><input type="submit" value="Create new text field" name="change_text" id="change_text"></form>
<?php
if ($logged_in == 'true') {
if (isset($_POST['change_text'])){
if (!isset($_POST['submit1'])){?>
and then this...
if (isset($_POST['submit1'])){echo $text2, $headline2;}
if ($_POST['headline']){
if ($_POST['text']){
include("admin/create_text.php");
Notice the initial if ! is set post - very easy very nice. You could always try styling your 'submit' button with css?!
The only problem with inserting the <p> tags is that unless there are two blank lines to represent a removed <p> tag then it would be impossible to reverse because how would the computer know where to insert these tags? It is best not to strip them in the first place.
Maybe I forget strip tags and use css
#textarea <p>, <br />,
{
display: none;
}
Good thinking, thanks very much, I'll give it a go in the morning. :^)
But we need a code that will reverse what has been posted and then selected from and to the database.
The text area posts carrige returns and line breaks to the database and spits all that into the text div. The tags you suggest I keep are the ones I want to get rid of they will just appear as <p>paragraph</p>.
I'm looking for output - or update to a text field where html tags are output to a textarea just like
this
not like<br />this
I may be barking up the wrong tree but I've done some solid code on this and appreciate your input and output, He He :^) Thanks to date().
Have you got some tables and fields set up in mysql? With date fields?
$from_date= date(Y,M,D)//or whatever php date function u decide.
$to_date = date(Y,M,D)//or whatever php date, could be today for example.
$from_date = $_REQUEST['day_one'];
$to_date = $_REQUEST['today'];
then you SELECT day one < = $from_date and > = $to_date WHERE this AND so on...
By the way, nice function wasn't aware of it. What's happening is that line breaks and paragraphs are posted from the text field to the text div as html tags then echoed and the tags stripped out.
so the text field reads; paragraph,paragraph and without strip_tags; <p>paragraph</p><p>paragraph</p>
Both ways post to the text div as;
paragraph
paragraph
Which is how I'd like my text field to look and behave.
Okay I have a textarea that edits a text div. When the user edits the text and submits, paragraphs and line breaks are passed to the div.
i.e (not the browser)text div after submit....
'WARNING - This email and any attachments may be private & confidential.
If received in error, please delete and inform us by return email.'
textarea after submit....
'WARNING - This email and any attachments may be private & confidential. If received in error, please delete and inform us by return email.'
So the question is how can I get those paragraphs and breaks stored and retrieved from a Mysql database, when using strip tags?
snippet that makes html tags for new lines..
$text = $row['text'];
$headline = $row['headline'];
// Use \n for newline on all systems
$text = preg_replace("/(\r\n|\n|\r)/", "\n", $text);
// Only allow two newlines in a row.
$text = preg_replace("/\n\n+/", "\n\n", $text);
// Put <p>..</p> around paragraphs
$text = preg_replace('/\n?(.+?)(\n\n|\z)/s', "<p>$1</p>", $text);
// Convert newlines not preceded by </p> to a <br /> tag
$text = preg_replace('|(?<!</p>)\s*\n|', "<br />", $text);
snippet that echos database info and strips the html
Oh well nice to see some code in this thread. Here is some of the same if it is php Mysql you are looking for.
<?php
include ("../includes/dbconnect.php");
$tableName ="your_table";
$this = "this";
$sql="SELECT * FROM $tableName WHERE $this = 'this' ORDER BY first ASC";
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);
while($rows=mysql_fetch_array($result)){
$result = this that and the other
?>
The SELECT * FROM this that and the other your_table_name is something to look at. also would be good to know some more about the original question Hope to be useful H
Or This code works well with lots of conditions to meet
$sql = "SELECT * FROM artists_details LEFT JOIN attendance ON attendance.record_id AND attendance.visit_date >= '".$from_date."' AND attendance.visit_date <= '".$to_date."' WHERE artists_details.youth='youth' AND attendance.artist_id=artists_details.artist_id AND artists_details.outreach='outreach'";
//echo $sql;
$result4=mysql_query($sql);
$num_rows_y = mysql_num_rows($result4);
