Hacym

October 9, 2012

You realize that you resurrected a topic from 2008, right?

September 29, 2012

When I was just starting out I just picked a small project and googled the different parts of how to do it. Learning by doing is always the best way, I think.

September 25, 2012

Nevermind. I got it to work. Solved.

September 25, 2012

Edit: I changed this:

   unlink($_GET['pasteid'].'.txt');

and am now getting a blank file.

September 25, 2012

Hello.

I am currently using an iframe to deliver my page, download.php, without changing my current page. The download.php page current looks like this:

<?php
require('config.php');

$contentlookup = $mysqli->prepare("SELECT content FROM publicpastes WHERE pasteid=?");
$contentlookup->bind_param("s", $_GET['pasteid']);
$contentlookup->bind_result($contenttowrite);
$contentlookup->execute();
$contentlookup->fetch();

$filename = $_GET['pasteid'].'.txt';
$filehandle = fopen($filename, 'w');
fwrite($filehandle, $contenttowrite);
fclose($filehandle);

$file = $_GET['pasteid'].'.txt';

header("Content-Type: application/octet-stream");
header("Content-Disposition: attachment; filename=".$file);
readfile($file);

unlink($pasteid.'.txt');

?>

So basically, I want it to create the file [pasteid].txt with the content from $contenttowrite. When downloading and opening the .txt file, though, I am getting this error:

<br />
<b>Warning</b>: unlink(.txt) [<a href='function.unlink'>function.unlink</a>]: No such file or directory <br />

Any ideas as to what I am doing wrong?

September 23, 2012

Thank you! It works!

Just one more thing, though. I can still go to the actual link and it doesn't change it. Is there a way to make it do that?

Also, yes, the pasteids will only contain letters and numbers. I'm not exactly sure how you would change that though, as I have never done anything like this :X

September 23, 2012

Hello,

I am trying to shorten my URLs for a pastebin-like project I am working on. Currently in my htaccess file, I have this:

 Options +FollowSymlinks
RewriteEngine On
RewriteRule ^([^/]*)$ /paste.php?pasteid=$1 [NC]

I am trying to shorten mydomain.com/paste.php?pasteid=pasteid to just mydomain.com/pasteid.

However, with this setup, I am getting an internal server error across the entire domain. I have looked at the logs I have avaliable to me, and cannot find anything referincing this...

Any ideas?

September 9, 2012

-.- Thank you.

September 9, 2012

I am having a stupid issue with the following code, and I have tried to get it to work in several ways to no avail:

if (isset($_POST['catcreate'])) {
		$catname = $_POST['catname'];

		$catcheck = $mysqli->prepare("SELECT * FROM categories WHERE name=? LIMIT 1");
		$catcheck->bind_param("s", $catname);
		$catcheck->execute();
		$catcheck->store_result();
		$catnum = $catcheck->num_rows;
		$catcheck->close();

		if ($catnum > 0) {
			echo "<div style=\"position:absolute; top:70px; left:300px;\"> Category already exists! </div>";
		} else {
			$catadd = $mysqli->prepare("INSERT INTO categories (name) values (?)");
			$catadd->bind_param("s", $catname);
			$catadd->execute();
			$catadd->close();

			echo "<div style=\"position:absolute; top:70px; left:300px;\"> Category added. </div>";
		}
	}

	if (isset($_POST['catdelete'])) {
		$catname = $_POST['catdropdown'];

		$catdelete = $mysqli->prepare("DELETE FROM categories WHERE name=?");
		$catdelete->bind_param("s", $catname);
		$catdelete->execute();

		$catreset = $mysqli->prepare("UPDATE articles SET category='Uncategorized' WHERE category=?");
		$catreset->bind_param("s", $catname);
		$catreset->execute;

		echo "<div style=\"position:absolute; top:70px; left:300px;\">Category deleted!</div>";
	}
}
}

It successfully deletes the category, but it doesn't reset the categories in the articles table.

My var_dump says this:

object(mysqli_stmt)#8 (9) { ["affected_rows"]=> int(0) ["insert_id"]=> int(0) ["num_rows"]=> int(0) ["param_count"]=> int(1) ["field_count"]=> int(0) ["errno"]=> int(0) ["error"]=> string(0) "" ["sqlstate"]=> string(5) "00000" ["id"]=> int(7) }

The SQL statement works in PHPMyAdmin.

I'm sure it's a stupid, easy thing I am missing, but I've tried several things and nothing seems to work.

Posted September 7, 2012 · September 7, 2012

I have one database with "articles," "categories," and "users" as tables.

Posted September 7, 2012 · September 7, 2012

I fixed the syntax of the UPDATE and it worked. Thank you for the help.

Use
$mysqli->prepare(...) or die($mysqli->error);
Why do You have separate databases for articles and categories?

What do you mean? How else can I list info about categories?

Posted September 7, 2012 · September 7, 2012

Yes, it returns false.

Posted September 7, 2012 · September 7, 2012

Hello,

