If you need urgent support, call 999 or go to your nearest A&E. To contact our Crisis Messenger (open 24/7) text THEMIX to 85258.
Options
What kinda script would this be?
Former Member
Posts: 1,876,323 The Mix Honorary Guru
in General Chat
All I want is something that will allow users to visit the website, then paste whatever text they want into a box, and once the text has been pasted the script generates a link so they can send it their friends so they can view the pasted text.
0
Comments
Otherwise can have the same but save the data into the database and have the username in the link (http://yourdomain.com/view.php?user=name) that page then query the db and retrieve the content for the username...
I'm not to great with PHP so would need a ready made script.
which one you want, one using db or one creating html files?
Also do you want it to be so one user can have mutliple message or just one per user?
Just did it quite basic... Haven't done the view.php script, can do if you don't know how to retrieve the data from the database...
This script has been tested and work
<? // I am assuming you have PHP and MySQL // Script have been tested. /* MySQL table structure CREATE TABLE `user_data` ( `id` INT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `user` VARCHAR( 255 ) NOT NULL , `msg` LONGTEXT NOT NULL ) TYPE = MYISAM ; */ // MySQL settings (can be in a external file called sql.php) // Edit with your MySQL details $dbserver = "localhost"; $dbuser = "########"; $dbpass = "########"; $db = "########"; // require("sql.php"); if you want save setting in an external file // Check if form have been submitted with required variables if($_POST['submit'] && $_POST['user'] && $_POST['msg']){ // Variables assignement $user = $_POST['user']; $msg = $_POST['msg']; $msg = nl2br($msg); // Insert <br /> tag where needed $display = ""; // Connect to db $c = mysql_connect($dbserver,$dbuser,$dbpass); mysql_select_db($db); // We are checking if the user already use the sevice $sql = mysql_query(" SELECT * FROM `user_data` WHERE `user`='$user' "); $nb = mysql_num_rows($sql); // Check if user already use the service if($nb > 0){ // User already used it so don't store the data and create error message $display = "<font color=\"#ff0000\"><b>Sorry you can not use this service twice</b></font>"; }else{ // Insert data into data base. mysql_query(" INSERT INTO `user_data` (`id`,`user`,`msg`) VALUES ('','$user','$msg') ") or die ("couldn't insert data"); // Create success message $display = "<font color=\"00ff00\"><b>Message successful stored</b></font><br>"; // Create link $link = "http://mydomain.com/view.php?user=".$user; $link = "<a href=\"".$link."\">".$link."</a>"; } } if($display){ echo $display."<br/>"; } if($link){ echo $link."<br/><br/>"; } ?> <form action="script.php" method="post"> User: <input type="text" name="user" size="20"><br /> Message: <textarea name="msg" cols="20" rows="5">Type your message here...</textarea><br /> <input type="submit" name="submit" value=" SEND "> </form>You can also download the file for it here
If you could do the view.php, that would be great.
By the way, do you know the best resource for learning PHP?
For the erro message have you created the database table properly?
Cos tested the script and worked perfectly on my server...
No problemo
SELECT msg FROM ....
and I'd suggest changing the mysql_fetch to
$row=mysql_fetch_object($result);
and then use "$row->msg" instead of "$msg"
everyones a critic eh