PHP - Help Debuging Limit

hello,

I have a form i am using for a raffle that i have weekly. the problem is i want to limit how many times they can register.  I am using a basic form that collects name, email, and IP ( which is hidden ). When it gets submitted there is time stamp as well using this

date("m/d/y : H:i:s", time()


I would like to restict registering by one hour at a time. can you please give me some help with this. I have thought of maybe using cookies, but some of my smarter members can bypass that. So i think i will either use email or IP .

any help would be very appreciated

I am in need of a alimit on the explode() fucntion but reading through the php explode manual on php.net there doesn't seem to be one that is right for me.

Basically I'm making a command system for a php chat and it has a command called ban.
I have code that find out if it is a command or a normal string, I also have code that starts to break up the command into segments that can be places in the database.

I want to split up "ban user lengthID "Reason why you were banned"" using explode($string, " ") but I notice that that will also break up the "reason why you are banned".

How do I get it to split up the command but NOT thereason why you were banned string?

Confusing I know, Please ask any questions that would help me explain it better Thanks in advance!

Hi,

This line of code works just fine for me:
$sql_quest = 'SELECT id, username FROM user ORDER BY id ASC LIMIT 0, 30';

I want to be able to set the integer values dynamically and I thought something like this would work:
$sql_quest = 'SELECT id, username FROM user ORDER BY id ASC LIMIT' . $my_int_value . ',' . $my_int_value + 30;

But it doesn't... Any ideas?

Hi there, im really stuck here. I have a table of records that are selected from my db and put into an array and randomly chooses them, outputting the results .

Code: [Select]
<?php 
$count = 0;
while ($row = mysql_fetch_assoc($Ships4)){
$array[$count]['ShipID'] = $row['ShipID'];
$array[$count]['ShipName'] = $row['ShipName'];
$array[$count]['Dclass'] = $row['Dclass'];
$count++;

$total4 = count($array);
$random4 = rand(0,$total4 - 1);
$random_ship4 = $array[$random4];
$ShipID4 = $random_ship4['ShipID'];
echo $ShipID4;}
This all works fine, however I want to limit the number of random outputs from a number in a record in a different table.

So i added:
Code: [Select]
<?php
if ($count < $row_dclasscorella['Dclass4_totla']){ ?>
the number from the field is 2.

The trouble is that it doesnt take any notice and outputs the total number a random number for each record. It seems its not limiting it. How can i get this to work please???

Code: [Select]
$count = 0;
if ($count < $row_dclasscorella['Dclass4_totla']){
while ($row = mysql_fetch_assoc($Ships4)){
$array[$count]['ShipID'] = $row['ShipID'];
$array[$count]['ShipName'] = $row['ShipName'];
$array[$count]['Dclass'] = $row['Dclass'];
$count++;

$total4 = count($array);
$random4 = rand(0,$total4 - 1);
$random_ship4 = $array[$random4];
$ShipID4 = $random_ship4['ShipID'];
echo $ShipID4;}}?>
Thank You

Hi,

I'm fairly new to all of this and I'm not quite sure what to do. I'm trying to create a field in my database that's 4 hours and 10 minutes into the future from the current time. What data type do I set my field as in the mysql database? How would I populate that mysql field via php.. would I use something like NOW(), or use the php date() function? Also, how would I be able to tell if my field has "expired" (the 4 hours and 10 minutes has elapsed)?

Hi guys I have a problem. I limit the displayed rows by 10 (which works) and then a link saying "next" or "previous"
The link itself works, but the site always just displays teh first 10 data entries.
What do I do wrong?
Thank you!

Code: [Select]
<?php
$host="****"; // Host name
$username="****"; // Mysql username
$password="****"; // Mysql password
$db_name="****"; // Database name
$tbl_name="sp_users"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

//$sql="SELECT * FROM $tbl_name ORDER BY user_id";
$sql="SELECT * from sp_users,sp_schools where sp_users.user_id=sp_schools.school_id ORDER BY school_name LIMIT 0, 10";
$result=mysql_query($sql);
$num_rows=mysql_num_rows($result);
?>
<?PHP
//check if the starting row variable was passed in the URL or not
if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) {
  //we give the value of the starting row to 0 because nothing was found in URL
  $startrow = 0;
//otherwise we take the value from the URL
} else {
  $startrow = (int)$_GET['startrow'];
}
?>
<?PHP
//this part goes after the checking of the $_GET var
$fetch = mysql_query("SELECT * FROM sp_users,sp_schools where sp_users.user_id=sp_schools.school_id LIMIT $startrow, 10")or
die(mysql_error());
?>
<style type="text/css">
<!--
.style2 {font-weight: bold}
.style3 {
font-family: Arial, Helvetica, sans-serif;
color: #000000;
}
.style10 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #000000; }
#Layer1 {
position:absolute;
left:803px;
top:36px;
width:65px;
height:28px;
z-index:1;
}
#Layer2 {
position:absolute;
left:707px;
top:19px;
width:143px;
height:39px;
z-index:1;
}
#Layer3 {
position:absolute;
left:247px;
top:463px;
width:175px;
height:53px;
z-index:2;
}
-->
</style>

