|
Have you tried Asterisk[^].
Or you can find more from here[^].
Do not trust a computer...
Always check what computer is doing
regards,
Divyang Mithaiwala
Software Engineer
|
|
|
|
|
hi,
i would like to know how i can paging in php with mysql.
i want next, pre , first, last and combo box(listbox) where total number of pages shows in the combo box and when i click on page number than show records.
modified on Thursday, April 23, 2009 7:39 AM
|
|
|
|
|
What you are looking for is "pagination":
Google[^]
|
|
|
|
|
Basically you are going to use a technique similar to that in a previous post:
http://www.codeproject.com/script/Forums/View.aspx?fid=1640&msg=1742252[^]
Your sql queries will use the LIMIT keyword which specifies the number of pages a query is broken into and how many results to display. In MySQL it's like this
SELECT COUNT(*) AS total_pages FROM `table01`;
$result = $dbHandle->query($sql);
$row = $result->fetch_assoc();
$total_rows = $row['total_pages'];
//You'll need to calculate the end page, to display links to prev and next
$end_page = ceil($total_rows/$span);
SELECT * FROM `table01` LIMIT 0, 10;
where 0 is the current page being viewed (0 indexed) and 10 is the number of elements to return ($span).
in your code, the query will be: "SELECT * FROM `table01` LIMIT $cur_page, $span"
and $cur_page will be a GET requested variable
$cur_page = $_GET['page'];
if (!$cur_page)
$cur_page = 0;
Now display the results of the above query.
Then display the previous and next links however you like
display_link("page.php?cur_page=".$cur_page--); //prev
display_link("page.php?cur_page=".$cur_page++); //next
You can find a nicely formatted display was found on the web:
http://www.phpeasystep.com/phptu/29.html[^]
|
|
|
|
|
I am looking to programmatically hex edit a binary file, I have searched all over and can only find freeware programs that are GUIs that enable you to view binary/hex and insert data, how is this done programmatically??
TIA
|
|
|
|
|
nm i figured it out (or one way of doing it at least), been a long time since i used perl just needed a kickstart
|
|
|
|
|
|
|
Is this even possible?
I must make my own version of it since I can't run it with wine after I've installed it.
Kristoffer
|
|
|
|
|
If it's a Windows app and doesn't work with Wine then you're probably SOL.
You might get a better response if you ask the folks who make Championship Manager 2009.
|
|
|
|
|
1) I want to integrate Nochex Creditcard payment within my php site itself. Without redirecting to Nochex site
2) In curl, I want to get the redirected url from the original url
Can anyone help me in integrating Nochex creditcard payment into my PHP website.I have found many scripts and HTML form codes that takes me to the Nochex site(it navigates away from my website) during the payment and it worked fine.But what i need is all those credit card details should be given in my website and all those payment should take place in the backend(it should not navigate out of my site ) and return me the status whether payment is success or failure within my website itself. Hope my question is clear
|
|
|
|
|
I havent used nochex - but you'll probably need to use sockets (fputs) <- might help you in your google searches.
|
|
|
|
|
I know you can do what you want with paypal though.
modified on Tuesday, April 28, 2009 4:25 AM
|
|
|
|
|
Hello
I want to save pdf files in mysql and retirve the same using the php code
please help....
|
|
|
|
|
Either do a file uploader, store the file on the server and store the path to the file in the database,
or
Store the file itself in the database:
Uploading Files To MySQL Database
|
|
|
|
|
Something else you may find useful. This library alows you to dynmically create pdfs:
http://www.fpdf.org/[^]
|
|
|
|
|
That link is helpful .
Thanks
|
|
|
|
|
I Export the data from Excel to mysql with php,but it cause word in unicode look vague, is there a way to solve this problem
the code:
<br />
mysql_connect("localhost","","");<br />
mysql_select_db("tutorial");<br />
<br />
$result=mysql_query("select * from name_list order by id asc");<br />
<br />
function xlsBOF() { <br />
echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0); <br />
return; <br />
} <br />
function xlsEOF() { <br />
echo pack("ss", 0x0A, 0x00); <br />
return; <br />
} <br />
function xlsWriteNumber($Row, $Col, $Value) { <br />
echo pack("sssss", 0x203, 14, $Row, $Col, 0x0); <br />
echo pack("d", $Value); <br />
return; <br />
} <br />
function xlsWriteLabel($Row, $Col, $Value ) { <br />
$L = strlen($Value); <br />
echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L); <br />
echo $Value; <br />
return; <br />
} <br />
header("Pragma: public");<br />
header("Expires: 0");<br />
header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); <br />
header("Content-Type: application/force-download");<br />
header("Content-Type: application/octet-stream");<br />
header("Content-Type: application/download");;<br />
header("Content-Disposition: attachment;filename=orderlist.xls "); <br />
header("Content-Transfer-Encoding: binary ");<br />
<br />
xlsBOF();<br />
<br />
<br />
<br />
xlsWriteLabel(0,0,"List of car company.");<br />
<br />
xlsWriteLabel(2,0,"No.");<br />
xlsWriteLabel(2,1,"Company");<br />
<br />
$xlsRow = 3;<br />
<br />
while($row=mysql_fetch_array($result)){<br />
<br />
xlsWriteNumber($xlsRow,0,$row['id']);<br />
xlsWriteLabel($xlsRow,1,$row['name']);<br />
<br />
$xlsRow++;<br />
} <br />
xlsEOF();<br />
exit();<br />
?><br />
<br />
thanks
|
|
|
|
|
Excel to Mysql?
Looking at your code... Do you mean MySQL to excel?
Easiest way is csv files, which can be opened with excel.
|
|
|
|
|
My project is Attendance Management System.Front-end is in php.Back end in MySql.My Problem is how the attendance of employee/student done from card reader.How use the api of card reader in php?
Please send me the source code in PHP for attendance tracking from card reader.
Send reply as soon as possible.
|
|
|
|
|
Ritu0666 wrote: send me the source code
No..... unless you pay one of us.
Ritu0666 wrote: Send reply as soon as possible.
I suggest you pull your finger out and get working if it's important.
hmmm pie
modified on Sunday, April 19, 2009 5:30 AM
|
|
|
|
|
Ritu0666 wrote: Send reply as soon as possible.
Is it urgntz? Just askin', cause people here tend to help out with complete source codez only, if it's really urgent.
|
|
|
|
|
|
Ritu0666 wrote: Yes it is very urgent
He was mocking you, so this makes it hilarious.
No-one here spoons feeds people by giving them full source code (for free). You go away, work on the problem yourself and then only come back here when you have a specific problem.
hmmm pie
|
|
|
|
|
I consider it unbelieveably rude for you to email me asking to do this for you!
"Please send me the api of card reader in php"
You just don't get it!
hmmm pie
|
|
|
|