Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: How do I implement a simple "Post Messages and Announcements" using PHP and MySql?

You dont need phpbb for this. Save the user's messages in a table.. You can have 2 tables.. users and messages. user_id -> foreign key for messages. Whenever the user saves a message, save it in messages table which references the user_id of that user. List all the messages of that user for viewing.. select message_details from messages where user_id='user-id-of-that-user'; To search for a message, you can use select message_details from messages where message_details like '%-search-string-%' && user_id='user-id'; Since its a school project, I dont think you need more than that!

Cheers,
Naveen

Web Development mysql php phpbb
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: How can i pick date in PHP

Yep. Just include that js and call the function wherever you want. Did you even click the links that I gave you ? :S

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Need to make Inter-Module Compatibility

umm..I didn't get what you really want..But as per my understanding, it can be done using sql. Say a user adds a level module. Have a column in the table with name level_module. If the user has installed a level module, set it to 1. You can then check if level_module is 1 for that particular user.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: How can i pick date in PHP

Check this or this..

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: mysql developer software

mysql yog is really good !

Databases mysql
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Help me please.

Get a good editor.Find all the matching braces and check if all the open braces are closed properly.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: echo data

Oh, Well, first of all, you are not fetching the record from the table. What you are doing is, checking if a row exists in the table with the provided details. If yes, then print the "input values". But you should do something like this.

<?php
.....blah blah blah.....
$query="select * from table where firstname='$fname' && lastname='$lastname' && date_of_birth='$dob'";
$result=mysql_query($query);
$row=mysql_fetch_array($result); //if you are sure that the query returns only 1 row. If you are not sure, then use the while loop. while($row=mysql_fetch_array($result)){
}
//$row will have all the information. You can then use the columnname as the index.
echo "Welcome". $row['fname']."  ".$row['lastname']." Your date of birth is". $row['date_of_birth']." and your registration number is ". $row['reg_num'];

mysql_num_rows returns only the number of rows returned by that query.
:) Hope it helps.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: echo data

Thats because, reg_num variable is null. Where is reg_num coming from ? From a previous page ? You can use print_r($_POST) for debugging purpose. This will print all the variables that are posted from page1 to page2.(PS. You should write print_r($_POST); in page 2.) Try that and tell me if you are posting reg_num !

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Problems on Hyperlink

You can do that using css.

<html>
<body>
<a href="http://www.example.com" style="text-decoration: none;">click here</a>
</body>
</html>

To apply the same style to all hyperlinks, use this.

<html>
<head>
<style type="text/css">
a {
text-decoration: none; 
}
</style>
</head>
<body>
<a href="http://www.example.com">Click here</a>
</body>
</html>

This will take off the underline from all a href links.

Web Development asp.net perl
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: md5 help/mysql help

ok i cant seem to log in with a regualr password. this code works fine without md5 but it doesnt work when i use md5. yes i've already connected and selected database.
$username = mysql_real_escape_string($_POST); //so someone cant sql inject.

$ = mysql_real_escape_string($_POST['username']);
$password = md5($_POST['password']);
$result = mysql_query("SELECT * FROM registered_members WHERE username=\"$username\"");
$row = mysql_fetch_assoc($result); // note assoc
if ($row['password'] == $password) {
echo "Login successful <br />";
echo "Welcome $username <br />";
include("adminstuff.php"); // shows the user stuff if the user login is successfull
} else {
die ('Login Failed.');
}

Umm.. Instead of checking the password for that username(by fetching the password from the table and all), you can simplify this step by checking the password in your query !

$query="select * from registered_members where username='$username' && password='$password'";
$result=mysql_query($query);
if(mysql_num_rows($result) > 0 ){
  echo "Valid user";
} else {
   echo "Invalid User";
}
Web Development mysql php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Neural Network training...

@[omega], Sorry. This is the first time I am seeing something like this! hmm..maybe someone who knows bout it should answer !

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Form display settings

You need to write style for that (using css ie.,) Check this out.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Keeping line breaks when pulling text from a database

You are the man nav33n! Can I rent you please ;)

:P lol..

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Using Headers and Sessions Continued...

you r right, but not completely. We should not print anything befor header. If someone print then it will not redirect.

Yep. Thats what I said.

When header will use to redirect the page, printing anything after the header, what will happen?

Nothing. Since we are calling the header function, the page will be redirected to another page ignoring anything after the header function.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Keeping line breaks when pulling text from a database

nl2br function!

Web Development php
Venom Rush commented: Helpful response as always +1
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Neural Network training...

Wow! what are you talking about ? Sorry for my ignorance, but what are neurons ? learning rate ? momentum ?

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Store checkbox value in database

You make a good point, but would that store 'checked' or 'unchecked' in the database??

No. It will store the value of the checkbox. Eg.

<?php
print "<pre>";
print_r($_POST);
print "</pre>";
?>
<form method="POST" action="test.php">
<input type="checkbox" name="check[]" value="100">100 <br />
<input type="checkbox" name="check[]" value="200">200 <br />
<input type="checkbox" name="check[]" value="300">300 <br />
<input type="submit" name="submit" value="submit">
</form>