<title>User overview</title>
</html>
<div id="Layer2">
  <form action="<?= $_SERVER['PHP_SELF'] ?>" method="post">
<input type="hidden" name="foo" value="<?= $foo ?>" />
<input type="submit" name="submit" value="Refresh" />
</form></div>
<div id="Layer3"><?PHP
//now this is the link..
echo '<a href="'.$_SERVER['PHP_SELF'].'?startrow='.($startrow+10).'">Next</a>';
?>
<?PHP
$prev = $startrow - 10;

//only print a "Previous" link if a "Next" was clicked
if ($prev >= 0)
    echo '<a href="'.$_SERVER['PHP_SELF'].'?startrow='.$prev.'">Previous</a>';
?></div>
<table width="779" border="0" align="left" cellpadding="0" cellspacing="1" bgcolor="#996600">
<tr>
<td width="777">
 
    <div align="left">
      <table width="779" border="1" cellspacing="0" cellpadding="3">
        <tr>
          <td colspan="6" align="center"><div align="center" class="style1 style3"><strong>SchoolPorta.com Users / Total: <?php echo $num_rows ?></strong></div></td>
          </tr>
        <tr>
          <td width="342" align="center"><span class="style2">school</span></td>
          <td width="62" align="center"><span class="style2">Name</span></td>
          <td width="104" align="center"><span class="style2">Lastname</span></td>
          <td width="130" align="center"><span class="style2">Email</span></td>
      <td width="64" align="center"><span class="style2">Update</span></td>
        </tr>
        <?php
while($rows=mysql_fetch_array($result)){
?>
        <tr>
          <td><span class="style10"><? echo $rows['school_name']; ?></span></td>
  <td><span class="style10"><? echo $rows['user_first_name']; ?></span></td>
          <td><span class="style10"><? echo $rows['user_surname']; ?></span></td>
          <td><span class="style10"><a href="mailto:<?php echo $rows['user_login']; ?>"><?php echo $rows['user_login']; ?></a></span></td>
          <td align="center"><a href="update.php?id=<? echo $rows['user_id']; ?>" class="style10">update</a></td>
        </tr>
        <?php
}
?>
      </table>
    </div></td>
</tr>
</table>

<div align="left">
  <p>&nbsp;   </p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>
    <?php
mysql_close();
?>
  </p>
</div>

Im wondering if someone can shed some light on possibly the best way to do this.
I currently have a website which recieves 26000-37000 visits a month. The host got on my case about to many MySql connections and with help from someone here decided a cache system was best. the cache system is now in place and only updates if the cached file is older than 5 days. I am still recieving high connections to my database and wonder if it is spam as i have a search box. the search box once filled in redirects to a page which queries the database for the keyword and displays results and because it was just selecting and not inserting into database i didnt go for the captcha. this is why i suspect spam, I have thought about limiting the amount of search queries per time limit by ip but I am unsure of how to tackle this and if it will help against spam bots?

a google search has only found an answer which stores every visitors ip in a database and keeps count there which I cant see the benefit as it is creating more work for the DB. I have thought maybe creating a session variable that increments with every search and when searching checks this value but I am not to sure if this would help as it would be down to cookie settings.

can anyone shed some light on a possible solution to this.

I am not expecting you to write this for me but for now just to help with the best way to tackle the problem.

Thank you for your time.

Is there a limit to how many items can be stored in an array?

My code looks in a directory of photos and writes the file names into the one-dimensional array.

I just switched from my test folder to my actual photo folder - about 600 photos - and when I ran my script with var_dump enabled, my array only goes up to 128 items (0-127).

I sure hope arrays aren't that wimpy?!

Each photo is about 1-2MB in size, but since I am only storing the file name, I would expect that I could easily store thousands of elements in this array.

What is going on?

 

hello, is there a wat to limit the following to only the first 25 characters?

$customername=$row1["customer"];

thanks

Hey quick question on my homepage there is a featured content section, which is populated from my DB some of the posts are really long so I would like to limit the amount of text. how can I do this?  also is there a way to make sure if does not cut a word in half?

thanks

Hi,

I've been passed the below code which converts rss to php and then displays HTML. It works well.
However, I've 2 issues with it:
1) I'd like to set it so only say 5 posts are shown
2) How can I truncate the description, so it only shows say 100 chars or 20 words?