I'm getting Fatal error: Call to a member function bind_param() on a non-object on the following code:

	if ($_GET['link'] == "create") {

	if(!isset($_GET['id'])) {
		echo "<div style=\"position:absolute; top:20px; left:300px;\">";
			echo "<form method=\"post\" action=\"index.php?link=create\">";
				date_default_timezone_set('America/New_York');
				$time = date('g:i A');
				$date = date('F j, Y');
				echo "Article title: <br />";
				echo "<input type=\"text\" name=\"title\" value=\"Article Title\" onblur=\"if (this.value == '') {this.value = 'Article Title';}\"
						onfocus=\"if (this.value == 'Article Title') {this.value = '';}\"><br />";
				echo "Posted at <input type=\"text\" name=\"time\" value=\"$time\"> on <input type=\"text\" name =\"date\" value=\"$date\"> by $username <br />";
				echo "Content:<br />"; 
				echo "<textarea name=\"content\" rows=30 cols=80></textarea> <br />";
				echo "Publish <input type=\"radio\" name=\"publish\" value=\"1\" checked> now or <input type=\"radio\" name=\"publish\" value=\"0\"> later in the category named ";

				$mysqli->select_db("categories");
				$cats = $mysqli->query("SELECT name FROM categories");

				echo "<select name=\"catdropdown\" value=''>";
				while ($catdropdown = mysqli_fetch_assoc($cats)) {
					echo '<option value="'.$catdropdown['name'].'">' . $catdropdown['name'] . '</option>';
				}
				echo "</select>";
				echo "<input type=\"hidden\" name=\"addarticle\"> <br />";
				echo "<input type=\"submit\" value=\"Add Article\">";
			echo "</form>";
		echo "</div>";
	}

	if (isset ($_POST['addarticle'])) {
		$title = $_POST['title'];
		$time = $_POST['time'];
		$date = $_POST['date'];
		$content = $_POST['content'];
		$publish = $_POST['publish'];
		$category = $_POST['catdropdown'];

		$mysqli->select_db("articles");
		$articleadd = $mysqli->prepare("INSERT INTO articles (title, author, time, date, content, published, category) values (?, ?, ?, ?, ?, ?, ?)");
		$articleadd->bind_param("sssssis", $title, $username, $time, $date, $content, $publish, $category);
		$articleadd->execute();
		$added = "1";
		$articleadd->close();
		echo "<div style=\"position:relative; top:640px; left:280px;\">";
			echo "Article has been added!";
			if ($publish == 0) {
				echo "Remember to come back and set this to published when you're ready!";
			}
		echo "</div>";
	}

	if(isset($_GET['id'])) {
		$id = $_GET['id'];

		$mysqli->select_db("articles");
		$query = "SELECT * FROM `articles` WHERE id=$id";

		if($articleedit = $mysqli->query($query))
			while ($articleeditinfo = $articleedit->fetch_assoc()) {
				echo "<div style=\"position:absolute; top:20px; left:300px;\">";
					echo "<form method=\"post\" action=\"index.php?link=create&id=".$id."\">";
						date_default_timezone_set('America/New_York');
						$time = date('g:i A');
						$date = date('F j, Y');
						echo "Article title: <br />";
						echo "<input type=\"text\" name=\"title\" value=\"".$articleeditinfo['title']."\"> <br />";
						echo "Posted at <input type=\"text\" name=\"time\" value=\"".$articleeditinfo['time']."\"> on <input type=\"text\" name =\"date\" value=\"".$articleeditinfo['date']."\"> by" .$articleeditinfo['username']. "<br />";
						echo "Content:<br />"; 
						echo "<textarea name=\"content\" rows=30 cols=80>".$articleeditinfo['content']."</textarea> <br />";
						echo "Publish";
						if ($articleeditinfo['published'] == 1) {
							echo "<input type=\"radio\" name=\"publish\" value=\"1\" checked> now or <input type=\"radio\" name=\"publish\" value=\"0\"> later in the category named ";
						} else {
							echo "<input type=\"radio\" name=\"publish\" value=\"1\"> now or <input type=\"radio\" name=\"publish\" value=\"0\" checked> later in the category named ";
						}

						$mysqli->select_db("categories");
						$cats = $mysqli->query("SELECT name FROM categories");

						echo "<select name=\"catdropdown\" value=''>";
						while ($catdropdown = mysqli_fetch_assoc($cats)) {
							echo '<option value="'.$catdropdown['name'].'">' . $catdropdown['name'] . '</option>';
						}
						echo "</select>";
						echo "<input type=\"hidden\" name=\"updatearticle\"> <br />";
						echo "<input type=\"submit\" value=\"Update Article\">";
					echo "</form>";
				echo "</div>";

		}

		if(isset($_POST['updatearticle'])) {
			$title = $_POST['title'];
			$time = $_POST['time'];
			$date = $_POST['date'];
			$content = $_POST['content'];
			$publish = $_POST['publish'];
			$category = $_POST['catdropdown'];

			$mysqli->select_db("articles");
			$articleupdate = $mysqli->prepare("UPDATE articles (title, author, time, date, content, published, category) values (?, ?, ?, ?, ?, ?, ?)");
			$articleupdate->bind_param("sssssis", $title, $username, $time, $date, $content, $publish, $category);
			$articleupdate->execute();
			$added = "1";
			$articleupdate->close();
			echo "<div style=\"position:relative; top:640px; left:280px;\">";
				echo "Article has been updated!";
				if ($publish == 0) {
					echo "Remember to come back and set this to published when you're ready!";
				}
			echo "</div>";
		}
	}

}

This specific error is happening on the update of the article, so with $articleupdate. I'm fiddled with everything I can think of and cannot see where the error is occurring.

Sign In

Hacym

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by Hacym

grabbing NFL scores

Complete Newb Questions! Pls Help :]

Write Temp Text File For Download

Write Temp Text File For Download

Write Temp Text File For Download

Mod_Rewrite Issue

Mod_Rewrite Issue

SQL statement isn't working, with no error.

SQL statement isn't working, with no error.

Fatal error: Call to a member function bind_param() on a non-object

Fatal error: Call to a member function bind_param() on a non-object

Fatal error: Call to a member function bind_param() on a non-object

Fatal error: Call to a member function bind_param() on a non-object

Browse

Activity

Important Information