Lowyat.NET: Latest topics by red_dream83

How to redirect back to our page

red_dream83 — Thu, 30 Jul 2009 12:15:02 +0800

my code

form page

CODE

process.php coding

CODE

<?php

$nama = $_POST['name'];
$umur = $_POST['age'];

mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());
$sql = "INSERT INTO test_table (name, age) VALUE ( '$name', '$age' )";
mysql_query($sql) or die(mysql_error());

?>

after this process i want to go back to my form page
please help me for redirect code. i did try header function but this error come out "Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\test\process.php:9) in C:\xampp\htdocs\test\process.php on line 19"

thanks in advance

SQL query to Array

red_dream83 — Thu, 23 Jul 2009 12:11:13 +0800

Hi all,

i want my SQL query output to be like this:

CODE

$doc = array (
1 => array ("id", "name", "pswd"),
array ("1", "abc", "123"),
array ("2", "def", "123"),
array ("3", "ghi", "123"),
array ("4", "jkl", "123")
);

i want this coding is looping. (for more line)

my query something like this:

CODE

mysql_select_db($database_myconnection, $myconnection);
$sql = "SELECT * FROM user ";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)){
$id[] = $row[$id];
$name[] = $row[$name];
$pswd[] = $row[$pswd];
}

in my mySQL (example)

CODE

id name pswd
1 abc 123
2 def 123
3 ghi 123
4 jkl 123

can anyone help me how?
thanks in advance

(this is for part of my coding for php to excel coding)

Need Sifus Help

red_dream83 — Mon, 01 Jun 2009 15:54:39 +0800

Hi,

I googling for an hour, but didn't found the solution for my doubt.

i got data,

for example:

name | age
john |20
peter | 23
sam | 22
ben | 21
karen | 22

my concern is:

what is the php code for query this data from mysql server to get the output like this:

$name = 'john,peter,sam,ben,karen';

$age = '20,23,22,21,22';

thanks in advance

Query in Query (need help)!

red_dream83 — Wed, 20 May 2009 10:51:52 +0800

I got a question to all php sifus here..

I got a table with many record.. the primary key is the no. but what i want to query is the duplicated field like name, to create a graph.
or any other solution?? my friend said we have to do query in query (make server degradation)

example data

no. name reports
1 A 01
2 B 02
3 B 03
4 C 04
5 A 05
6 A 06
7 A 07
8 C 08
9 B 09
10 D 10

how to query that data to get the count to create bar graph??

A = 4 reports
B = 3 reports
C = 2 reports
D = 1 report

something like this

appreciate to share your mind
thanks