PHP - Making Images / Backing Up / Ftp

Hello.

I want to make a web-based rpg with mysql and php but need alot of help, I tryed once and failed.

Please msn me:
cginbarrhaven@hotmail.com

I need LOTS of help.

Im stuck!

Zeroth

What kinds of things can I do to make Logging-In and being Logged-In *secure*??

I get the whole form validation thingy, but what about from the standpoint of how/where I store data in my database and how I keep track of who is logged in and where they can go, and so on?

Thanks,


Debbie

Hi am in the middle of making a blog but am having problems with one page am working on if anyone can help me please.
What is am looking for is to post username and avatar instead of just the username.
I have already paid some guy to work on this but he didnt get back to me and  ihave no more cash to give for the code to be finished so
i would really appreciate if someone could help to finish this off please thanks.

this is the where the username and text shows which i would like avatar to show as well.
Code: [Select]
<?php
    $query = yasDB_select("SELECT * FROM user WHERE username = '$user'");
$row = $avatarfile;
$query = yasDB_select("SELECT * FROM topic WHERE userid = '$id' ORDER BY id DESC LIMIT 5");
    if($query->num_rows == 0) { ?>
<div id="memberstext">This topic has no comments, be the first to add one!</div>
<?php 
} 
else { 
while($row = $query->fetch_array(MYSQLI_ASSOC)) {
$text = $row['comment'];
$text = str_replace(':D','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/biggrin.gif" title="biggrin" alt="biggrin" />',$text);
$text = str_replace(':?','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/confused.gif" title="confused" alt="confused" />',$text);
$text = str_replace('8)','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/cool.gif" title="cool" alt="cool" />',$text);
$text = str_replace(':cry:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/cry.gif" title="cry" alt="cry" />',$text);
$text = str_replace(':shock:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/eek.gif" title="eek" alt="eek" />',$text);
$text = str_replace(':evil:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/evil.gif" title="evil" alt="evil" />',$text);
$text = str_replace(':lol:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/lol.gif" title="lol" alt="lol" />',$text);
$text = str_replace(':x','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/mad.gif" title="mad" alt="mad" />',$text);
$text = str_replace(':P','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/stlyes/images/smileys/razz.gif" title="razz" alt="razz" />',$text);
$text = str_replace(':oops:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/redface.gif" title="redface" alt="redface" />',$text);
$text = str_replace(':roll:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/rolleyes.gif" title="rolleyes" alt="rolleyes" />',$text);
$text = str_replace(':(','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/sad.gif" title="sad" alt="sad" />',$text);
$text = str_replace(':)','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/smile.gif" title="smile" alt="smile" />',$text);
$text = str_replace(':o','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/surprised.gif" title="surprised" alt="surprised" />',$text);
$text = str_replace(':twisted:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/twisted.gif" title="twisted" alt="twisted" />',$text);
$text = str_replace(':wink:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/wink.gif" title="wink" alt="wink" />',$text);
            if ( $row['useavatar'] == '1' ) {
        $avatarimage = $siteurl . 'avatars/' . $row['avatarfile'];
            }
            else { 
        $avatarimage = $siteurl . 'avatars/useruploads/noavatar.gif';
            } ?>
<div id="box">
<div class="name"><img src="<?php echo $avatarimage;?>" height="40" width="40" align="left"><br /><?php echo $row['name'];?></div>
<div class="comment_text"><?php echo $text;?></div></div>
This is the form part of it to add the text
Code: [Select]
<div id="box2">
<form name="addcomment" method="post" action="">
<strong>Message:</strong><br />
<textarea name="comment" rows="3" cols="40" id="comment_message"></textarea><br />
<input name="userid" type="hidden" value="<?php echo $id;?>" />
<input type="hidden" name="timestamp" id="timestamp" value="<?php echo time(); ?>" />
</center>
<!-- start of smiles -->
<div id="smiles"><center>
<a href="javascript:addsmilie(' :D ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/biggrin.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :? ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/confused.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' 8) ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/cool.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :cry: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/cry.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :shock: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/eek.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :evil: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/evil.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :lol: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/lol.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :x ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/mad.gif';?>" border="0"  /></a><br />
<a href="javascript:addsmilie(' :P ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/razz.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :oops: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/redface.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :roll: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/rolleyes.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :( ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/sad.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :) ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/smile.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :o ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/surprised.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :twisted: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/twisted.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :wink: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/wink.gif';?>" border="0"  /></a>
</center></div>
<input name="name" type="hidden" value="<?php echo $_SESSION['user'];?>" /><br />
    <input name="addcomment" type="submit" value="Add Comment" style="border: 1px solid #000; margin-top: 2px;" />
    </form></div>

Hi, I am trying to make a search based on information about a user in the database. Here is my code so far, notice any words like "and" or "the" in a multiword entry would mess it up. Any advice greatly appreciated. Ideally I would like a list of the matches by user name, and put the word "match" next to the matching data, because I used the OR statement it is going to bring back all of the user's info if one of the criteria matches. Any tutorials on the subject or keywords for google would be greatly appreciated. thanks.

here is the search code.

Code: [Select]
<?php 
ini_set ("display_errors", "1");
error_reporting(E_ALL);

$host = " ;
$database  = " ";
$username  = " ";
$password  = " ";
$tbl_name   = "users";


$conn = mysql_connect($host, $username, $password) or die("Could not connect: " . mysql_error());

if($conn)
{
mysql_select_db($database);
echo "connected to database!!";
 } else {
  echo "failed to select database";
}




//include('bouncer.php');


 
 
//$currentUser = $_SESSION['myusername'];
 
if(isset($_POST['submit'])) 

{  


 
$dob = mysql_real_escape_string( $_POST['dob']);
$gender = mysql_real_escape_string( $_POST['gender']);
$ethnic = mysql_real_escape_string( $_POST['ethnic']);
 
  //THE SEARCH FUNCTION
$sql = mysql_query ( "SELECT * FROM users WHERE dob  LIKE '%$dob%' 
OR gender LIKE '%$gender%'
OR race  LIKE  '%$ethnic%' 
OR dob  LIKE '%$dob%' 
 ") or die(mysql_error());  
 
  

$result = mysql_query($sql) or die( "<br>Query: $sql<br>Failed with error: " . mysql_error() );

if (!$result) {
    echo "Could not successfully run query ($sql) from DB: " . mysql_error();
    exit;
}

if (mysql_num_rows($result) == 0) {
    echo "No rows found, nothing to print so am exiting";
    exit;
}

// While a row of data exists, put that row in $row as an associative array
// Note: If you're expecting just one row, no need to use a loop
// Note: If you put extract($row); inside the following loop, you'll
//       then create $userid, $fullname, and $userstatus
while ($row = mysql_fetch_assoc($result)) {
    echo $row["dob"];
    echo $row["gender"];
    echo $row["race"];
}



 

 }//if(isset($_POST['submit']))
?>
<html>
<body>
<p>Login Successful</p>
<p>&nbsp;</p>

<form action="login_success7.php" method="post">
  <p>
 
 
    <input name="dob" type="text" size="20" id="dob" />
    Date of Birth<br />
    <input type="text" name="gender" size="20" id="gender" />
  Gender <br />
  <input type="text" name="ethnic" size="20" id="ethnic" />
  Ethnicity
  <br />
 
    <input type="submit" name="submit" value=" search" />
    <input type="reset" value="Reset fields" />
  </p>
</form> 


 

 
 
 
</body>
</html>

Hi,

Im trying to make pages switch.
Read data from database and but every 10 data in 1 pages.
I got my way on making pages by using PHP, but my way is not efficient.
 
Please teach me and tell me the correct way or concept to do it.
Or is there any website teaching this?

Appreciate for the help thanks.

Ok here are my 3 php pages:

set.php

<?php
$Month = 2592000 + time(); 
$value = '1';
setcookie("cs_hpage", $value, $Month);
?>


get.php

<?php
  if (isset($_COOKIE["cs_hpage"])) {
    $cookie = $_COOKIE["cs_hpage"];
    print("Received a cookie: ".$cookie."\n");
  } else {
    print("Fail!.\n");
  }
?>


clear.php

<?php 
setcookie ("cs_hpage", "", time()-60000); 
?> 


It all works like charm but i dont know how to set
if $cookie == 1
echo "Cookie here!"
and if other then 1
echo "Fail!"

All i managed to do is as you can see to echo the cookie :/

And question no.2:
How can i set a cookie through a button?? (Like when pressed set cookie to value "1")

Thanks..

Let's try something simple:

I have a form that retrieves data from database and organizes the numbers inside of a table (sometimes in an input box).

Is there a simple code so that VALUES > zero will be in BOLD font?

Hi there,   Can somebody please help me with the writing of a code for the following text?   4

I am having a dilemma.  I am working on a script for a client.  It is a match making system.  It takes all the teams, minimum of 20 teams. 10 matches a season.  No team can play the same team in the season.  Here is my code I have so far.  If it does not make sense ask me, I will try to explain more in depth.

<?php
error_reporting(E_ALL);
include("security/config.php");

//create season for testing purposes
$sql_season = "insert into season (`season`) values ('1')";
$conn->query($sql_season) or die($conn->error);

$season = 1; //testing purpose
echo "Season 1:<br />"; //testing purpose

//get number of teams
$sql_teams = "select * from teams";
$rs = $conn->query($sql_teams) or die($conn->error);
$num_of_teams = $rs->num_rows;
echo "&nbsp;&nbsp;Number of teams this season: {$num_of_teams}<br />"; //testing purpose
//put all teams in array
$teams = array();
while($ts = $rs->fetch_array(MYSQLI_ASSOC)){
	$teams[] = $ts;
}


if($num_of_teams % 2 != 0){
	$teams[] = array('name' => 'bye week', 'id' => 0);
	$sql_dummy = "insert into teams (`name`) values ('bye week')";
	$conn->query($sql_dummy);
}

//how many matches
$weeks = 10;
$matches = 10;
echo "&nbsp;&nbsp;This Seaon will be {$weeks} consisting of {$matches} matches<br /><br />"; //testing purpose
for($i = 0; $i < $weeks; $i++){
	//mix up teams
	$teams1 = $teams;
	$teams2 = $teams;
	shuffle($teams1);
	shuffle($teams2);
	
	$week = $i + 1;
	
	//$sql_week = "insert into weeks (`number`, `season_id`) values ('{$week}', '{$season}')";
	//$conn->query($sql_week) or die($conn->error);
	//$weekID = $conn->insert_id;
	echo "&nbsp;&nbsp;&nbsp;&nbsp;Week {$week} Created:<br />";
	
	//$matchup = array();

	for($x = 0; $x < $matches; $x++){
		shuffle($teams1);
		shuffle($teams2);
		$team_1 = array_pop($teams1);
		$team_2 = array_pop($teams2);

		$rs = false;

		$rs = ($team_1['id'] == $team_2['id'] ? true : false);
		$sql_search = "select * from matches where season_id = '{$season}' "
		$sql_search .= "and team_1 = ('{$team_1['id']}' or '{$team_2['id']}') ";
		$sql_search .= "and team_2 = ('{$team_1['id']}' or '{$team_2['id']}')";
		$rss = $conn->query($sql_search) or die($conn->error);
		if(!$rs || !$rss){
			
			$sql_create = "insert into matches (`team_1`, `team_2`, `week`, `season_id`) values ('{$team_1['id']}', '{$team_2['id']}', '{$week}', '{$season}')";
			$rs = $conn->query($sql_create);
			if($rs){
				echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"; //testing purpose
				echo "{$team_1['name']} vs {$team_2['name']}<br />"; //testing purpose
			}
			else{
				echo 'error: ' . $conn->error . '<br />'; //testing purpose
			}
		}
		else{
			$teams1[] = $team_1;
			$teams2[] = $team_2;
			$x--;
		}
		
		
	}
}
 

 cud any1 tell me why this happens?
when i run SOME of the php script using localhost, it says APACHE HTTP SERVER STOP WORKING

Hi guys! new to forum and to coding. I have poured over the forums and lots of places for an answer. I am not sure if this is due to my thus far limited understanding or, nto a specific enough question was asked. Basically it was suggested to me to make a link on a site from this:


Search our Catalog:



It was asked that I tie a link to that text and make it sort of a button so that when clicked, it takes someone to our catalog. The site is built with Drupal 6 and uses Danland theme and and a WYSIWYG. WHen I open the gear to edit this section I see:

"<P align=right><a href="https://catalog.ncpl.lib.oh.us/polaris/logon.aspx">
Access Library Account</a> -
<a href="https://catalog.ncpl.lib.oh.us/polaris/patronaccount/selfregister.aspx?">
Get a Card</a> -
<a href="http://catalog.ncpl.lib.oh.us/polaris/search/default.aspx">Search
Catalog</a></P>
<!-- // Start of Search form -->
<script language="javascript">
 
String.prototype.trim = function() { return this.replace(/^\s*|\s*$/g,''); }
 
function ProcessInput(e)
{
    if (window.event) // IE
        keyNum = e.keyCode;
    else if (e.which) // Netscape/Firefox/Opera
        keyNum = e.which;
 
 if (keyNum == 13)
 {
     e.returnValue = false;
     e.cancelBubble = true;
     DoKeywordSearch('KW');
     return false;
 }
 
 return true;
}
 
function DoKeywordSearch()
{
    if (document.getElementById('textboxTerm').value.trim() != '')
    {
        var strURL = 'http://catalog.ncpl.lib.oh.us/polaris/search/searchresults.aspx?ctx=1.1033.0.0.1';
        var strWindex = document.getElementById('Windex').value;
        var strTerm = escape(document.getElementById('textboxTerm').value);
        window.location = strURL + "&type=Keyword&limit=TOM=*&sort=PD_TI&Page=0&by=" + strWindex + "&term=" + strTerm;
    }
    else
    {
        alert('Please enter a search term');
        document.getElementById('textboxTerm').focus();
    }
}
 
</script>
<noscript>JavaScript must be enabled for catalog!</noscript>
<table border="0">
    <tr>
        <td>
            <label for="search">Search our Catalog:</label>
            <input class="search" type=text id=textboxTerm size=30 onkeypress="return ProcessInput(event)" />
            <select class="search" id="Windex">
              <option value="KW" selected="selected">
                Anywhere
              </option>
              <option value="SU">
                Subject
              </option>
              <option value="TI">
                Title
              </option>
              <option value="AU">
                Author
              </option>
              <option value="KW&fic=1">
                Fiction
              </option>
              <option value="KW&fic=0">
                Nonfiction
              </option>
            </select>
            <input type="submit" class="button" value="Go!" name="submit" onclick="DoKeywordSearch()" />
        </td>
    </tr>
</table>
 <!--// End of Search form  -->"

My question is where would the code for the link go and is there a good resource i can use to figure out how to write it? Any help is greatly appreciated, thank you.

Hey i'm just wanting to make a loop to loop members i do have a loop but im looking for a more better loop
i need to loop my members in a table as

spot: 1  spot: 2 spot: 3 spot 4
and if there more it puts in below the top for spots and so on


$Members = mysql_query("SELECT * FROM users") or die(mysql_error());

$numRowsMembers = mysql_num_rows($Members);
?>

<?php
     for($count = 1; $count <= $numRowsMembers; $count++)
         {

    $name = mysql_fetch_array($Members);

?>

<td width="150" height="125">
<a href="view_profile.php?username=<? echo $name['Username']?>"><img src="<? echo $name['main_P']?>" width="100" height="100"/>
<? echo $name['Username']?></a>

<? } ?>

This will be my worst-ever question posted on this forum 😀

But here goes....

I have a mySQL script which retrieves data.... then my PHP script creates a text document out of it, and ends with:

$output = ob_get_contents();
ob_end_clean();
file_put_contents("document.txt", $output);

The resultant thousand-item list will have some of the items duplicated, with one or more numerals appended, like this:

banana 1
apple 1
apple 1 and 2
lemon 1
blueberry 1
strawberry 1
strawberry 1 and 2
strawberry 1 and 2 and 3
melon 1

When an item is duplicated and suffixed with more than one numeral, I want only the latest duplicated item, like this:

banana
apple 1 and 2
lemon 1
blueberry 1
strawberry 1 and 2 and 3
melon 1

Is there a way to make "file_put_contents" go like "oh, an item was listed more than once, let's only list the latest ("modified") item"?

 

 

Hi all, i have no idea where to start with this.. I do however have some code i am assured will pull the data.. What i need to know is can and will you help me.. I understand if not.. Just rather ask before i jump in.

Jamie

I would be needing different picture sizes on different pages on my site but saving different sizes of a single pic is space consuming.

I've heard that it's possible to automatically adjust the size of the picture and found a script that ought to make that possible. Unfortunately, it did not work for me.

Article: PHP Thumbnail Script Using GD http://www.rainbodesign.com/pub/thumbnails/

Here's the code:
Code: [Select]
<?
// Rainbo Design PHP Thumbnail Maker
// Copyright (C) 2005-2010 by Richard L. Trethewey - rick@rainbo.net
// All Rights Reserved
// If you use this script, I'd appreciate a link!
// http://www.rainbodesign.com/pub/

// Defaults
$thumbsize = 150; // Default thumbnail width.
$imagesource = 'images/default_img.jpg'; // Default image file name.
// Set to empty string for no image output on failure.
$error = '';

if (isset($_GET['width'])) { $thumbsize = $_GET['width']; }
if (isset($_GET['src'])) { $imagesource = $_GET['src']; }

$filetype = substr($imagesource,strlen($imagesource)-4,4);
$filetype = strtolower($filetype);

if (file_exists($imagesource)) {

if($filetype == ".gif") $image = @imagecreatefromgif($imagesource);
if($filetype == ".jpg") $image = @imagecreatefromjpeg($imagesource);
if($filetype == ".png") $image = @imagecreatefrompng($imagesource);

$imagewidth = imagesx($image);
$imageheight = imagesy($image);

if ($imagewidth >= $thumbsize) {
$thumbwidth = $thumbsize;
$factor = $thumbsize / $imagewidth;
$thumbheight = floor($imageheight * $factor);
} else {
$thumbwidth = $imagewidth;
$thumbheight = $imageheight;
$factor = 1;
}

// Create a thumbnail-sized GD Image object
$thumb = @imagecreatetruecolor($thumbwidth,$thumbheight);

// bool imagecopyresized ( resource dst_image, resource src_image, int dst_x, int dst_y, int src_x, int src_y, int dst_w, int dst_h, int src_w, int src_h )
imagecopyresized($thumb, $image, 0, 0, 0, 0, $thumbwidth, $thumbheight, $imagewidth, $imageheight);

// Send output to user as a jpeg type, regardless of original type
header("Content-type:image/jpeg;");
imagejpeg($thumb);
imagedestroy($image);
imagedestroy($thumb);
} else {
$error = "File $imagesource Not Found";
} // endif file_exists

if ($error != '') {
header('Content-type:text/plain;');
echo($error);
exit;
} // endif $error

?>

And here's a little instruction (which I have followed as well).
Quote

All it takes is replacing the "src" parameter in the <img> tag with the URL for the PHP script, including the parameters "src" which contains the path to the original image file, and "color" to select the color for the font. The script also supports a "width" parameter to specify the width of your thumbnail image. Using that script to display the above image as a thumbnail by setting the "src" attribute to "makeThumb.php?src=slides/slide1.jpg", we get the resulting image shown on the right.



Can anyone please help me with this script or something similar?

Thanks in advance. ^_^

Edit: The problem is that the image is not showing. It appears as if it cannot locate the file source.