Click here to Skip to main content
14,766,679 members

Comments by Member 10496298 (Top 6 by date)

Member 10496298 21-May-14 0:01am View
   
Thanks dear friend but I am searching for pdf to excel that too without using external library. i.e; to do it with pure php coding.
Member 10496298 16-May-14 13:47pm View
   
Thanx alot... :)
Member 10496298 16-May-14 2:25am View
   
I tried putting your query in my code but as I am new to this all things I dnt understand where exactly I am heading. Thanks for Help
Member 10496298 16-May-14 2:23am View
   
Hey thanks a lot. Actually I am new to coding and more to add I have never ever worked with database. I am glad you helped. With this query I am trying to program in PHP as I dnt know how to test this query :(
I am pasting my code below; can you please help me with this.

ini_set('max_execution_time', 300);
require_once('connection.php');

$sql1 = "SELECT DISTINCT `start_date` FROM `urlwise_analysis_record` ORDER BY `start_date`";
$sql2 = "SELECT `prof_id` FROM `url_record` ORDER BY `url_name`";


$result1 = mysql_query($sql1);
while($row1 = mysql_fetch_array($result1))
{
$week_data[] = $row1['start_date'];
}
var_dump($week_data);

$result2 = mysql_query($sql2);
while($row2 = mysql_fetch_array($result2))
{
$url_data[] = $row2['prof_id'];
}
var_dump($url_data);

foreach($url_data as $urls)
{
for ($j=0; $j";
for ($row=0; $row<td>".$url_data[$row]."</td>";
for ($col=0; $col".$records[$urls[$row]][$week_data[$col]]."</td>";
}
echo "</tr>";
}
echo "</table>";
?>

Sorry for the inconvenience I am creating for you.
Member 10496298 15-May-14 11:19am View
   
Actually I wanted to use multidimensional array; but I dnt have much knowlege of it. I have written following code which is not giving me proper output and I dnt understand the problem.

";
for ($row=0; $row<count($url_data); $row++)
="" {
="" echo="" "&lt;tr=""><td>".$url_data[$row]."</td>";
for ($col=0; $col<count($records[$url_data[$row]]); $col++)
="" {
="" echo="" "&lt;td="">".$records[$urls[$row]][$week_data[$col]]."</td>";
}
echo "</tr>";
}
echo "</table>";
?>
Member 10496298 15-May-14 11:15am View
   
Thanks friend, the issue with my proble is my data will increase day by day for each url which will than effect the processing speed. I am not sure if I can you PIVOT for this. how but multidimensional array?