PHP - Double Left Arrow

Hey guys i need to generate a table for a multilevel marketing simulation of 10.000 members. It's a bi-level.

All i need is a table with id, parrent

I am lost with the double loop ...

sorry, I posted twice.

please help me with this.since i started posting this form to its self it has been inserting values twice into the database when the user clicks submit button and i also noticed that i have to refresh the page before inserted comments can be showed.this is my code: Code: [Select]
<?php
                                 include"header.php";
                                  $sql="SELECT post_content,post_by FROM post WHERE topicsID='$tpid'";
                            $result=mysql_query($sql)or die(mysql_error());
                                while($row=mysql_fetch_array($result))
                             {

                               echo"<strong>{$row['post_by']}</strong>:  {$row['post_content']}"."</br>";
                             }
                                         ?></td>

</tr>
</table>
<?php
include"header.php";
if(isset($_POST['submit']))
{
$comment=mysql_real_escape_string(trim($_POST['comment']));
$name=mysql_real_escape_string(trim($_POST['name']));
$hidden=$_POST['id'];
if($comment!=='' && $name!=='')
{
$topicid=$_GET['id'];
$ins="INSERT INTO post(post_content,post_by,post_id)VALUES('$comment','$name','$topicid')";
mysql_query($ins) or die(mysql_error());
}
else
{
echo"you cannot post an empty field";
}
}


?>
<h3>Post your comments here</h3>
<form action=''method='post'>
<textarea name="comment" id="content" style="width:400px;height:50px;background-color:#D0F18F;color:#000000;font:15px/20px cursive;scrollbar-base-color:#638E0D;"></textarea>
<br />
Name:<input type="text"name="name"/>
<input class="button" type="submit"name="submit"value="submit" />

</p>
</form>

if u use this for one condition

if ($nr > 5)

how would u check if the nr is between 5 and 50

thanks !

I have search the net and at the end  tried 2 things that didn't solved the problem. It is known that certain browsers can refresh th epage 2 times without us knowing bacause it's doing it all by himself and so fast we don't even see it blink !

So I have following code for the normal sql-insert :
Code: [Select]
$Opdracht = "INSERT INTO tbl_link(userid,linkcat,linksubid,linklang,linkactive,linktitle) VALUES('$userid',1,0,'$lang',1,'$newML')";

it was inserted 2 times...

I did some session check :  at the top of the page :
Code: [Select]
session_start();
 
if(isset($_SESSION['itel'])){
    $_SESSION['itel'] = $_SESSION['itel']+ 1;
}
else {
    $_SESSION['itel'] = 1;
}
echo "<br>session: ". $_SESSION['itel'];

And it gave me number 2 !   This means the page was loaded 2 times, thus inserted 2 times.  !

Than I tried :
Code: [Select]
$Opdracht = "INSERT INTO tbl_link(userid,linkcat,linksubid,linklang,linkactive,linktitle)
VALUES('$userid',1,0,'$lang',1,'$newML')
ON DUPLICATE KEY UPDATE linkid=LAST_INSERT_ID(linkid), linktitle='$linktitle'";

I got no error back but again  2 rows were created instead of 1...

These are the fields in the table tbl_link :     linkid    userid    linkcat    linksubid    linksuborder    linklang    linkactive    linktitle    articleid
Unfortunately certain fields may be double in multiple rows, the only unique key is "linkid" and that's AUTO_INCREMENT.

The only thing I can use is that userid and linktitle may NOT be reproduced 2 times (inserted) !!!

Hi,

I have written some code however when I echo the query it runs it twice...

Quote

SELECT `description`, `fulldescription` FROM `productdbase` WHERE `keywords` LIKE '%table%'something found.SELECT `description`, `fulldescription` FROM `productdbase` WHERE `keywords` LIKE '%table%'something found.


I only have the query once in my code. Any suggesions?

Code: [Select]
<?php
if (isset($_POST['keywords'])){
 $keywords = mysql_real_escape_string (htmlentities(trim($_POST['keywords'])));
}

$errors = array();

if (empty($keywords)) {
$errors[] = 'Please enter a search term';
} else if (strlen($keywords)<3) {
$errors[] = 'Your search must be three or more characters';
} else if (search_results($keywords) === false) {
$errors[] = 'Your search for '.$keywords.' returned no results';
}

if (empty($errors)) {

search_results ($keywords);

} else{
foreach($errors as $error) {
echo $error, '</br>';
}
}


    ?>


<?php
function search_results ($keywords) {
$returned_results = array();
$where = "";

$keywords = preg_split('/[\s]+/', $keywords);
$total_keywords = count($keywords);

foreach($keywords as $key=>$keyword) {
$where .= "`keywords` LIKE '%$keyword%'";
if ($key != ($total_keywords - 1)) {
$where .= " AND ";

}
}

$query_string = "SELECT `description`, `fulldescription`  FROM `productdbase` WHERE $where";
echo $query_string;
$query = mysql_query($query_string);



if ($results_num === 0) {
return false;
}else{
echo 'something found.';
}




}
?>

I am wondering since in php when you write string in " " quotes php will look if there is any variable and if it is it will read that variable and replace variable name with that value inside the string. However when i use ' ' quotes php will not look for any variables inside that string. So my question is when you write a really big application is it good to always use ' '  quotes when you can instead of " " ones. Does that have an impact on performance. Thanks

Hi All,

I was wondering if someone maybe knows a nice way to prevent double posting or posting within a certain time without using javascript. Or maybe even echoing an error if someone posts the exact same ase the previous post.