Any help is much appreciated.

Here's the code:

<?php

// DO NOT EDIT BELOW THIS LINE

date_default_timezone_set("GMT");

$itemArray = array();

if($text = preg_replace("/[\t\r\n]/", " ", htmlentities(@file_get_contents($rss_feed_url), ENT_QUOTES)))
{
while(strpos($text, "&acirc;") == true)
{
$text = substr($text, 0, strpos($text, "&acirc;")) ."'". substr($text, strpos($text, "&acirc;")+9, strlen($text));
}

$items = explode("<item>", html_entity_decode($text));

foreach($items as $item)
{
$title = "";
$link = "";
$desc = "";
$pubdate = "";
$image = "";

$item = html_entity_decode($item, ENT_QUOTES);
$item = preg_replace('/&(?!amp;|quot;|nbsp;|gt;|lt;|laquo;|raquo;|copy;|reg;|bul;|rsquo;|mdash;|#)/', '&amp;', $item); 
$item = str_replace("<![CDATA[","", $item);
$item = str_replace("]]>","", $item);

if(stripos($item, "</item>") == true)
{
if(preg_match('|<title>(.*)</title>|', $item, $match))
{
$title = $match[1];
}

if(preg_match('|<pubDate>(.*)</pubDate>|', $item, $match))
{
$pubdate = strtotime($match[1]);
}

if(preg_match('|url="(.*)|', $item, $match))
{
$search = $match[1];
$imageArray = explode('"', $search);
$image = $imageArray[0];
}

if(preg_match('|<description>(.*)</description>|', $item, $match))
{
$desc = $match[1];
$desc = strip_tags($desc);
}

if(preg_match('|<link>(.*)</link>|', $item, $match))
{
$link = $match[1];
$link = end(explode("*", $link));
}

if($title && $link && $desc)
{
array_push($itemArray, "$pubdate|$title|$link|$desc|$image|");
}
}
}
}
else
{
print "<p>Whoops! We could not connect to: <a href=\"$rss_feed_url\">$rss_feed_url</a></p>";
}

if(sort($itemArray))
{
foreach(array_reverse($itemArray) as $iA)
{
list($pubdate,$title,$link,$desc,$image) = explode("|", $iA);

$timenow = time();

$difference = $timenow-$pubdate;

$days = 0;
$hours = 0;
$minutes = 0;

print "<p>";

if($hotlink_images && $image)
{
if($open_links_in_new_window)
{
print "<a class=\"thumb\" href=\"$link\" onclick=\"openInNewWindow('$link'); return false\">" .
  "<img src=\"$image\" alt=\"$title\"></a>";
}
else
{
print "<a class=\"thumb\" href=\"$link\"><img src=\"$image\" alt=\"$title\"></a>";
}
}

if($open_links_in_new_window)
{
print "<a href=\"$link\" onclick=\"openInNewWindow('$link'); return false\">$title</a><br>";
}
else
{
print "<a href=\"$link\">$title</a><br>";
}

if($pubdate)
{
print "<span class=\"sub\">Posted ";

if(sprintf("%01.0d", $difference/(60*60*24)))
{
$days = sprintf("%01.0d", $difference/(60*60*24));
$difference -= $days*(60*60*24);

if($days > 1)
{
print "$days days ";
}
else
{
print "$days day ";
}
}

if(!(sprintf("%01.0d", $difference/(60*60*24))) && sprintf("%01.0d", $difference/(60*60)))
{
$hours = sprintf("%01.0d", $difference/(60*60));
$difference -= $hours*(60*60);

if($hours > 1)
{
print "$hours hours ";
}
else
{
print "$hours hour ";
}
}

if(!(sprintf("%01.0d", $difference/(60*60*24))) && sprintf("%01.0d", $difference/60))
{
$minutes = sprintf("%01.0d", $difference/60);

if($minutes > 1)
{
print "$minutes minutes ";
}
else
{
print "$minutes minute ";
}
}

print "ago</span><br>";
}

print "$desc</p>\n<div class=\"hr\">&nbsp;</div>\n";
}
}

?>

Thanks again

can we limit the image by its resolutin while uploading?

i want only 130 by 110 pixel image,or i want to convert uploaded image to 130 by110 size..

can i?

lyk by using $_FILES array..?

Hi there i wanted to know how i could rule out certain rows from being shown in the pagination in this case i want to approve all information before it's posted i tried

$sql = "SELECT * FROM tablename LIMIT $offset, $rowsperpage WHERE approved = 'Yes'";

But it didnt work

Any help would be great,

Thanks,

Blink359

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=342142.0