|
The W3Schools have a page explaining how[^] to filter the data from a database using PHP, might be a good starting point 
I are Troll 
|
|
|
|
|
I'd achieve what I understand as the aim with code resembling the following:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
.style1 {
font-size: 24px;
font-weight: bold;
}
.hiddenTxt {
display: none;
}
</style>
<script type="text/javascript">
function byId(e){return document.getElementById(e)}
function doFind()
{
var table = byId("table1");
var row , x, y
var searchStr
searchStr = byId("serialInput").value
for (y=0; y<5; y++)
{
row = table.rows[y]
for (x=0; x<5; x++)
{
if (row.cells[x].innerHTML != searchStr)
row.cells[x].className = "hiddenTxt"
else
row.cells[x].className = ""
}
}
}
function doReset()
{
var table = byId("table1"), row , cell, x, y
for (y=0; y<5; y++)
{
row = table.rows[y]
for (x=0; x<5; x++)
{
cell = row.cells[x]
cell.className = ""
}
}
}
</script>
</head>
<body>
<table width="300" border="2" bordercolor="#333333" id="table1">
<caption>
<span class="style1">Serial Numbers</span>
</caption>
<tr>
<td>1234</td>
<td>5678</td>
<td>9012</td>
<td>3456</td>
<td>8901</td>
</tr>
<tr>
<td>abcd</td>
<td>efgh</td>
<td>ijkl</td>
<td>mnop</td>
<td>qrst</td>
</tr>
<tr>
<td>uvwx</td>
<td>yz</td>
<td>a</td>
<td>b</td>
<td>c</td>
</tr>
<tr>
<td>d</td>
<td>e</td>
<td>f</td>
<td>g</td>
<td>h</td>
</tr>
<tr>
<td>i</td>
<td>j</td>
<td>k</td>
<td>l</td>
<td>m</td>
</tr>
</table>
<p>Search for
<input type="text" id="serialInput" size="20" maxlength="4" value="1234"/>
<input type="button" id="findBtn" value="Find" onclick="doFind()"/>
<input type="button" id="findBtn2" value="Reset" onclick="doReset()"/>
</p>
</body>
</html>
|
|
|
|
|
hi everyone
i want to make a simple web crawler in ubuntu,
can anyone tell me how to start with and further,thanks in advance
|
|
|
|
|
Install wget[^] a command line tool. Or use the programming language of your choice, Python/Perl/C++/etc should offer HTTP libraries you can use. Or butterflies.
Hope it helps!
/M
|
|
|
|
|
How to copy web page using php? I tried this
But it is not working. Any Idea how to do this ?
|
|
|
|
|
It works for me. Check that the allow_url_fopen option is enabled and that you have permission to write to the output file. Manual page.[^]
It's also possible that the server you're running it on is firewalled to prevent it accessing the remote address, so I would check that you can get to it from the server using something like lynx.
|
|
|
|
|
Thanks for your help. it is working code but I am trying to copy all data. Open this link "http://nseindia.com/marketinfo/companyinfo/companysearch.jsp?cons=mll§ion=7" in your browser and then match the data with example.txt after that you can understand what i want to say.My question is how can i copy all data using php ? Thanks in advance.
|
|
|
|
|
I get exactly the same content if I save out the page as when I run the PHP script - a page with empty tables.
I see what the problem is though - the data is loaded using Javascript, so isn't present in the page at all. If all you want is the data, I'd recommend finding out how it gets pulled onto the browser and reading that instead.
|
|
|
|
|
Thanks for your help brother. I think i can't write code because i don't know programing very well.Do you know some one who can write this code for me and how much it will cost me ? Thanks in advance.
|
|
|
|
|
Ive been trying to send and receive emails for a gmail account and Im thinking I should just restart from scratch. Ive tried getting the url of each individual email by requesting Gmails atom feed (https://mail.google.com/mail/feed/atom[^])
but when I navigate to their url it just sends me to a login page. Does anyone know if you even can receive emails via the atom feed, or know of a gmail API? Or a better method than the atom feed?
|
|
|
|
|
|
|
I am brand new to PHP and i am trying to figure out how to get it to find all its dll. I have tired to modify the ini file telling it were to find the dll with the extension_dir command but still nothing.
When i went to uninstall and reinstall i came accross bigger problems with the dll, the code wouldnt compile.
All i am trying to do is set it up to connect to mySQL on my machine as well as DBase.
If anyone could give me any kind of information or maybe places were i could go look to find stuff out that would be much appreciated.
|
|
|
|
|
Better use XAMPP bundle which has php, mysql, apache and perl. Every will be ready in just on click install.
the document root will be htdocs inside xampp which will be the root folder of this install.
then open xamppcontrol.exe. start apache and mysql. open the browser. type http://localhost and select english. click phpmyadmin to create databases and tables. you can enable disable options in php.ini which will be present in the apache folder. and ... enjoy...
Today's Beautiful Moments are
Tomorrow's Beautiful Memories
|
|
|
|
|
|
what OS are you using?
There are a number of predefined builds that can save you the trouble of compiling it.
|
|
|
|
|
Hi all,
I have some data collected from database using PHP and now i want to export it to PDF.Is there any third party tool using which i can create the pdf file with any fonts,styles etc....
Thanks in advance.
|
|
|
|
|
|
I've experimented with FPDF, and it worked as expected.
|
|
|
|
|
hello every body
I want to join MS SQL with php
|
|
|
|
|
|
and use XAMPP bundle to install all in one pack.
Today's Beautiful Moments are
Tomorrow's Beautiful Memories
|
|
|
|
|
I'm new to PHP and I'm trying to build a simple library interface...
For that I need a html form that has a text input for "keyword" and another for "author"
I am hoping to split (a) "keywords" by the regular expression ";", and (b) the "authors" by the regular expression ";", to separate one author from another and then by the regular expression "," to separate the array into two separate arrays - Surname and Firstname (for the MySQL Table Author). I will also want to include in each INSERT INTO query, another variable (from the same form), being the ID_Number of the book or article...
So, I am thinking if I used preg_split(";") for both (a) & (b) to give an array, say for table (a) Keyword
<?php
$keyword = preg_split(";",'$POST_[keywords]',-1,PREG_SPLIT_NO_EMPTY)
mysql="INSERT INTO Keyword (Keyword, ID_Number) Values
(FOREACH '$keyword', '$POST[ID_Number]')";
I'd dearly love some feedback, I'm trying to teach myself this on the fly  If I can work out the first one (with only one split) then I can work on the nested array(s) and splitting the $author array into the same. The alternative is one ugly XHTML form, which I'd rather avoid.
|
|
|
|
|
Hi, what you are trying to do it right. You can go with that pattern. You want some improved version then you can refer this link. http://php.net/manual/en/function.preg-split.php[^]
They have included good number of example also. If you have already refer that page and you din't get any example then mention it so we can explain it.
|
|
|
|
|
Thanks for the reply, seems I've scared some people off - all I need is to split the HTML variable strings by one regular expression ";", that is what I've requested people use when using the form (and if they don't they don't)...
So if I do something along the lines of this:
$Authors = $_POST["Authors"];
$keywords = $_POST["keywords"];
$ID_Number = $_Post["ID_Number"];
$keyword = preg_split(";",'$POST_[keywords]',-1,PREG_SPLIT_NO_EMPTY)
mysql="INSERT INTO Keyword (Keyword, ID_Number) Values
(FOREACH '$keyword', '$POST[ID_Number]')";
if (!mysql_query($sql,$con)) {
die('Error: ' . mysql_error()); }
echo "Table: Keyword Updated";
$author = preg_split(";",'$POST_[Authors]',-1,PREG_SPLIT_NO_EMPTY)
mysql="INSERT INTO Author (Author, ID_Number) Values
(FOREACH '$author', '$POST[ID_Number]')";
if (!mysql_query($sql,$con)) {
die('Error: ' . mysql_error());}
echo "Table: Author Updated";
I should not only get the results I want (in both cases, in each table, a row with both the array item (Author or Keyword) and the ID_Number? If so, that will be wonderful, that is PRECISELY what I need...  That plus the feedback for each table should be good - I can always remove that later, first of all I have to get the code to work 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Java | [Coffee]](https://codeproject.freetls.fastly.net/script/Forums/Images/coffee.gif)
Now with 26% more Twitter