I found this little snippet:
Code: [Select]
onClick="disabled=true;this.form.submit();return true;" Which prevents double clicking.
But its javascript and I rather have something besides that to cover all situations. Would love to hear what you guys use or reccomend.

Thanks!

Hi i am in a situation where i need to use two tables. please look at my code


$result= $db->dbrun('select * from table_user');
while($row = mysql_fetch_array($result)): 
echo $row['username'] . '<br />';
endwhile;

now my problem is i wants to get something from other table where user id match with $row['id'],


$result= $db->dbrun('select * from table_user');
while($row = mysql_fetch_array($result)): 
$query= $db->dbrun('select id from table_other where user_id =$row['id']');
while($user_row = mysql_fetch_array($query)): 
echo $row['username'] . ' - ' . $user_row['id'] . '<br />';
endwhile;
endwhile;


so my main question is is it ok to run $query within  a while loop because i cant run this query without $row['id'] which i gets after loop started or is there any other good way.

Thanks for answering.

Hello,

its a bit difficult to explain the issue that I have but I will try my best.

I have this small code $message = $_POST['message1'];  in my php code and message1 is the name of a textarea in my page.

i also have another textarea called message2 in my page.

what I need to do is to use the message1 and message2 in the $message = $_POST function.

For example: $message = $_POST['message1'] + $_POST['message2'] or anything that is acceptable in PHP coding and works in PHP.

I hope I havent confused you guys and you undersstood what I mean...

Thanks

Would you please help me to fix the problem of sending two emails instead of just one every time I run the following code using this url:
http://domain.org/image.php?path=dir/file.jpg

Code: [Select]
<?php
$email="email@domain.org";
$body = "the body";
$subject="the subject";
$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'From: Image Visit Receipt <rr@mrdv.org>' . "\r\n";

mail($email,$subject,$body,$headers);

if ($HTTP_GET_VARS["path"])
{
$imagepath="/home2/mydomain/public_html/files/images/".$HTTP_GET_VARS["path"];
if (file_exists($imagepath)) 
{
$image=imagecreatefromjpeg($imagepath);
header('Content-Type: image/jpeg');
imagejpeg($image);
exit;
}
}
?>

How do I apply double delete verification?

Right now I have...

Code: [Select]
if (isset($_POST['delete']))
{
if(is_array($_POST['delete'])) {
$keys = array_keys($_POST['delete']);
$id = $keys[0];

$sql = "DELETE FROM `blog_posts` WHERE `post_id` = '$id'";
header("Location: " . $_SERVER['php_self'] . "?" . $_SERVER['query_string'] );
}
}
if(isset($sql) && !empty($sql)) {
mysql_query($sql) or die(mysql_error());
}

which deletes the query great, but I want some box to pop up saying, are you sure you want to delete this post?

I'm not sure how to create this verification.

hi, i have a script that inserts a csv into mysql.  i run into errors when there is an empty field

example:

Code: [Select]
filed1,field2,field3,,field5,,field7
here is my code that processes it.

Code: [Select]
$handle = fopen("uploads/$filename", "r");

while(($data = fgetcsv($handle, 1000, ",")) !== FALSE)      {



$import .= "INSERT into goaliestats(id,name,gp,w,so,gaa,date) values(NULL,'$data[0]','$data[2]','$data[8]','$data[26]','$data[18]','$data[28]')" . "\n";

mysql_query($import) or die(mysql_error());
}


fclose($handle);

is there a way i can make a ,, into ,0,

?

thanks!

I have a problem which is why I am here. 

What I am trying to achieve

I am creating a very very basic timetabling system online, using php and sql. I am still in the process of completing it and changing bits from here to there. Although I am fully aware that the current design / implementation needs several changes and amendments, but however it performs most of the basic functionalities from a login system to the ability to add data delete data and also reset the database and recreate.


The problem

I have a table called tCourse althouogh a full ERD implementation has not taken place, it is still trial and error period.

The table consists of the following:

- Course
- Unit
- Course_Code
- Year (i.e. Yr1, Yr2, Yr3)
- Credits (Value of the unit)
- Day
- Semester
- Start_Time
- End_Time
- Room
- Tutor

At the moment the primary keys for the table a  

- Day
- Start_Time
- Room_   
- Semester

This basically prevents a particular day, a semester, a room having been booked at the same time. Which for a very basic one is ok. The only problem is though,

if someone books for example:

Monday >> 13:00:00 To 14:00:00 >> 205 >> Sem1 (ok)
Monday >> 13:00:00 To 14:00:00 >> 205 >> Sem1 (Not ok, which is good, as it is a repeat and prevents double booking)

However the problem comes he


Monday >> 12:00:00 To 14:00:00 >> 205 >> Sem1 (ok)
So this is allowing a booking even though that room will be busy i.e. booked between 13:00 to 14:00

So is there a way I can limit it, so if there is a room booked for that particular period it will not do it.

I have done a bit of research and friend's have suggested doind several for loops and quering the database beforehand. I came here, mainly because there are a lot of experienced individuals here whom may have a simpler solution, although I can understand it won't be a one liner .

I would appreciate any help, if not, it is still ok.

I'm designing a website that takes user input from in a <textarea></textarea> and enters the input into a database. Everything works besides if the user has double quotes (") in his/her message. (the name of the table that I want to add to is alluserposts)

What i have so far is the following:
from index.php:
<form action="insert2.php" method="post"><textarea name="user_post" rows="6" cols="35"></textarea></form>

from insert2.php:
mysql_query("INSERT INTO alluserposts (post_value) VALUES(" . "\"" . $_POST['user_post'] . "\")" ,$db) or die(mysql_error($db));

I want the user to be able to input any character. How can i do that?