Member Avatar for fobos
fobos 19 Posting Whiz in Training
Re: update links are not shown inside the table

hi...........
my update code is working correcty.... .....but i want update links in front of every record of table ... plz tell me how it is possible...........
thanx for last reply..... m pretty new in php

[file name=updaterecord.php]

<?

$con=mysql_connect('localhost','root','root');
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 mysql_select_db("test", $con);

// ***** This part will process when you Click on "Submit" button *****
// Check, if you clicked "Submit" button
if($_POST['Submit']){

// Get parameters from form.
$FirstName=$_POST['FirstName'];
$LastName=$_POST['LastName'];
$Age=$_POST['Age'];
//$tel=$_POST['tel'];

// Do update statement.
mysql_query("update student set FirstName='$FirstName', LastName='$LastName', Age='$Age' where FirstName='$FirstName'");

// Re-direct this page to select.php.
header("location:select1.php");
exit;
}
$FirstName=$_GET['FirstName'];

// Get records in all columns from table where column id equal in $id and put it in $result.
$result=mysql_query("select * from student where FirstName='$FirstName'");

// Split records in $result by table rows and put them in $row.
$row=mysql_fetch_assoc($result);

// Close database connection.
mysql_close($con);
?>

<!-- END OF PHP CODES AND START HTML TAGS -->

<html>
<body>
<!-- set this form to POST method and target this form to itself ($PHP_SELF;)-->
<form  name="form1" method="post" action="<? echo $PHP_SELF; ?>">
<p>FirstName :
<input name="FirstName" type="text"  value="<? echo $row['FirstName']; ?>"/>
<br />
Last Name :
<!-- name of this text field is "email" -->
<input name="LastName" type="text"  value="<? echo $row['LastName']; ?>"/>
<br />
Age :
<!-- name of this text field is "tel" -->
<input name="Age" type="text"  value="<? echo $row['Age']; ?>"/>
</p>
<p>
<input type="submit" name="Submit" value="Submit" />
</p>
</form>
</body>
</html>
//select.php

<html>
<body bgcolor="pink">
<?
$con=mysql_connect("localhost","root","root");
if …
Web Development php
Member Avatar for fobos
fobos 19 Posting Whiz in Training
PHP Mail Error...Help!!!!!

hello all who read,
im here to write this forum, because i have exhausted all means (to my knowledge) of figuring this out. I used the same settings with another outlook and it worked. Basically i have a form and when the user hits "submit", the form gets directed to a submission page where the form get inputed into mysql and all of the inputs get mailed out to me to let me know that someone submitted something. I am using Windows XP 32 and XAMPP. Here is what i have done so far
1) Changed in php.ini and php5.ini SMTP and smpt_port to outlook server address and port number
2) Pinged the outlook server with success
3) On submission page here is my code

<?php
ini_set("SMTP","outlook.address");
ini_set("smtp_port","25");
$to = "my email address on outlook";
$subject "email";
//Some Code....

$send = mail($to, $subject)
if($send) {
print "thanks"
} else {
print "sorry there was an error"
}
?>

Can someone plz let me know what i am doing wrong??

Web Development php
Member Avatar for fobos
fobos 19 Posting Whiz in Training
No USB's working on login screen

Hi,
I have just installed a clean version on Windows XP 64-bit on my computer. Every worked fine, i logged in and no problems. I restarted the computer just to make sure everything is good before i start installing my drivers. The first thing i installed was my chipset drivers. It prompted me to restart, so i did. Once it restarted, everything was fine, i selected a hardware profile then i got to the login screen. Once i get to the login screen, by mouse and keyboard do not work. I restarted again, selected hardware profile, go to login scrren, and the problem was still there. What could of happened?

Microsoft Windows windows-nt-2000-xp
Member Avatar for fobos
fobos 19 Posting Whiz in Training
Re: navicat

ryan311,
First of all you dont create tables in navicat, you create mysql tables using navicat. Well im gonna break this down for you:

1. Open a new excell document.
2. Next open the document and create the row names for your database. Ex. 1A = id, 1B = Name.
3. Label the tab to what your table name will be. *no spaces in name*
4.If you want fill in any information that you want. so make 3 entries. label the id row 1, 2, 3 and the name row jim, jake , jill.
5. Save the document as you like
6. Open navicat, and make sure that it is connected to the mysql database.
7. Create a new database *no spaces in name*
8. Click on the database and then click on "import wizard"
9. Select Excel file. Click Next
10. Upload excel file that you just created, then put check marks next to the ones that you want to import. Click Next
11. Step 4 is just additional things. Click Next
12. Next will be the source table and the target tabel. Leave this alone. Click Next
13. Next, just put in the correct types for each field. Ex id = int. the "length" just specifies the value such as longtext = 50000 characters. Click Next
14. Import mode: append will be selected. Click Next.
15. Then click start.
16. Open …

Databases mysql
Member Avatar for fobos
fobos 19 Posting Whiz in Training
Re: mail shows in inbox,anonmyous
Web Development php
Member Avatar for fobos
fobos 19 Posting Whiz in Training
Re: mail shows in inbox,anonmyous

ahmadjhoney,
Here is a link to a php e-mail form.

instead of $header="from: dummy@myweb.com";
try:
$from = "dummy@myweb.com";
$headers = "From: $from";
mail($to,$subject,$message,$headers);

Web Development php