Cheers,
Naveen

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Bonjour à tous

umm.. Welcome to Daniweb ! :-/

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Store checkbox value in database

Hopefully this will give you an idea that you can adapt into your code, if not then ask again

<?php
if(isset($_POST['box01']))
{
$box01 = 1;
}
else
{
$box01=0;
}
if(isset($_POST['box02']))
{
$box02=1;
}
else
{
$box02=0;
}

$insert=mysql_query("
INSERT INTO tablename('field01', 'field02')
VALUES ('" . $box01 . "', '" . $box02 . "'");

Instead of $box01=1 and $box01=0, you can assign the value of the checkbox itself! $box01=$_POST['box01']; And this isn't useful if you have, say, 10 checkboxes. The best thing would be to have an array of checkboxes !

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Store checkbox value in database

Can you show us your code ?

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: hai...i'm new in this field

Welcome to Daniweb!

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Confirmation popup

Lol.. great idea though !

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Confirmation popup

hmm.. I would use confirm box too. But if you want to have custom buttons, thats the only way, a popup.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: smtp mail in php

@vipin_php, Next time, please put your code in [/code ] tags.[code=php ] [/code ] tags.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Confirmation popup

Yep. Or put the above code in a javascript function, and call that function with onclick event.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Confirmation popup

Well, I write my own page with 2 buttons to do required operation. Then I call that page using the following.

window.open(url,"_blank","toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=yes, resizable=no, copyhistory=no, width="300", height="200")

Here, url is the page that I want as popup.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: My Introduction

Hi sir...I am online...can i ask few doubts to u...

Hey, dont call me sir. I am Naveen. And you can post your doubts here. (if its java related.)

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Group records

you can arrange your output in any format you want.

<?php
//connection
//select db
$query="select * from product_listing group by product_category";
$result=mysql_query($query);
echo "<table>";
while($row=mysql_fetch_array($result)){
   echo "<tr><td>".$row['product_name']."</td><td>".$row['product_id']."</td></tr>";
}
echo "</table>";
?>

This will put the values in a table of 2 columns. I don't understand what the code in your other thread do.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: format for option statment in php...

:) awesome!

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: format for option statment in php...

also how am i going to modify my whole login script to use tihs now? I have it verifying the first name and then the last name... Then i use that and create a session variable to use later on so i know whos voting.

how can i do that now?

Don't you have a separate username/loginname field ? Umm.. My suggestion is to change the table structure itself. But if you want to use the same table, then you can ask the user to enter his firstname and password, and then compare it with the values in the table for that first name and password.

Web Development php
dani190 commented: awesome help yet again! Well done +1
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: format for option statment in php...

ok it works but now the firstname and lastname come up all bunched into 1 word, hows a space added there.

Add a white space in the concat function.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Hello everybody.

Welcome to Daniweb Ken.. Please post your question in hardware forum! :)

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Hello Out There!!!

Hello Brian ! Welcome to Daniweb!

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: format for option statment in php...

try it out ! :)

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: format for option statment in php...

Well, If you dont have an id field, what/how do you plan to update the table ? because, there can be people with same first name and same last name. You need to have an id field. Anyway, you can make use of concat function in mysql to join those 2 fields.
Eg. select concat(firstname,lastname) as name from table;

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Group records

You can do that by using group by clause. select * from product_listing group by product_category; I dont know what you mean by >>still be able to see the table layout in dreamweaver << :S

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: format for option statment in php...

I guess you didn't see my example ?

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: PHP Mysql "Where" statement 
....
where id='"$_POST[id]"'"; // << $ sign.
Web Development mysql php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: format for option statment in php...

;)

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: mysql DELETE not working

This thread is more than an year old! :)

Web Development mysql php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Using Headers and Sessions Continued...

never print or echo anything after using header.

After using header ? Are you sure ? You can print anything you want after calling header function. You shouldn't print anything before header. :)

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: help

This wouldn't work since you are adding $_SESSION=$myusername; even without checking if hes a valid user. Secondly, $_SESSION will be null and not 0.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: help

when the user logs in, put his username to the session. Eg.
//After logging in, add his name to the session. $_SESSION['user']=$username; Then in each page, check if $_SESSION is not null. If its null, then use header function to redirect the user back to the first page. If its not null, then continue with normal operations.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Hello

Welcome to Daniweb!

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: A big Hello from Wazzam (Warwick)

Welcome!

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Hi all!!!

Welcome to Daniweb Pedro!

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Confirmation popup

Nope. You should write your own popup for that (with 2 buttons ie.,)

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: PHP Doubts

I dont know what are the fields you have in your table. So give me more details. Can you be more specific in what do you want exactly ?

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: PHP Doubts

Removing expired jobs can be done by writing a simple query. When a webmaster logs in, do a check if that job is valid(if posted_date > DATE_SUB(CURDATE() - INTERVAL X DAYS)) or if its expired (if posted_date < DATE_SUB(CURDATE() - INTERVAL X DAYS)). If its expired, remove them.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: PHP Doubts

What does a webmaster module do ?

Web Development php