DaniWeb IT Discussion Community - PHP

One DB record from two HTML forms

levsha — Fri, 20 Nov 2009 21:52:18 GMT

I have two HTML pages, each has a form.
The user is supposed to fill out the input fields in one, then click a submit button that will send him to the next page, where he would fill out the rest of the fields of his questionaire, click a submit button.
After that I need all the input data collected from both pages (forms) to be inserted into one record in the database.
How would I achieve that?

Thanks a million in advance!

lamp

coolbuddy059 — Fri, 20 Nov 2009 20:21:55 GMT

hi friends,
I've come across a word LAMP while searching for some php codes.Can someone kindly tell what does this mean and what type of application can be developed from it. And how to begin learning it(sources which provide complete information).

2 dimensional array issue

loligator — Fri, 20 Nov 2009 20:07:24 GMT

So here's the code:

function procRestSearch($searchQuery){ 

                //Don't forget to have $searchquery defined before calling this function

                $intSearchCounter = 0; //Used to set the arrays

                $searchResult = mysql_query($searchQuery);

                while($searchRow = mysql_fetch_array($searchResult, MYSQL_ASSOC)){

                        //Change/Add/Delete the variables below to match what data needs to be returned

                        $strRest = array($intSearchCounter => array('restID' => $searchRow['rest_id'], 

                                'restName' => $searchRow['rest_name'], 'restAddress' => $searchRow['rest_address'], 

                                'restAddress2' => $searchRow['rest_address2'], 'restCity' => $searchRow['rest_city'], 

                                'restState' => $searchRow['rest_state'], 'restZip' => $searchRow['rest_zip'], 

                                'restCC' => $searchRow['rest_country_code'], 'restAC' => $searchRow['rest_area_code'], 

                                'restPhone' => $searchRow['rest_phone_no'], 'restFAC' => $searchRow['rest_fax_no'], 

                                'restManager' => $searchRow['rest_manager'], 'restAsManager' => $searchRow['rest_assistant_manager'], 

                                'restWebsite' => $searchRow['rest_website']));

                        

                        $intSearchCounter++;

                }

                return $strRest;

        }

the problem is when I call this function I get a Notice: Undefined offset: 0 in... error. However, if I replace $intSearchCounter with a static value, such as just replacing it with 0, it works but then I only get the last result from the query returned. What am I doing wrong?

I a php script that can restrict a user from adding additional image to his account o

dannybarh — Fri, 20 Nov 2009 18:05:38 GMT

Hi to All.
1. I want a php script that can restrict a user from adding additional image to his account on my site, I the admin should be able to set the restricting for the user. I also want to be able to activate/deactivate this function in the admin section
2. I want users to be able to add things they browse to “add to my list” , just like adding things to a shopping cart.

Thank You.

php on same page as form

mrjoli021 — Fri, 20 Nov 2009 16:21:45 GMT

I have an html form when i submit it it goes to a php page. i want to change the action so the php execution happens on the same page.





















EMail: 


First Name: 


Last Name: 


Password:











        //conection

        include('sqlconn.php');

        $mysql = new sqlConnection;

        

        //retrive data from POST form

        $email=$_POST['email'];

        $fname=$_POST['fname'];

        $lname=$_POST['lname'];

        $password=$_POST['password'];

        

        //insert data into DB

        $query = "INSERT INTO  `client_Info`.`users` (`email` ,`fname` ,`lname` ,`password`)

                                VALUES (NULL , '$email', '$fname', '$lname', '$password')";                        

        mysql_query($query) or die('Error, insert query failed');

        $last_Id = mysql_insert_id();

        

        $mysql->close();

        

        //redirect back to login page.

        header( 'Location: http://localhost/testsite' ) ;

?>

php preg_match vs preg_replace

shishtawitch — Fri, 20 Nov 2009 14:51:47 GMT

i have following in my database
------------------------------------------------------------------------------------





Vicky Bhai Part 4
http://www.mysite.com
Stage Funny Stuff

------------------------------------------------------------------------------------
if want to add a anchor tag to only image before displaying it on page.................how can i do that with preg match or preg replace

.htaccess, some symbols causing problem

anishmsry — Fri, 20 Nov 2009 13:05:07 GMT

hi,
i'm using .htaccess so that the variables passed through links are not seen.

http://localhost/user/jack should be converted to http://localhost/user/?uid=jack

i used:
RewriteRule ^user/([^.]+)/?$ profile/?uname=$1 [NC,L]
whatever characters is input, i want that to be passed and then check.
everything's working perfect.
but when the following symbols are used, the errors such as these are appearing
Forbidden
You don't have permission to access /user/: on this server.

the symbols which are causing the problems are:
%,*,\,:,",<,>

what should i do to avoid this?

refresh

muralikalpana — Fri, 20 Nov 2009 10:25:37 GMT

hello..
i want to write code for refresh only division part which is in page. why because i am fetching images from database randomly. when we refresh the page the image change randomly.
so.....i want to do refresh only division part every 1min. how to do?

getting part of url with php

shishtawitch — Fri, 20 Nov 2009 10:05:56 GMT

how can i get only value of 'v' from the following url
http://www.youtube.com/watch?v=NMAYr709-9Y&feature=dir
i.e NMAYr709-9Y
with php

fetching youtube embed code.......with php

shishtawitch — Fri, 20 Nov 2009 09:12:26 GMT

i want to pass a youtube code like
http://www.youtube.com/watch?v=NMAYr709-9Y&feature=dir
and it return me the embed code.........!! how can i do that with php and curl........!!

How to display random html pages using php

ym_chaitu — Fri, 20 Nov 2009 08:59:12 GMT

Hai
I have some html files and i would like to display them in a random manner using the php.
can any one help me out..I have been trying this one..
but it is not working..


$dir="./clock/";

$nimg="10";

$itype="html";

$rnumb=rand(1,$nimg);



echo "";

?>

Add a date in mysql using php

mundetas — Fri, 20 Nov 2009 08:11:10 GMT

Can someone please help:(. I have a database with a field Date. I made the datatype to Date. But when I code the date in php I use the date() function to get the current date it donesn't want to insert in the database. Please help.

For example my code.

$name = $_POST['name'];

$date = date("yyyy,mm,dd");



insert into tablename ('name','date') values ('{$name}','{$date}');

network timeout on updating large result in one query

sam023 — Fri, 20 Nov 2009 07:45:06 GMT

i m updating 3000 records in on query after few sec.. page shows network timeout...!! how to get rid of it..

thanks

curl vs xmlhttprequest

shishtawitch — Fri, 20 Nov 2009 07:36:09 GMT

hi,
how can i make a link attache ment system with php, culr / ajax
one like in facebook..........!!
i.e by typing a link fetching meta, title and images from that link...!!

thanks in advance.........!!

how to sms to mobile phones from my web site.

rajabhaskar525 — Fri, 20 Nov 2009 05:50:27 GMT

hi all, i want to send sms to mobile phones from web site . is there any solution for this ....... give me idea!!!!!!!!.......

Search query

ruwanaru — Fri, 20 Nov 2009 05:10:54 GMT

im new in php so please help me with full scripts

insertion of selected checkbox records in another table

ayesha789 — Fri, 20 Nov 2009 04:12:09 GMT

hi every body, i am sure its not that much hard but somehow i stuck in situation which look
very much unclear to me.

in fact i have a table through i am selecting different records

each records will be printed with the checkbox

what i want to insert checked fields in the database

following is the code which i am using for printing the each field with check box

   
   $con = mysql_connect("localhost","","");

   if(!$con)

     {

     die('Could not connect: ' . mysql_error());

    }

   mysql_select_db("", $con);



        $result= mysql_query("SELECT * FROM central  ");

        

        while($row = mysql_fetch_array($result))

  {

  echo "";

echo "";

echo  "";

 echo   "";

  echo  "";

 echo   "";

 echo   "";

   

echo        "";

  echo "";

 echo         "
" .$row[1] . " " . $row[2] . " " . $row[5] . " " . $row[4] . "  
"; 



     }

        

    ?>

Passing variable as a link

levsha — Fri, 20 Nov 2009 04:03:43 GMT

I retrieve three pieces of data from my MySQL table and need to pass one of them as a parameter in a link to a dynamically populated .php page and two of them use as the link text.
The echo statement below is not working.
Could you please see what's wrong with it?
Thank you!


$connection = mysql_connect("server.com","user","password") or die ("Couldn't connect to server."); 

$db = mysql_select_db("mydb", $connection) or die ("Couldn't select database."); 



$data = "SELECT inventorid, firstname, lastname FROM inventors WHERE taskdate - curdate() = 0";

  $query = mysql_query($data) or die("Couldn't execute query. ". mysql_error());

  

while($data2 = mysql_fetch_array($query)) {

echo "$data2['inventorid'] $data2['firstname'] $data2['lastname']\n";

}  

?>

Internet bot

drjay1627 — Fri, 20 Nov 2009 00:28:54 GMT

My friend and I are working on an Internet bot. We want to make a bot that given a website, would index into a table.

Example --

Given the website: www.daniweb.com

Add to table:

www.daniweb.com/c++
www.daniweb.com/c++/forum
www.daniweb.com/java
etc...

Any suggestion on how to do this?

How do I get rid of gaps between cells in table.

marlowkc — Thu, 19 Nov 2009 23:52:13 GMT

I cannot figure out how to do this. I have set the padding and border as 0 and tried the collapse border command. Here is my code:









Untitled Document

Enable GD Library

ytregnn — Thu, 19 Nov 2009 21:44:36 GMT

I'm trying to enable GD Library. I use PHPMyAdmin.

How can I do this?

Tiles Matching Game, Sessions 1D array // random_shuffle()

kryz — Thu, 19 Nov 2009 18:55:53 GMT

I'm trying to create a tiles matching (memory) game. I'm a beginner and I'm confused how exactly to start on creating one dimensional array for sessions. The tiles should be at least 30 with text values. When the user select first tile (reveal the text) and then user select second tile; if two tiles match, should remove tiles from the board. When user complete the board, user should be presented with a summary of their performance and the option to play again (new board should be generated).

I have no clue how to make 1d dimensional array or make random_suffle().

I try to run it and it doesn't show up any errors. Its just blank page.

Here is what I have so far:


        session_start();



        if(!isset($_SESSION['game']))

        {

            $tile = array("Item 1", "Item 2");

   

            for($n = 3; $n<11; $n++)

            {

                $tile[] = "Item ".$n;

            }

        } 

        else 

        {

            $tile = $_SESSION['game'];

        }





echo "";

echo "";

$rowCount=0;

for($i=0; $i
{

//  if($i%6==0)

    $rowCount++;

    if($rowCount==6)

    {

        echo "\n";

        $rowCount=0;

    }

    if(($_SESSION['flip1']==$i)or($_GET['index']==$i))

    {

        echo "";

    }

    else

    {

        echo "";

    }

 

}

echo "";

echo "
".$_SESSION['game'][$i]." flip me!
";

?>

else not working

mrjoli021 — Thu, 19 Nov 2009 17:25:13 GMT

my else statement is not executing it returns a black page.

 while($results = mysql_fetch_array($user_name))

         {

                        if ($results['email'] == $Entered_UserName && $results['password'] == $Entered_PassWord)

                         echo 'working';

                        else

                         echo 'not working';

                }

php mail with mysql

HITMANOF44th — Thu, 19 Nov 2009 15:30:25 GMT

ok i can post the script if you guys want its kinda on the large side mostly i just need to bounce some ideas off you

i made a event calendar and now i am making a script to email
users of the current months events i have this working

this is the issuse i made a html email in php i make a table in it
now when i go to the page every thing comes up perfect but
when i get the email that should look exsactly like that
some data in the table is shifted or the itself is not
a color any one have any ideas and some random ! show up ?

mail form with jQuery and PHP

Neona — Thu, 19 Nov 2009 15:25:49 GMT

I will start out by saying that I have no experience with PHP at all.. sorry.
However, since I do some asp.net etc I thought I would throw myself into it..

I have come across a problem though.
I've found a mail form using jQuery.

What it's supposed to do when I hit the 'submit' button is this:

function closeForm(){

                $("#messageSent").show("slow");

                 setTimeout('$("#messageSent").hide();$("#contactForm").slideUp("slow")', 2000);

But ever since I tied some PHP to the thing to actually make it work and send mail. It will automatically redirect me to a blank page.. the PHP document address. Instead of calling closeForm.

Alternatively I can do a header() and send it back to the front page, but that's just so far from satisfying...

I'm thinking there's just something basic about how PHP operates that I don't know about..
But let me know if you need to see more of the code behind, and I'll gladly supply it.

Thanks in advance
Maria

Passing variables from a php MySQL lookup

VAMPResearch — Thu, 19 Nov 2009 14:39:20 GMT

I am trying to create a page that will look up values from a table to fill in drop down boxes, i have this working. Now when the user selects options and presses a button i would like these values to get written to a table.

This code is my form that looks up values and populates drop down fields for the user.

 

 

 

        Godfather Wars 

         

         

         

         

         

        







 

 

 

 

        « Goto VAMP Research by Kristopher Thomas Croteau
 

        Godfather Wars
 

        Welcome to your desk
 

         

        

        
        $user = $_GET['user'];

        echo "Home
";

        echo "Profile
";

        echo "Your Family
";

        echo "Hitlist
";

        echo "Contact Admin
";

        echo "Dons         Desk
";

        ?>



        
 

        Message Inbox
 

 

 

         

                 

                         

                                 

        
        // Connecting, selecting database

        $link = mysql_connect('HOST', 'USER', 'PASSWORD')

    or die('Could not connect: ' . mysql_error());

        mysql_select_db('DBNAME') or die('Could not select database');

        // Performing SQL query

        $user = $_GET['user'];

        $query = "SELECT `name` FROM Members where username = '$user'";

        $result = mysql_query($query) or die('Query failed: ' . mysql_error());

        while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "";foreach ($line as $value);}

         echo "  Welcome to your desk Don $value
  ";

        // Closing connection

        mysql_close($link);

        ?>



                                This is your desk
 










// Connecting, selecting database

$link = mysql_connect('HOST', 'USER 'PASSWORD')

    or die('Could not connect: ' . mysql_error());

mysql_select_db('DBNAME') or die('Could not select database');

// Performing SQL query

$user = $_GET['user'];

$query = "SELECT `name` FROM Members where username = '$user'";

$result = mysql_query($query) or die('Query failed: ' . mysql_error());

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "";foreach ($line as $value);}

 echo "$value";

// Closing connection

mysql_close($link);

?>







































                                 

                        
 



                         

                                 

                                Your family members
 

                                


// Connecting, selecting database

$link = mysql_connect('HOST', 'USER 'PASSWORD')

    or die('Could not connect: ' . mysql_error());

//echo 'Connected successfully';

mysql_select_db('DBNAME') or die('Could not select database');

// Performing SQL query

$user = $_GET['user'];

$query = "SELECT * FROM Members where family = (SELECT family FROM Members where username = '$user')";

$result = mysql_query($query) or die('Query failed: ' . mysql_error());



$num = mysql_numrows($result);

$i=0;

do {

$Name = mysql_result($result,$i,"name");

$rank = mysql_result($result,$i,"rank");



$queryrank = "SELECT `rank` FROM ranks where id = '$rank' order by rank desc";

$resultrank = mysql_query($queryrank) or die('Query failed: ' . mysql_error());

while ($line1 = mysql_fetch_array($resultrank, MYSQL_ASSOC)) { echo "";foreach ($line1 as $value1);}





// Printing results in HTML

echo "$Name - $value1
";

$i++;

} while ($i < $num);

// Free resultset

mysql_free_result($result);

// Closing connection

mysql_close($link);

?>

                                
Contracts on your family
 

                                


// Connecting, selecting database

$link = mysql_connect('HOST', 'USER 'PASSWORD')

    or die('Could not connect: ' . mysql_error());

//echo 'Connected successfully';

mysql_select_db('DBNAME') or die('Could not select database');

// Performing SQL query

$user = $_GET['user'];

$query = "SELECT * FROM hitlist where targetfamily = (SELECT family FROM Members where username = '$user') and complete = '0' and sanctioned = '1'";

$result = mysql_query($query) or die('Query failed: ' . mysql_error());

$num = mysql_numrows($result);

$i=0;

if($num==0)

{

echo "There are no contracts on your family!";

}

else

{

do {

$target = mysql_result($result,$i,"target");

$killer = mysql_result($result,$i,"contractedto");

$family = mysql_result($result,$i,"contractfamily");

$date = mysql_result($result,$i,"issuedate");

// Printing results in HTML

echo "Target: $target 
";

//echo "Assassian: $killer
";

echo "Contracted by: $family 
";

echo "Contract Date: $date
";

echo "------------------------------------
";

$i++;

} while ($i < $num);

}

// Free resultset

mysql_free_result($result);

// Closing connection

mysql_close($link);

?>

 



                                Contracts started by your family
 

                                


// Connecting, selecting database

$link = mysql_connect('HOST', 'USER 'PASSWORD')

    or die('Could not connect: ' . mysql_error());

//echo 'Connected successfully';

mysql_select_db('DBNAME') or die('Could not select database');

// Performing SQL query

$user = $_GET['user'];

$query = "SELECT * FROM hitlist where contractfamily = (SELECT family FROM Members where username = '$user') and complete = '0' and sanctioned = '1'";

$result = mysql_query($query) or die('Query failed: ' . mysql_error());

$num = mysql_numrows($result);

$i=0;

if ($num==0)

{echo "There are no contracts started by your family! You are the Don start one!";

}

else

{

do {

$target = mysql_result($result,$i,"target");

$killer = mysql_result($result,$i,"contractedto");

$family = mysql_result($result,$i,"contractfamily");

$date = mysql_result($result,$i,"issuedate");

// Printing results in HTML

echo "Target: $target 
";

echo "Target family: $family 
";

echo "Assassian: $killer
";

echo "Contract Date: $date
";

echo "------------------------------------
";

$i++;

} while ($i < $num);

}

// Free resultset

mysql_free_result($result);

// Closing connection

mysql_close($link);

?>

 



                                Requested contracts
 

                                


// Connecting, selecting database

$link = mysql_connect('HOST', 'USER 'PASSWORD')

    or die('Could not connect: ' . mysql_error());

//echo 'Connected successfully';

mysql_select_db('DBNAME') or die('Could not select database');

// Performing SQL query

$user = $_GET['user'];

$query = "SELECT * FROM hitlist where contractfamily = (SELECT family FROM Members where username = '$user') and complete = '0' and sanctioned = '0'";

$result = mysql_query($query) or die('Query failed: ' . mysql_error());

$num = mysql_numrows($result);

$i=0;

if ($num==0)

{

echo "There are not requested contracts at this time!";

}

else

{

do {

$target = mysql_result($result,$i,"target");

$killer = mysql_result($result,$i,"contractedto");

$family = mysql_result($result,$i,"contractfamily");

$date = mysql_result($result,$i,"issuedate");

// Printing results in HTML

echo "Target: $target 
";

echo "Target family: $family 
";

echo "Requested By: $killer
";

echo "Contract Date: $date
";

echo "------------------------------------
";

$i++;

} while ($i < $num);

}

// Free resultset

mysql_free_result($result);

// Closing connection

mysql_close($link);

?>

 

 



                                 

                        
 

                         

                                 

                                Family Controls
 

                                Use the controls below to control your family:
 

                                Contracts/Hits
 

                                 

                                        View Current
 

                                        Add
 

                                        Cancel
 

                                        Complete
 

                                
 

                                Members
 

                                 

                                        Add
 

                                        Remove
 

                                        Promote
 

                                        Demote
 

                                
 

                                Points
 

                                 

                                        View Current
 

                                        Add
 

                                        Remove
 

                                
 



                                 

                        
 

                
 

        
 

 

 

        This page uses the Perfect 'Holy Grail' 3 Column Liquid Layout by Matthew James Taylor. Thanks for such a cool layout.

When the user clicks the button these variables should be passed into the database. I have this form so far:




//This section writes the user data to the table.

$target=$_POST['target'];

$date=$_POST['date'];

$assign=$_POST['assign'];

echo "Values are Target: " .$target;

$host="HOST"; // Host name 

$username1="USER"; // Mysql username 

$password1="PASSWORD"; // Mysql password 

$db_name="DBNAME"; // Database name 

$tbl_name="TABLENAME"; // Table name

// Connect to server and select databse.

$con = mysql_connect("$host", "$username1", "$password1")or die("cannot connect"); 

mysql_select_db('gfwars') or die('Could not select database');

$query  = "INSERT INTO `Members` VALUES ($target,'',$assign,'',$date,'0','','1')";

mysql_query($query);

mysql_close($con);

header('Location: family.php?user='.$user);

?>

Any idea how i can get the information in the option boxes to this second php page?

Storing info in Cookies

hkseo100 — Thu, 19 Nov 2009 14:26:23 GMT

Hey guys, I'm modifying a classified site, it's written in PHP.
What I'm trying to do is when a user comes in the website for the first time (aka no cookies created) the value of the variable would be -1, when they click on a state to browse in, it will have ?statechosen=1&blahblah, so the value would be 1 for a variable, and if its 1 it won't ask for the states again, it will only ask for the states when its -1, or 0.

but it's weird.
i have to click on the name of the state twice to have the cookie settings in effect. And if i go on the index page twice, it'll ask me to choose the state again.

here's the code.

function xSetCookie($name, $value)

{

        setcookie($name, $value, 0, "/");

}

setcookie($ck_choosestate, $xstatechosen, time()+(60*24*60*60), "/");

        $xstatechosen ="";

        $statechosen ="";

$ck_choosestate                = "xzclf_choosestate";

//Choose State

$nostate = -1;

if ($_GET['statechosen'] > 0)

{

        $xstatechosen = $_GET['statechosen'];

}

elseif ($_GET['statechosen'] < 0)

{

        $xstatechosen = $_GET['statechosen'];

}

elseif ($_COOKIE[$ck_choosestate] > 0)

{

        $xstatechosen = $_COOKIE[$ck_choosestate];

}

elseif ($_COOKIE[$ck_choosestate] < 0)

{

        $xstatechosen = $_COOKIE[$ck_choosestate];

}

elseif ($nostate)

{

        $xstatechosen = $nostate;

}

how to import the contacts from sites like yahoo, gmail, facebook, orkut..

rajabhaskar525 — Thu, 19 Nov 2009 13:31:48 GMT

hi all, i am new to php. i want know about how to import contacts from yahoomail,gmail, orkut, facebook, xing,..........like. if anybody know about these. help me. share with me. ........

Problem in transfer fron 1st list to another?

Aamit — Thu, 19 Nov 2009 12:48:04 GMT

Hi,

I am trying to transfer multiple select country to another select box.

But when i click on submit i didn't get the value of array of list2 i.e finallist?

I can't understand what is problem??

Please help me how to solve this??


if($_POST["add"])

{

        echo "sdads";

        echo "
hello ->".$country_array=$_POST['finallist'];

        

        

}

?>

Sql upload - I must be simple?

eman neercs — Thu, 19 Nov 2009 12:38:10 GMT

Running php/mysql site where the db is constantly being changed with new products added, categories and prices changed all through php scipts.

Just before it publishes the results to a static html file, there is a (my)sql file with product data that has been held "off table" so it cannot be inadvertently changed by the other scripts. I currently add this back manually but I'd like to use php to do it.

I could change the data to txt or csv and use mysql insert statements but I cannot find how to do a simple upload the .sql to a db.

Where should I start looking?

how to insert data into 2 tables in MySQL using PHP

Nuw2php — Thu, 19 Nov 2009 09:39:28 GMT

hi,

I have created 2 tables called "User_Info" & "Auth_Users".

In "User_Info" table "ID" is the primary key. In "Auth_Users" table "ID" is the foreign key.

I have created a "User Form" through which I am trying to capture the data. Since the primary key is an auto_increment value I don't have to insert that in the "User_Info" table.

In the "User Form" I have fields like - Firstname, Lastname, Phone, Email & Password. I am trying to break this fields and Insert "firstname, lastname, phone" in "User_Info" table and "Email & Password" in "Auth_Users" table.

Besides this, i also want to insert the same "ID" number from "User_Info" table to "Auth_Users" table "ID" field.

I couldn't get it solved. Please help me.

refresh part of the page

rajabhaskar525 — Thu, 19 Nov 2009 07:53:37 GMT

hai all, i want to refresh particular part of the page ,not whole page. is it possible? . if so, how is it? .........

Moving a field contents from Table B to Table A

futhonguy — Thu, 19 Nov 2009 07:41:55 GMT

Hi

I am wondering if i can move a field (with contents) from Table B to Table A. If so how can i do it?

Any advise ?? Thank you very much..

php hedder is not working

ruwanaru — Thu, 19 Nov 2009 06:21:58 GMT

This is the error

Warning: Cannot modify header information - headers already sent by (output started at /home/rejocoma/public_html/login-registor/do_login.php:9) in /home/rejocoma/public_html/login-registor/do_login.php on line 40

and this comming only on my hosting not in local machine ita unix hosting solution

can any one give me a help on this im a new in php and pleas give me a help...

Thank you.........

login in php

xuexue — Thu, 19 Nov 2009 05:50:39 GMT

hi there, i am making a website. my problem is that, i have multiple users who should access the same page, now what i want is that, my login code will work whenever users will access it simultaneously. the problem is that, the code just checks the first logged in user.

Example, user1 and user2 logged in simultaneously. the login code detects the first logged in user it sees from the database (user1). user1 views its homepage, now user2 accesses user1's homepage since user1 logged in first. now, when user1 logs out, it will only be the time when user2 sees his homepage.

what i want is that, when both users log in simultaneously, they will see their own homepages. thanks, any code will be very much appreciated.. tnx in advance.

mail() not doing tables (showing code: etc..)

SKANK!!!!! — Wed, 18 Nov 2009 22:56:02 GMT

im using the php mail() function to send an email and i got the email. except its formatted wrong like it looks like this:

The value passed is 'Array'.

Can anyone help so that all of the selected checkbox values are passed.

Regards,

T

Echo array

levsha — Wed, 18 Nov 2009 00:26:55 GMT

Here is my code:


$connection = mysql_connect("myserver.com","myuser","mypassword") or die ("Couldn't connect to server."); 

$db = mysql_select_db("mydb", $connection) or die ("Couldn't select database."); 



$search=$_POST['search'];



$data = "SELECT firstname, lastname, task FROM inventors WHERE taskdate - curdate() = 1";

  $query = mysql_query($data) or die("Couldn't execute query. ". mysql_error());

  $data2 = mysql_fetch_array($query);



echo "$data2[firstname] "; 

echo "$data2[lastname] ";

echo "$data2[task]"; 

  

?>

In my database, I have two records that meet the criteria.
When I run the select in MySQLAdmin, it brings me two records.
The PHP, though, echoes only one.
What's wrong with the code?

Thank you!

passing jquery values to php variables

shishtawitch — Tue, 17 Nov 2009 17:17:39 GMT

i have a form in another form............

the form2 is submited automatically, and has only one field of fileupload, and is auto processing file upload with jquery ajax...!!

it works fine for me but when i pass the response filename of form2 to form1 field it shows me fine........but when i submit form1 the field which contains the form2 response value it says empty........!! how can i fix that

PHP causes query error

benkyma — Tue, 17 Nov 2009 16:03:50 GMT

I have the following code which results in a mysql error. However, when I use this query in PHPMyAdmin it works fine. Can anyone see what is causing the error?

        for($i=0; $i<10; $i++)

        {

                $nextDay = $i+1;

                  $startDateTime = date("Y-m-d H:i:s", strtotime("-$i days"));

                  $endDateTime = date("Y-m-d H:i:s", strtotime("-$nextDay days"));

                  $query = "select title, app_id, count(*) as cnt from app_instances where (time between $endDateTime and $startDateTime) and (app_id = $subjectId)  group by title";

                  $result = mysql_query($query) or die("error: ".mysql_error());

                  $title = $row['title'];

                $count = $row['cnt'];

                $appId = $row['app_id'];

                echo $startDateTime."  ";

                echo $title."  ";

                echo $count."  ";

                echo $endDateTime;

                echo '
';

}

Creates the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '16:02:51 and 2009-11-17 16:02:51) and (app_id = 2) group by title' at line 1

Print Multiple Files using PHP

ayesha789 — Tue, 17 Nov 2009 12:57:54 GMT

Dear All
I have developed a lease management System.
I have stored 4000+ Lease agreements and purchase orders.
Folders Structure
Main Folder : LAPO
Subfolders: North , Center , South
Subfolders : 1245 , 9867 like these (numeric)
In each numeric folder there are 2 files
LA.pdf and PO.Pdf
How I can print them all

images

muralikalpana — Tue, 17 Nov 2009 12:45:45 GMT

hello,

is it possible to delete waste images from folder using php.
for suppose user uploaded images....after his account expires his account will be deletes by admin. at the same how to delete his photos from folder.

Array repeats values in it

veledrom — Tue, 17 Nov 2009 12:42:31 GMT

Hi,

Code below returns this.

Array

(

    [0] => 3

    [id] => 3

    [1] => John

    [name] => John

    [2] => Goog

    [surname] => Goog

)

Everything repeated. Why? Also, I need to serialize. I need it for some other reason.

        $sql="SELECT * FROM friends WHERE id='3'";

        $runSql=mysql_query($sql);

        if(mysql_num_rows($runSql)>0){

                $newArray=mysql_fetch_array($runSql);

                return serialize($newArray);

        } else {

                return "ERROR: No friend found";

        }



echo "";

print_r(unserialize($response));


Thanks

global variables in php

shishtawitch — Tue, 17 Nov 2009 11:05:21 GMT

hi,
i am trying to upload an image with comment......!!

mycode is like below......

if($_POST){
getting posted variables for comment
mysql_query(adding into database);

if(image is posted){now getting image variables
mysql_query(inserting into database);
}
}

if works fine for me but problem is that i have two different tables one for comment and one for image........!! i want to add current user id also into image table but it is not passing to table but rest of code is working all the way fine..........!! how can i do that

Making mysql links clickable in php

dmkc — Tue, 17 Nov 2009 10:20:42 GMT

Hi everyone, I've been a reader for a long time, now I've joined up, as I'm fairly stumped on this one!!

I'm currently teaching myself mysql and php at work, and have a problem. I am using php to produce a listing of restaurants on a page, and I would like to do the following at the end of each line:

1) If the website field is not blank, display the url (or even just "Website")

2) Make the URL Clickable, and open in a new window.

I've managed to produce the list, however my code has gone south somewhere as the "website" field is displaying even when there is no entry in the database. Also when the link is present it's clickable, but opening in the same window. Can someone help me and tell me where I've gone wrong?

 
                                        mysql_connect(HOST,USER,PASS);

@mysql_select_db("db303278079") or die( "Unable to select database");

$query="

SELECT * FROM restaurants";

$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;

while ($i < $num) {

$rest_name=mysql_result($result,$i,"rest_name");

$address=mysql_result($result,$i,"address");

$telephone=mysql_result($result,$i,"telephone");

$website=mysql_result($result,$i,"website");

$cuisine_type=mysql_result($result,$i,"cuisine_type");

$area=mysql_result($result,$i,"area");

echo "$rest_name, $address, $telephone, ($cuisine_type), $area, 'Website'
";

$i++;

}

?>

Thanks in advance for your help :)

joomla mynxx

angel_devon21 — Tue, 17 Nov 2009 07:28:04 GMT

hi to all
any one pls help me with this
id ont know how to edit mynnxx template of joomla.

Attached Images

width="60%"etc.. u get it right?
i use gmail. now ive had images sent in mails to me. so why is this not working? i havent tested images but i figure that if table doesnt work img wont either. whats going on? is there a workaround? or is this what all mail sent by php mail() is bound to look like.

i have free hosting atm. or is it the hosting?
im clueless halp?!

dynamic variable plug into a mysql query?

localtechguy — Wed, 18 Nov 2009 19:57:23 GMT

HI!

I am trying to find a way to plug some data that is spit out of a mysql query into another mysql query.

example.

$zip1 = $_POST[zip1];



"SELECT * FROM zipcodedb WHERE ZipCode >= '". $zip1 ."'"

lets say i get that query to spit out these 3 results with a while loop :
11758
11759
11760

now i need to take those three zipcodes and plug them into another mysql query

"SELECT * FROM zipcodedb WHERE ZipCode = 11758 OR ZipCode = 11759 OR ZipCode = 11760"

The part i am stuck on is this.
I need to figure out a way to dynamically populate the WHERE portion of this query because the above zipcodes will change depending on what was entered and submitted into the FIRST mysql query.

I'm trying to explain best as i can, my english is not perfect.
Thank you for any help anyone can offer.

GD Question

EvolutionFallen — Wed, 18 Nov 2009 19:35:50 GMT

Hi,
I'm using GD to dynamically draw a rectangle on an image I have of a map. I've got that part working fine.

Here's my question:
I know I need to set the headers of the page to

content-type: image/png

, otherwise I get a bunch of characters instead of the picture.
But what if I want to place this dynamically created image inside a PHP or HTML document so that I can place text and other data around it? Is there any way to do this, or does the GD-generated image have to stay on its own page?

Thanks
- EF

help with solr (java application) on GoDaddy php shared hosting

galaxygal — Wed, 18 Nov 2009 19:28:17 GMT

exec('java -version', $javaver);





print_r($javaver);

echo "
";





exec('java -jar start.jar', $output);



print_r($output);

echo "
";



exec('java -jar post.jar  /home/content/j/a/n/jandtesting/html/solr/example/exampledocs/solr.xml /home/content/j/a/n/jandtesting/html/solr/example/exampledocs/monitor.xml', $output2);



print_r($output2);

I've never attempted anything with java before. I'm trying to get started on the solr tutorial -- a java based search engine based on Lucene. I don't think I've got this working at all because I probably didn't put the java commands in correctly above. I would really appreciate some guidance.

Galaxygal

dynamic videos with php

shishtawitch — Wed, 18 Nov 2009 17:29:32 GMT

how can i play videos at its place...........like in facebook........!!

i.e in facebook video thumb is given when we click on it it place at its place............!! how can i do it with jquery and php...........!!

Arrays and include function?

whitestream6 — Wed, 18 Nov 2009 16:55:15 GMT

I've just been learning arrays, and so far it's going well :)
This is my current PHP code:


      $states = array ('MD' => 'Maryland', 'IL' => 'Illinois', 'MI' => 'Michigan');

      $provinces = array ('QC' => 'Quebec', 'AB' => 'Alberta');        

          $abbr = array ('US' => $states, 'Canada' => $provinces);

      $japanesemotors = array ('ToyotaCamry' => '');

          ?>


echo $abbr['US']['MI'];  ?>


echo $abbr['Canada']['AB'];

?>


echo $abbr['japanesemotors']['ToyotaCamry'];

?>

However, I can't get a newline in between the arrays, so it produces the following:

MichiganAlberta

How do I get a new line to work in or in between the echo function?

Also, can you use the php include function in arrays like I used the HTML image function in my japanesemotors example above?

Thanks

A variety selection

rajeesh_rsn — Wed, 18 Nov 2009 15:36:32 GMT

Hai friends I need a simple (?) advice in one of my web page.

I had developed a web application in one of its page there are many number of checkboxes. Users are need to select single or multiple check boxes. But there is a limit for each users. ie If an user are only permitted to select 2 items, then I need to disable all the rest of checkboxes after he/she selected the 2. And also they can select another item , if they deselect the existing item.

Friends I am little bit confused and wondered how to do this. I am using PHP for development.

Please help me.
Thanks for your valuable time
Rajeesh

why ob_start()

veledrom — Wed, 18 Nov 2009 15:18:03 GMT

Hi,

I read this ob_start() but want a bit cleaner explanation.
why we use it, should we use it, what happens if we don't?

I have never used it and won't use it until I understand it is best practise.

Thanks in advance

Help Me Out!!!

ym_chaitu — Wed, 18 Nov 2009 13:32:10 GMT


include("access.php");

mysql_select_db($dbname);

$user="ym_chaitu";

//$e=mysql_query("select email from userlogin where username='$user'");

//$email=mysql_query($e,0);

$query = mysql_query("SELECT username,password FROM userlogin WHERE username = '$user'") or die(mysql_error());

$data = mysql_result($query);

echo $data;

?>

this is my code,,when i am using it out, it is giving me an error
Warning: Wrong parameter count for mysql_result() in C:\Program Files\xampp\htdocs\chaitu\magpierss\test.php on line 8

can any one let me know where an i wrong

how to make a online game web site

hno — Wed, 18 Nov 2009 13:24:43 GMT

HI
i know php/mysql and javascript well and I've made some web site .

now , I want to make a online game web site that it has two type of games . One type are simple games like BACKGAMMON or chess

another type are multiplay games . I have installed Arcade.Script.v1.2.B but it didn't has any game .

can any one help me to make a online game web site .
i've searched alot in the net but i couldn't find any good information about it . where I can get more information about the scripts and other game systems ?

I asked lots of question, please forgive me

thanks very much

How to insert csv file data to mysql table selected colum

sandipan.rcciit — Wed, 18 Nov 2009 12:53:31 GMT

hi,
i want to make a program where the csv file directly insert into the mysql database table.

i found the code:


include 'mysql-connect.php';

$rec=0;

$handle = fopen ('datafile1.csv', 'r');

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

                {

                        $rec++;

                        if($rec==1)

                        {

                        continue;

                        }

                        else

                        {

                        $query = "INSERT INTO Book_details VALUES ('". implode("','", $data)."')";

                         $query = @mysql_query($query);

                        }

                }





?>

it working fine .

but i have to face problem when i specify the columns in the mysql table like

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

                {

                        $query = "INSERT INTO Book_details(idt_no,book_name,author_name,publisher_name,condition,condition_note,price,cur,quantity) VALUES ('". implode("','", $data)."')";

                         $query = @mysql_query($query);

                }

no value is insert in the data base???

mention that database have 12 columns and csv have 9.
i have to insert all 9 to selected 9 columns in the database.
plz help me....

find the url someone entered

lifeworks — Wed, 18 Nov 2009 10:54:08 GMT

Hi

Im setting up a news distribution system... sort of... i want to record everyone who downloads the news articles... so ive blocked direct linking to the pdf files using an htaccess file.

my htaccess file redirects people to a page which captures where they came from ( for interests sake) and then tells them they have tried to access a file without authorization... ie, without going through my website and being 'counted'...

so now I want to find the url they typed in to access that file directly, so that i can provide a link to it, this time through my website, and thus give them access but also be able to 'count' them and provide accurate analytics on viewership...

how do i find that url they originally typed in? I currently collect the referer_url but dont know if I can get the one they typed in...?!

Thanks lworks

virus in hosting server

praveen_dusari — Wed, 18 Nov 2009 08:43:46 GMT

hi all,
i have downloaded my site from ftp to make changes there is a virus in that server my sir told me to clear that and upload.
In the source code i found a line which i thought is a virus containing a trojen program
i deleted that line in dreamweaver and exectuded locally but line is reappearing in code when in viewed a page source code how come this is possible

i thought of pasting that line which is a script include to another site but i thought it may infect this site too..

any ideas??

adding cron job with php ajax

shishtawitch — Wed, 18 Nov 2009 07:55:06 GMT

hi, my problem is that,
i want on my site, that when a user uploads a video on my site, my script get the uploaded video, and let the user what he was doing, and process that video behind the scences with php and ffmpeg, and displays it when it is ready,........lik in face book.........!! how can i do that..........!!
i am able to convert videos, fetching thumbs, and duration and storing to database but i know the direct process, now i want the behind the scenes process..............

Thanks in advance

Showing DB data in an order

kiranhg.2008 — Wed, 18 Nov 2009 07:40:31 GMT

I want to display records from database in this order

1 2 3
4 5 6
........

or

1 4 ....
2 5 ...
3 6.....

pls can anybody help me ........

Contact us form posting to itself

motieno — Wed, 18 Nov 2009 05:29:22 GMT

Hi'
I learnt that in order for the error messages to a form to be displayed on the same window with the form one method is to post it to itself ie the action attribute...
Initially my action attribute for "contacts.php" was pointing to "mailer.php". The problem was that my error messages were being displayed on a separate page/window. I dont want to go the javascript way for now. Am not sure how these two files can be merged so that the error messages can appear on the same page. Anyone who can do that for me.

Here are the two files
contacts.php











        Jiomoe Foundation

        

        

        



        

        



        

        

        

        





 







         

                
                        include("logo.php");

                        ?>

                        


                

        

                                

                                                Home


                                                About Us


                                                Our Programs


                                                Membership


                                                Careers


                                                Contacts


                                


                






         

                

                        

                        The fields marked with an asterik must be filled


                        First Name:*


                           


                           


                         Last Name:*


                           


                           


                           Telephone Number:


                           


                           






                           Email:*


                           


                           


                           Message:*


                           

                           


                           


                           

                        


                


        




 

        

                

                        Jiomoe Foundation is a Volunteer, Community based Youth initiative

                        founded by the Kenyan Youth to eradicate poverty,

                        create employment opportunities, market and empower the Youth.


                        


                        

                                Information


                                        Founded
 2008

                        


                        

                                Links


                                        www.jiomoeclub.net


                                        www.jamhurisoftware


                                        www.fashtechcomputers


                        
 

        






 



 

         

                

                        Contact details

                


                


                Email: info@jiomoe.org


                Tel: +254723169577


                +254734297258

                

                        Find Us

                


                        

        




                
                include("./include/footer.php");

                ?>

mailer.php


if(isset($_POST['email'])) {

 

        // EDIT THE 2 LINES BELOW AS REQUIRED

        $email_to = "info@jiomoe.org, matotien@gmail.com, nellynellbig@gmail.com,matotien@yahoo.com,jiomoeclub@yahoo.com,info@jiomoeclub.net";

        $email_subject = "Web Inquiries";

 

 

        function died($error) {

                // your error code can go here

                echo "We are very sorry, but there were error(s) found with the form your submitted. ";

                echo "These errors appear below.

";

                echo $error."

";

                echo "Please go back and fix these errors.

";

                die();

        }

 

        // validation expected data exists

        if(!isset($_POST['first_name']) ||

                !isset($_POST['last_name']) ||

                !isset($_POST['email']) ||

                //!isset($_POST['telephone']) ||

                !isset($_POST['comments'])) {

                died('We are sorry, but there appears to be a problem with the form your submitted.');                

        }

 

        $first_name = $_POST['first_name']; // required

        $last_name = $_POST['last_name']; // required

        $email_from = $_POST['email']; // required

        //$telephone = $_POST['telephone']; // not required

        $comments = $_POST['comments']; // required

 

        $error_message = "";

        $email_exp = "^[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$";

  if(!eregi($email_exp,$email_from)) {

          $error_message .= 'The Email Address you entered does not appear to be valid.
';

  }

        $string_exp = "^[a-z .'-]+$";

  if(!eregi($string_exp,$first_name)) {

          $error_message .= 'The First Name you entered does not appear to be valid.
';

  }

  if(!eregi($string_exp,$last_name)) {

          $error_message .= 'The Last Name you entered does not appear to be valid.
';

  }

  if(strlen($comments) < 2) {

          $error_message .= 'The Comments you entered do not appear to be valid.
';

  }

 /* $string_exp = "^[0-9 .-]+$";

  if(!eregi($string_exp,$telephone)) {

          $error_message .= 'The Telphone Number you entered does not appear to be valid.
';

  }*/

  if(strlen($error_message) > 0) {

          died($error_message);

  }

        $email_message = "Form details below.\n\n";

 

        function clean_string($string) {

          $bad = array("content-type","bcc:","to:","cc:","href");

          return str_replace($bad,"",$string);

        }

 

        $email_message .= "First Name: ".clean_string($first_name)."\n";

        $email_message .= "Last Name: ".clean_string($last_name)."\n";

        $email_message .= "Email: ".clean_string($email_from)."\n";

        $email_message .= "Telephone: ".clean_string($telephone)."\n";

        $email_message .= "Comments: ".clean_string($comments)."\n";

 

 

// create email headers

$headers = 'From: '.$email_from."\r\n".

'Reply-To: '.$email_from."\r\n" .

'X-Mailer: PHP/' . phpversion();

@mail($email_to, $email_subject, $email_message, $headers);  

?>

 



 

 

 









        Jiomoe Foundation

        

        

        

 

        

        

 

        

        

        

        

 

 

 

 





         

                
                        include("logo.php");

                        ?>

                        


                

 

                                

                                                Home


                                                About Us


                                                Our Programs


                                                Membership


                                                Careers


                                                Contacts


                                


                


 



         

                

 

Your message was sent


 

Your message was successfully sent!

Thank you for contacting us, we will reply

to your inquiry as soon as possible!




 

        


        


 

 

        

                

                        Jiomoe Foundation is a Volunteer, Community based Youth initiative

                        founded by the Kenyan Youth to eradicate poverty,

                        create employment opportunities, market and empower the Youth.


                        


                        

                                Information


                                        Founded
 2008

                        


                        

                                Links


                                        www.jiomoeclub.net


                                        www.jamhurisoftware


                                        www.fashtechcomputers


                        
 

        




 

 

 

 

         

                

                        Advertisements

                


                

                        Find Us

                


                        

        




                
                include("./include/footer.php");

                ?>

 

 

 

 

 


}

?>

The merged file gave me a error message
"Parse error: syntax error, unexpected $end in C:\wamp\www\juhudi\contacts.php on line 288"
my merged file











        Jiomoe Foundation

        

        

        



        

        



        

        

        

        





 







         

                
                        include("logo.php");

                        ?>

                        


                

        

                                

                                                Home


                                                About Us


                                                Our Programs


                                                Membership


                                                Careers


                                                Contacts


                                


                






         

                

                        

                        The fields marked with an asterik must be filled


                        First Name:*


                           


                           


                         Last Name:*


                           


                           


                           Telephone Number:


                           


                           






                           Email:*


                           


                           


                           Message:*


                           

                           


                           


                           

                        


                


        




 

        

                

                        Jiomoe Foundation is a Volunteer, Community based Youth initiative

                        founded by the Kenyan Youth to eradicate poverty,

                        create employment opportunities, market and empower the Youth.


                        


                        

                                Information


                                        Founded
 2008

                        


                        

                                Links


                                        www.jiomoeclub.net


                                        www.jamhurisoftware


                                        www.fashtechcomputers


                        
 

        






 



 

         

                

                        Contact details

                


                


                Email: info@jiomoe.org


                Tel: +254723169577


                +254734297258

                

                        Find Us

                


                        

        




                
                include("./include/footer.php");

                ?>

 



 




if(isset($_POST['email'])) {

 

        // EDIT THE 2 LINES BELOW AS REQUIRED

        $email_to = "info@jiomoe.org, matotien@gmail.com, nellynellbig@gmail.com,matotien@yahoo.com,jiomoeclub@yahoo.com,info@jiomoeclub.net";

        $email_subject = "Web Inquiries";

 

 

        function died($error) {

                // your error code can go here

                echo "We are very sorry, but there were error(s) found with the form your submitted. ";

                echo "These errors appear below.

";

                echo $error."

";

                echo "Please go back and fix these errors.

";

                die();

        }

 

        // validation expected data exists

        if(!isset($_POST['first_name']) ||

                !isset($_POST['last_name']) ||

                !isset($_POST['email']) ||

                //!isset($_POST['telephone']) ||

                !isset($_POST['comments'])) {

                died('We are sorry, but there appears to be a problem with the form your submitted.');                

        }

 

        $first_name = $_POST['first_name']; // required

        $last_name = $_POST['last_name']; // required

        $email_from = $_POST['email']; // required

        //$telephone = $_POST['telephone']; // not required

        $comments = $_POST['comments']; // required

 

        $error_message = "";

        $email_exp = "^[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$";

  if(!eregi($email_exp,$email_from)) {

          $error_message .= 'The Email Address you entered does not appear to be valid.
';

  }

        $string_exp = "^[a-z .'-]+$";

  if(!eregi($string_exp,$first_name)) {

          $error_message .= 'The First Name you entered does not appear to be valid.
';

  }

  if(!eregi($string_exp,$last_name)) {

          $error_message .= 'The Last Name you entered does not appear to be valid.
';

  }

  if(strlen($comments) < 2) {

          $error_message .= 'The Comments you entered do not appear to be valid.
';

  }

 /* $string_exp = "^[0-9 .-]+$";

  if(!eregi($string_exp,$telephone)) {

          $error_message .= 'The Telphone Number you entered does not appear to be valid.
';

  }*/

  if(strlen($error_message) > 0) {

          died($error_message);

  }

        $email_message = "Form details below.\n\n";

 

        function clean_string($string) {

          $bad = array("content-type","bcc:","to:","cc:","href");

          return str_replace($bad,"",$string);

        }

 

        $email_message .= "First Name: ".clean_string($first_name)."\n";

        $email_message .= "Last Name: ".clean_string($last_name)."\n";

        $email_message .= "Email: ".clean_string($email_from)."\n";

        $email_message .= "Telephone: ".clean_string($telephone)."\n";

        $email_message .= "Comments: ".clean_string($comments)."\n";

 

 

// create email headers

$headers = 'From: '.$email_from."\r\n".

'Reply-To: '.$email_from."\r\n" .

'X-Mailer: PHP/' . phpversion();

@mail($email_to, $email_subject, $email_message, $headers);  

?>

 



 

 

 









        Jiomoe Foundation

        

        

        

 

        

        

 

        

        

        

        

 

 

 

 





         

                
                        include("logo.php");

                        ?>

                        


                

 

                                

                                                Home


                                                About Us


                                                Our Programs


                                                Membership


                                                Careers


                                                Contacts


                                


                


 



         

                

 

Your message was sent


 

Your message was successfully sent!

Thank you for contacting us, we will reply

to your inquiry as soon as possible!




 

        


        


 

 

        

                

                        Jiomoe Foundation is a Volunteer, Community based Youth initiative

                        founded by the Kenyan Youth to eradicate poverty,

                        create employment opportunities, market and empower the Youth.


                        


                        

                                Information


                                        Founded
 2008

                        


                        

                                Links


                                        www.jiomoeclub.net


                                        www.jamhurisoftware


                                        www.fashtechcomputers


                        
 

        




 

 

 

 

         

                

                        Advertisements

                


                

                        Find Us

                


                        

        




                
                include("./include/footer.php");

                ?>

 

 

 

 

 


}

?>

Help with checkboxes

feddie1984 — Wed, 18 Nov 2009 00:57:53 GMT

Hi All,

I have the following code:

$requester_email = $_POST['requester_email'];

$requester_name = $_POST['requester_name'];

$todays_date = $_POST['todays_date'];

$Start_Date = $_POST['Start_Date'];

$End_Date = $_POST['End_Date'];

$Department = $_POST['Department'];

$No_Engineers_Required = $_POST['No_Engineers_Required'];

$Prefered_Engineers = $_POST['Prefered_Engineers'];

$Customer_Name = $_POST['Customer_Name'];

$Location = $_POST['Location'];

$Type_Of_Job = $_POST['Type_Of_Job'];

$Job_Ref_No = $_POST['Job_Ref_No'];

$Additional_info = $_POST['Additional_info'];

The help I need is the information for Prefered_Engineers comes from a collection of checkboxes.

This code is here:

logo.JPG (10.5 KB)

changing session timeout

vgkarthi — Tue, 17 Nov 2009 06:53:57 GMT

Hi one of my friend have this problem.. it will be helpful if we can give him a solution.

The session is set for 10 min .. but for one particular page the session must be extended and for other pages it must be set as before.. or resetted so that it will take from the xml file.
Thanks in advance.

Using SELECT function

futhonguy — Tue, 17 Nov 2009 06:51:19 GMT

I would like to make some query using the SELECT function. However i wasnt able to get the results i want.
My code is as follow:

$sql = "SELECT *

FROM device 

WHERE ((device_num like '%$val_d%') OR (dib like '%$val_dp%')) ";

can i write it in this way? pls advise thanks people..:)

mailing concept

muralikalpana — Tue, 17 Nov 2009 06:34:06 GMT

hello,
i want to do a new task. but it is new to me. any body help plz...

i want to send registration form through email to users. then user fill that registration form. i wrote javascript in mail body but in that javascript not working. below is my 'mail body'

//this subject will be visible only for you

                $sub = "".$name." invites you to www.murali.com";

        

                $msg = "

                

                

                

                

                

                

                

                                          

                                                

                                          

                                          

                                                

                                          

                                          

                                          

                                          

                                                

                                          

                                          

                                                

                                          

                                         

                                          

                                                

                                          

                                          

                                                

                                          

                                          

                                                

                                          

                                          

                                                

                                          

                                           

                                          

                                          

                                          

                                                

                                          

                                        


                                                        


                                                        

                                                            ".$transl2." 



                                                                

                                                                

                                                                

                                                                

                                                                

                                                                

                                                                

                                                                

                                                                

                                                                

                                                                

                                                                

                                                                

                                                                

                                                                

                                                                username 
password 
  


                                                                


                                                                        
Regards,


                                                murali.

                                                


                                        ";

auto refresh

iraberyl — Tue, 17 Nov 2009 06:19:29 GMT

hi,
got a new prob, how can i create a php page that automatically refreshes each time i access the page.

div tag + iframe

soeb — Tue, 17 Nov 2009 05:11:34 GMT

hi!
I want add div value to ifram as source,
help me

Concatination of variables in an UPDATE statement

levsha — Tue, 17 Nov 2009 03:41:05 GMT

I have an HTML form with three dropdown selects:
month, day and year.
I have four fields in my MySQL table:
month, day, year, and date.
The 'date' field is supposed to contain the concatenated values of the year, month and day separated by dashes.
I write this in my PHP:

$data = "UPDATE inventors SET month='$month',

day='$day', year='$year', date='$year . "-" . $month . "-" . $day' 

WHERE lastname=".'"'.$lastname.'"';

The concatenation doesn't work.
What am I doing wrong?

Thank you!

what is wrong with my code

mrjoli021 — Mon, 16 Nov 2009 21:28:12 GMT

Why doesnt this code work. I keep getting false even when i type in the correct username and password

$user_name = mysql_query("SELECT * FROM users WHERE username =

                                           '".$Entered_UserName ."' 

                                           AND password = '".md5($Entered_PassWord) . "'");



         $user_name_password = mysql_fetch_assoc($user_name);



         if($user_name_password === false)

           {

                   echo 'false';

           }

         else

           echo 'true';

         }

Checking for Value of 0 instead of Empty Value

zeusofolus — Mon, 16 Nov 2009 21:26:37 GMT

I am checking to see if a value has been entered in a form and then updating only if a value is entered. The problem is I want 0 to be an option that can be entered and php is treating 0 as if it were the same as NULL which is the default entry in the DB so what I end up with is 0 entered in each column of the DB instead of empty values in some and numerical values in some.

Is there a way to check and see if a number including 0 has been entered and if not to treat the field as NULL?

                if ($value != NULL ){

                        

                        //Update The Standing Order Amount

                        $insert = "UPDATE custom_items SET AltQuantity='$value' WHERE VisitorID='$_SESSION[VisitorID]' AND ItemID='$item[id]'";

                                 mysqli_query($dbc, $insert);

                    

                        }

Thanks,
Eric

Create new directory based on new database record

sadiebee — Mon, 16 Nov 2009 21:02:03 GMT

Hello folks!

Is it possible to create directories on my web server based on new database entries?

I am implementing a photo gallery and want to have it such that, when a user ADDS a new Gallery, a (sub)directory is created with the name that the user gave the gallery. Then when the user uploads photos into that gallery, they are actually stored in the corresponding folder.

Help, anyone?

Thanks so much in advance!

xml file from php script

whiteyoh — Mon, 16 Nov 2009 20:56:27 GMT

Hi All,

Im wanting the following script to output to an XML file, but im getting an error on line 18 and i have hit a brick wall.

Help would be appreciated.


require_once("connect.inc.php");

   $db = getConnectionMySql();

   $stmt = $db->query("SELECT email, name, lastlogin FROM subscriber");

   while ( $obj = $stmt->fetchObject()){

           echo $obj->email . ":" . $obj->name . ":" . $obj->lastlogin .  "
";

           //   print " \n";

      // print "  $email\n";

       //print "  $name\n";

           //print " $lastlogin\n";

       //print " \n";

   }

   

   $fp = fopen('subscribers.xml','w');

        if(!$fp) {

    die('Error cannot create XML file');

}

fwrite($fp->$obj());

fclose($fp);

?>

php syntax error

whiteyoh — Mon, 16 Nov 2009 20:00:01 GMT

Hi All,

the following code is giving me the following error and i would appreciate any help in identifying where the error lies

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in /Applications/MAMP/htdocs/CG0119/index.php on line 6

the code is here, and line 6 is the echo statement

 $db = getConnectionMySql();

   $stmt = $db->query("SELECT email, name, lastlogin FROM subscriber");

   while ( $obj = $stmt->fetchObject()){

           echo $obj->email . ':''\n';

Basic array question

niche1 — Mon, 16 Nov 2009 17:33:57 GMT

I successfully scripted an fetch array while loop on a table called example.

What's the name of the function that will return the name of the array that was created by the fetch array while loop?

What's the name of the function that will turn the number of rows in an array?

Thanks

Drop down menu populated from database and buttons

loveisblind — Mon, 16 Nov 2009 16:12:12 GMT

Hello everybody. I'm pretty new to PHP and mysql. I made a mysql database table: Election_Table
One of the fields in there is elect_title, and the primary key is ID

I am trying to make a drop down menu that has the names of all the names of the elections (elect_title) in this table. I also need to pass whatever election the user chose to link with buttons with different functions. Say if I have a 'Status' button, I will choose a election from the drop down and click 'Status' button to see status (I will have a function called showStatus on this file that will handle this). Here's what i have so far: Nothing shows up




$sql=mysql_query("SELECT elect_title FROM Election_Table") or die("Cannot retrieve names from election table");



$result=mysql_query($sql);



print($result);

$options="";



while ($row=mysql_fetch_array($result)) {



  $id=$row["elect_title"];

  $options.="

how to make a direct link web site

hno — Mon, 16 Nov 2009 15:36:57 GMT

HI
i have made a web site. what I want to do is that I want to make a direct link from rapidshare . I mean to transfer a file from rapidshare to my site and give it a direct link address .

how can I do so ?

thanks

Passing data from one page into secure page page w/ sessions

joe524 — Mon, 16 Nov 2009 15:25:33 GMT

Hello,

This is my first post. I'm a web designer & SEO guy at a background check company.

This morning I was handed down this project that, well... I lack much experience with. Definitely not my area of expertise, but willing to give it a crack rather than my company hiring someone else that one day may take over job.

1. From our regular XHTML website pages, we want to include textboxes whereby client's enter the FIRST, LAST NAME, DOB and SSN.

2. This data is passed on to a secure webpage w/ cookie sessions (client is now on our secure server) and they go on to place order.

OBJECTIVE: From a marketing standpoint, it is much easier for potential clients to enter information directly at page they are viewing rather than "click here" (is an added step and an added click) By achieving this, they are now at a secure page with info already entered, they provide payment info and get results instantly.

Any advice is more than welcome as I have other projects to attend and cannot spend valuable time reading "php for dummies".

Is PHP the best solution or does anyone have any better recommendations?

Thanks,

Julian

insert images from a webform

applebiz89 — Mon, 16 Nov 2009 15:21:36 GMT

I have a webform for users of the site to insert information about theirself and then an image. However I don't want to save the image into the database as it will slow everything down...is there a way to save the image to my hardrive then create a link in the mySQL database to this image? How can I get the form to save the picture to my hardrive in the first place...thanks.

dynamic forms with mysql and use of arrays for input

sleign — Mon, 16 Nov 2009 12:21:35 GMT

I've been working at this most of the day, trying to figure out how I can accomplish this sort of form, even looking through countless sites for anything vaguely close to what I'm trying to do for help on logic or syntax behind this (to little to no avail, of course lol). It's a little over my head in terms of sophistication. I've done dynamic forms before, but not like this.

What I'm trying to do is this:
A user needs to update points for attendance in 3 different categories for all people registered to the site - all at once.

There are a total of 3 categories.
I can do the queries fine enough to
(a.) get the total amount of rows and
(b.) the names of all people registered within the site

...and whatever else I might need - that's pretty easy stuff for me these days.

when I do the second query (b) the form will then display the 3 categories for that person like such:
person's Name > cat1 (input text field) > cat2 (input text field) > cat3 (input text field)

and so on and so forth until all users have been populated in this form with each of the 3 categories and input text fields next to their name.

the user would then enter an integer x-xxx (default set to 0) for all users / categories and hit one submit button which would then go to the processing page, which would update the database by adding the new values to the old ones for all fields.

so if, say 5 people were registered, then all 15 values would be submitted at the same time and then updated into the db under their corresponding columns at the same time.

I'm trying to do this with 4 arrays parallel to each other that store all values so that I can put them in one or a few sessions, and transfer all the values at once to the next page.

I've done something similar to this, but not using parallel arrays and without throwing in retrieved data from a db, but since I am - the only way I'm familiar with outputting data from a database for inclusion in a form would be using a while loop like:

while($data = mysql_fetch_array($query))

I've never attempted to output information from a db, and retrieve 1 or more arrays worth of data on the same form before, and I'm finding out very quickly why - its very frustrating...

furthermore, I'm not exactly sure how I would be able to implement arrays into the form dynamically, so that it can store all the values of however many people for all 3 categories before $_POST happens, so the arrays of data are not lost.

Can anyone point me in the right direction, or give me a rough sketch of how this should work? Normally I try to post what code I have, but none of my code works, except for the layout itself including the names, and it's kind of chasing a train wreck at the moment, so I feel this is sort of a mute point to do so.

any help is appreciated.

Creating a variable from an image upload form

catfleamassacre — Mon, 16 Nov 2009 11:55:51 GMT

I am fairly new to image uploaders (worked in animation for a long time).

I have an image upload form that works fine. The image uploads and redirects to another PHP page (imageupload_file.php) that confirms the image uploaded and gives you the name of the image and size on the server.

By clicking a link you go through to another page (galleryinsert.php) where you can add the image details to, such as page to be shown on, section on the page.

The only thing I cant do is get the image name to echo in the second details page. At the moment I have to copy and paste the name into galleryinsert.php and this is quite messy.

Is there a way I can save the image name as a variable and pass it through to the last form so I dont need to copy/paste it in?

Do you need to see the code?

Any help would be appreciated.

php/mysql multiple tables query help :(

julzk — Mon, 16 Nov 2009 11:36:12 GMT

I have an SQL Query question that I'd like help with if possible :)

I have two tables "tbl_jobs" and "tbl_jobs_done"

Here are the fields for both tables:

tbl_jobs
-jobs_id
-jobs_description
-jobs_datestart
-jobs_dateend
-jobs_datetype
-jobs_user
-jobs_updateuser

tbl_jobs_done
-jobs_done_id
-jobs_id
-jobs_date
-jobs_comment
-jobs_datedone
-jobs_timedone
-jobs_user

How this works is, I have an SQL Query which goes something like this:

$result = mysql_query("SELECT * FROM tbl_jobs WHERE jobs_datetype IN('$everyday', '$dayname', '$wtype') ORDER BY jobs_id ASC");

Now, someone ticks a checkbox and clicks on the complete button which submits the completed job data and inserts it into tbl_jobs_done.

How I want it to display is, it will by default check the jobs_id field from both tables to see if it has been done and by current date yyyy-mm-dd within the jobs_date field in tbl_jobs_done (using something like $dayname=date('l');). If it has not been completed, it will show my tickbox next to each displayed item from tbl_jobs, however if it has been completed and can see it's been done within the tbl_jobs_done table, then it'll just return the the same information from the first tbl_jobs, except instead of showing my field with the tickbox, it's going to show the jobs_user field from the tbl_jobs_done.

Is there anyway I can do this? Let it be within PHP else/if statements or the SQL query itself?

How to insert unicode character in database from xls file

Lalita_shah — Mon, 16 Nov 2009 11:26:11 GMT

I am trying to insert unicode characters from excel file into phpmyadmin database through coding,but database is not accepting unicode characters and even date type,please help me if anyone having idea abt this,even i tried by converting .xls to csv format but .csv file does not support unicode characters and not even date,English characters are working but not unicode...please help me for this...

need php script to upload excelsheet data into mysql

sam023 — Mon, 16 Nov 2009 11:21:57 GMT

i m searching for it from last two hrs. but didnt find anything useful..
i hope some reply to this topic..!!!

i just need a php script to upload excelsheet data into mysql table..!!

thanks

Add username to URL

Olsi009 — Mon, 16 Nov 2009 10:49:39 GMT

Hey people,
I am doing a project in web development and I wanted to make a system where users can sign up and login to their profiles and have custom URLs like facebook or twitter (www.mysite.com/UserName).
I dont wanna create a folder for every user on the system cuz that's a stupid thing to do :)

Hope you can help :)
thnx in advance

Contact us form to email

motieno — Mon, 16 Nov 2009 09:56:17 GMT

Hi,

Could someone assist me with this code. It gives me an error message whenever i press the submit button.

It gives me this error message
We are very sorry, but there were error(s) found with the form your submitted.
These errors appear below.
Please go back and fix these errors

Here are the forms

This is the contacts.php






"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">







        Jiomoe Foundation

        

        

        



        

        



        

        

        

        





 







         

                
                        include("logo.php");

                        ?>

                        


                

        

                                

                                                


class="">Home


                                                About 



Us


                                                Our 



Programs


                                                


class="">Membership


                                                


class="">Careers


                                                


class="active">Contacts


                                


                






         

                

                        

                        First Name:*


                           


                           


                         Last Name:*


                           


                           




                           Email:*


                           


                           


                           Message:*


                           

                           


                           


                           

                        


                


        




 

        

                

                        Jiomoe Foundation is a Volunteer, Community based Youth 



initiative

                        founded by the Kenyan Youth to eradicate poverty,

                        create employment opportunities, market and empower the Youth.


                        


                        

                                Information


                                        Founded
 2008

                        


                        

                                Links


                                        


href="http://www.jiomoeclub.net">www.jiomoeclub.net


                                        


href="http://www.jamhurisoftware.com">www.jamhurisoftware


                                        


href="http://www.fashtechcomputers.com">www.fashtechcomputers


                        
 

        






 



 

         

                

                        Contact details

                


                


                Email: info@jiomoe.org


                Tel: +254723169577


                +254734297258

                

                        Find Us

                


                        


href="http://www.facebook.com/groups.php?ref=sb#/group.php?gid=98375464670">


src="./images/facebook_badge.gif" border="0"/>

        




                
                include("./include/footer.php");

                ?>

This is the mailer.php


if(isset($_POST['email'])) {

        

        // EDIT THE 2 LINES BELOW AS REQUIRED

        $email_to = "info@fashtechcomputers.com, matotien@gmail.com";

        $email_subject = "INQUIRIES";

        

        

        function died($error) {

                // your error code can go here

                echo "We are very sorry, but there were error(s) found with the form your submitted. ";

                echo "These errors appear below.

";

                echo $error."

";

                echo "Please go back and fix these errors.

";

                die();

        }

        

        // validation expected data exists

        if(!isset($_POST['first_name']) ||

                !isset($_POST['last_name']) ||

                !isset($_POST['email']) ||

                !isset($_POST['telephone']) ||

                !isset($_POST['comments'])) {

                died('We are sorry, but there appears to be a problem with the form your submitted.');                

        }

        

        $first_name = $_POST['first_name']; // required

        $last_name = $_POST['last_name']; // required

        $email_from = $_POST['email']; // required

        $telephone = $_POST['telephone']; // not required

        $comments = $_POST['comments']; // required

        

        $error_message = "";

        $email_exp = "^[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$";

  if(!eregi($email_exp,$email_from)) {

          $error_message .= 'The Email Address you entered does not appear to be valid.
';

  }

        $string_exp = "^[a-z .'-]+$";

  if(!eregi($string_exp,$first_name)) {

          $error_message .= 'The First Name you entered does not appear to be valid.
';

  }

  if(!eregi($string_exp,$last_name)) {

          $error_message .= 'The Last Name you entered does not appear to be valid.
';

  }

  if(strlen($comments) < 2) {

          $error_message .= 'The Comments you entered do not appear to be valid.
';

  }

  $string_exp = "^[0-9 .-]+$";

  if(!eregi($string_exp,$telephone)) {

          $error_message .= 'The Telphone Number you entered does not appear to be valid.
';

  }

  if(strlen($error_message) > 0) {

          died($error_message);

  }

        $email_message = "Form details below.\n\n";

        

        function clean_string($string) {

          $bad = array("content-type","bcc:","to:","cc:","href");

          return str_replace($bad,"",$string);

        }

        

        $email_message .= "First Name: ".clean_string($first_name)."\n";

        $email_message .= "Last Name: ".clean_string($last_name)."\n";

        $email_message .= "Email: ".clean_string($email_from)."\n";

        $email_message .= "Telephone: ".clean_string($telephone)."\n";

        $email_message .= "Comments: ".clean_string($comments)."\n";

        

        

// create email headers

$headers = 'From: '.$email_from."\r\n".

'Reply-To: '.$email_from."\r\n" .

'X-Mailer: PHP/' . phpversion();

@mail($email_to, $email_subject, $email_message, $headers);  

?>



















        Jiomoe Foundation

        

        

        



        

        



        

        

        

        





 







         

                
                        include("logo.php");

                        ?>

                        


                

        

                                

                                                Home


                                                About Us


                                                Our Programs


                                                Membership


                                                Careers


                                                Contacts


                                


                






         

                



Your message was sent




Your message was successfully sent!

Thank you for contacting us, we will reply

to your inquiry as soon as possible!






        


        




 

        

                

                        Jiomoe Foundation is a Volunteer, Community based Youth initiative

                        founded by the Kenyan Youth to eradicate poverty,

                        create employment opportunities, market and empower the Youth.


                        


                        

                                Information


                                        Founded
 2008

                        


                        

                                Links


                                        www.jiomoeclub.net


                                        www.jamhurisoftware


                                        www.fashtechcomputers


                        
 

        






 



 

         

                

                        Advertisements

                


                

                        Find Us

                


                        

        




                
                include("./include/footer.php");

                ?>

 



 








}

?>

Help with stored procedure

kbramprasath — Mon, 16 Nov 2009 09:56:14 GMT


include("config.php");



// $sql="delete from UsersR where  UsersID='$UsersID'";

$sql="CALL DeleteUsers('$_POST[UsersID]')";



if (!mysql_query($sql,$con))

  {

  die('Error: ' . mysql_error());

  }

echo "1 record deleted";





mysql_close($con);

header("location:delete.php");

?>

it is my procedur

DROP PROCEDURE IF EXISTS `UsersR_DELETE_byPK` 

GO



CREATE PROCEDURE UsersR_DELETE_byPK

   (

        IN  UsersID             INT(11) 

)        

BEGIN 



   DELETE FROM UsersR   

                     

           WHERE  UsersID=UsersID;

                             

        

  END

but i give delete means all row delete please responce immeditly

Problems with Drop downs

iraberyl — Mon, 16 Nov 2009 08:25:52 GMT

Hi,
actually i've posted from the wrong thread and i apologize for that.
anyway, let me post my problem and it goes like this. we've successfully created drop down menus that is connected to our database. we have 5 fields to display, each field contains different data [(ex. first field contains - milk, soap, sardines, noodles and coffee),(second field contains - powdered milk, condensed milk, evap milk, spanish sardines, tomato sardines, laundry soap, bath soap, instant noodles, quick cook noodles, instant coffee and decafinated coffee)]. so its like when you choose milk on your first drop down, the second drop down should contain everything concerning milk, thus it should only show powdered milk, condensed milk and evap milk. Please help me... Thanks in advance.

credit card validation with date, cvv??

Aamit — Mon, 16 Nov 2009 07:45:28 GMT

Hi, i am trying to validate credit card.

I want to validate credit card

1> name on card
2> card number
3> card type (visa,mastercard... etc)
4> cvv
5> expiry date

I seared on google but most of links gives information to validate card according to number.

How to do this? any sample link how to do this? or script ?

drop down menu

elanorejoseph — Mon, 16 Nov 2009 04:54:51 GMT

Hi how can i make a drop down menu usibg java script.... please help its urgent.

Automatic Email to selected persons for alerts

ayesha789 — Mon, 16 Nov 2009 04:42:39 GMT

Hi, all this is my file expire_show.php
it shows expiry of those agreements which will expire with in 90 days from current date.
Users have to login to their accounts for viewing these expiry alerts.
but they require these alerts on their email.
1. how i can format these for email?
2 how I can send automatic email daily to selected persons?


$con = mysql_connect("localhost","root","root");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }





mysql_select_db("onm", $con);





$result = mysql_query("SELECT * FROM lease_center WHERE (current_date() >= (LAPeriodEnd - INTERVAL 90 DAY)) AND (current_date() <= (LAPeriodEnd - INTERVAL 0 DAY)) ");

while($row = mysql_fetch_array($result))

  {

  echo "



";

  echo "";

  echo "";

  echo "";

    echo "";

  echo "";

                                                


        

        

        echo "";

  echo "";

  echo "";

    echo "";

        

        echo "";

  echo "";

  echo "";

    echo "";

        

        

        

  }

echo "



SiteId " . $row['SiteId'] . "



  LAPeriodEnd " .date("j-F-Y",strtotime($row['LAPeriodEnd'])). "


";





mysql_close($con);







?>

SiteId	" . $row['SiteId'] . "
LAPeriodEnd	" .date("j-F-Y",strtotime($row['LAPeriodEnd'])). "

Forum features

otherdummy — Mon, 16 Nov 2009 03:30:35 GMT

My friend is writing a simple forum,
In this forum there is 1 MySQL database with 4 tables(forumsections, members, posts, replies)
The question:
He wants to notify by mail those members who have posted new posts, when anybody replies to their post. (like in this forum). Now he has a checkbox in the post form(when posting a new post member has choice to have notifications by mail, if he checks the checkbox notifications will be sent him by mail otherwise not(by default checkbox is checked)). How to code this idea in PHP.
Thanks in advance

Safari Scrolls to bottom of page

jonow — Mon, 16 Nov 2009 02:09:07 GMT

On my website whenever i load it in Safari (both on Windows and Mac computers) it scrolls to the bottom of the page. It does not do it in any other browser.

background image in table different in IE and Firefox

belper — Sun, 15 Nov 2009 23:35:03 GMT

Hello,

I have this php code :

   

//echo $i."
end-".$end."-start-".$start;

               echo "

        
";

                echo "$listDatetxt: ";

        $lines[$i]->showDate();

        echo "
$listnametxt: ";

        $lines[$i]->showFrom();

        echo "

$listMessagetxt: ";

        $lines[$i]->showMessage();

        echo "

";

}



echo "";

This is the problem :

In Firefox the table is shown correctly, except that text is not centered
In IE text is centered but the background images (topbar and footbar) seam to be ‘repeated’ in the in the imagebar.
Sizes of my images :
topbar.gif 700x45
footbar.gif 700x30
So obviously I am doing something wrong (newbee !)
Someone can help me ?

Thanks

Upcoming Events script (Free or Commercial)...?

adelshehri — Sun, 15 Nov 2009 18:21:02 GMT

Hello All,

am looking for an events script like (Upcoming.yahoo.com)...

I found many but!! I want the same functions of upcoming.yahoo.com As much as possible ...

Commercial or Free ....

It will be used by some charity organizations. Please help

Noob question, many index.php?Page=2, how?

Silvershaft — Sun, 15 Nov 2009 18:03:04 GMT

Hey all! I started to code php yesterday in need to create good dynamic websites to our server project for one game. I got c++ expirience of like 7 months soon, so the syntax is known to me excluding some differences. I've wondered how do I make a page like when you go to index page and click link from there it goes to page like index.php?Page=2 not to other php file. Did I says it enough clear. I really don't know with what word to google for it.

Using A List Box in If Statement

Byrne86 — Sun, 15 Nov 2009 17:00:14 GMT

Hi, I am using 2 list boxes with 4 values in each. I want to create an action when a button is pressed on the form which will be something like this:

If(value of list box1 is 1 and value of list box2 is 1)
{
total = total + 1;
}
elseif(value of listbox1 is 1 and value of listbox2 is 2)
{
total = total + 2;
}... and so on

anyway thats what I want to happen, but Iv tried a few things, and none have worked. All I want to do is check the value of my list boxes then increase a variable by a certain amount. I have declared my total variable but I cant get it to work, if anyone has a solution it would be great.

Cheers

I need a code to prevent SEOQuake on my sites

mexabet — Sun, 15 Nov 2009 15:45:49 GMT

Please, I need a code that is capable of preventing SEOQuake from loading on my websites, even if a user has installed the plug-in.

For example, Google, Yahoo and Bing implements such feature. I just don't want it to load whenever anybody visits my sites.

How to redirect page while showing the seconds...!

rahul8590 — Sun, 15 Nov 2009 14:57:40 GMT

In many of the forums i have observed that , we can re direct the page like

thanks for logging in u will be redirected in 5 secs

and eventually the 5 secs decreases to 0 and the page gets redirected.

In my php code i could redirect the page simply through



header("Location: http://www.MyWebPage.com/");

How do i show the seconds and finally redirect.

xampp

arushibafna — Sun, 15 Nov 2009 13:56:22 GMT

hello
i am new to xampp . and making a project using php & mysql.
whenever my php files run, its doesn't show any changes in my database. for eg. ,if i have entered certain values on my html page and through my php page ,the values is getting inserted into my database, it just displays the blank row without the values.
can anyone tell me the correct code about how to insert the values in php.

please help: moving a new sidebar from right to left

tobisan — Sun, 15 Nov 2009 12:52:09 GMT

Hi there,
I've just managed to add a new widgitized sidebar to my site, but no matter what I tried, it keeps showing up bellow sidebar 1. any thoughts?
heres the style.css:

/* begin LayoutCell */
.contentLayout .sidebar1
{
position: relative;
margin: 0;
padding: 0;
border: 0;
float: left;
overflow: hidden;
width: 218px;
}
/* end LayoutCell */

/* begin LayoutCell */
.contentLayout .content
{
position: relative;
margin: 0;
padding: 0;
border: 0;
float: left;
overflow: hidden;
width: 655px;
}
.contentLayout .content-wide
{
position: relative;
margin: 0;
padding: 0;
border: 0;
float: left;
overflow: hidden;
width: 873px;
}
/* end LayoutCell */

/* begin LayoutCell */
.contentLayout .sidebar2
{
position: relative;
margin-right: 15px;
padding: 0;
border: 0;
float: right;
overflow: hidden;
width: 500px;
}
/* end LayoutCell */

http:knows-dive.com

Combining two different rows from one table

Kruptein — Sun, 15 Nov 2009 11:13:40 GMT

I have this table(building_lvl):

lvl | building_id | region_id

And I want to get the region_id for which building_id=3 has lvl 2 and building_id=2 has lvl 5

SELECT * FROM building_lvl INNER JOIN regions ON regions.region_id = building_lvl.region_id WHERE ((building_lvl.building_id='3') && (building_lvl.lvl > 1)) && ((building_lvl.building_id='2') && (building_lvl.lvl > 4)) && (regions.nation_id = '17');

but this gives an empty set, why?
(and I'm sure there is a region_id which has this conditions)

Make
Model
Year
Price