Linux, Apache, MySQL, PHP Discussion Boards

Re: Managing a database insert failure.. [modified]

Dr.Walt Fair, PE19-May-10 5:26

19-May-10 5:26

You can use a try ... catch to handle the error elegantly or use @ with the function name to suppress the error message, but in my opinion, allowing a known error to happen in the first place is a poor design.

I would do a simple SELECT query before to see if the name exists, then act accordingly.

CQ de W5ALT

Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software

modified on Wednesday, May 19, 2010 11:32 AM

Re: Managing a database insert failure..

MacIntyre19-May-10 5:39

MacIntyre

19-May-10 5:39

Don't like the catch an error either.
My first choice is to do as you suggested. I guess what I should be asking is does php work like the code behind asp.net where once the enter key is pressed it runs the code behind, in this case the php.
If so how do I get a little message box on the screen indicating that the username has alreadu been taken and to try another one?

Re: Managing a database insert failure..

Dr.Walt Fair, PE19-May-10 6:02

Dr.Walt Fair, PE

19-May-10 6:02

I'm not an expert in asp.net, but PHP is just server side, so if you need to get the info back to the client browser, you'll have to do something else, like use AJAX.

I have a user registration web page embedded in a PHP script (or PHP in a web page -- depends on your viewpoint) with a parameter indicating an error message. The first time you call the web page, the error message is blank so nothing is displayed.

If the registration succeeds, the PHP script redirects to a login or a secure page. If it fails it reloads the registration page again with a message that the user name is already taken (or database in unavailable, or password was blank, etc.).

CQ de W5ALT

Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software

Re: Managing a database insert failure..

MacIntyre19-May-10 6:32

MacIntyre

19-May-10 6:32

Walt this is great..
I really appreciate your assistance.
I will look to implement this later today..
Could you answer a resource question..?
I noticed a site called PHPLabs, they claim to have lots of goodies and great support for PH issues.
Do you know anything about them?
Thanks..
Chuck..

Re: Managing a database insert failure..

Dr.Walt Fair, PE19-May-10 6:53

Dr.Walt Fair, PE

19-May-10 6:53

I'm glad my suggestions may have helped. To me, the registration and login is just the first hurdle -- after that you probably need to maintain session info, and doing that securely offers other challenges!

I've never heard of PHPLabs before. I see they want to charge to be a member, so I don't think I'm interested. So far I've always found answers to my PHP questions using Bing (or Google). If you decide to delve into PHPLabs, I'd be happy to hear what you think.

CQ de W5ALT

Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software

Re: Managing a database insert failure..

MacIntyre19-May-10 7:53

MacIntyre

19-May-10 7:53

Thanks Walt..I'll probably save my money for now...

Re: Managing a database insert failure..

User 171649219-May-10 7:14

User 1716492

19-May-10 7:14

Not heard of PHPLabs until today. However, here are some websites you might find of use ...

http://ajax.phpmagazine.net/[^]
http://phpsense.com/[^]
http://www.phpandstuff.com/[^]
http://www.hotscripts.com/category/php/tutorials-tips/[^]

modified 1-Aug-19 21:02pm.

Re: Managing a database insert failure..

MacIntyre19-May-10 7:54

MacIntyre

19-May-10 7:54

Thanks Richard..
I'll look into these sites..
Cheers..
Chuck..

File Conversion

S p k 52117-May-10 18:44

S p k 521

17-May-10 18:44

Hi Experts,

Please let me know if any method is there to convert .json file to .po/.pot file in python script.. I have used Gettext library to parse po files and convert it to .json. But can't found any one to parse po files...

Regards,
Spk

php and batch files

simpocoder17-May-10 3:13

simpocoder

17-May-10 3:13

Hi,
I want a PHP script to run multiple batch files.
The batch files are doing the same job but for different files.
I don't want to create several scripts to do the same job.
Any idea is welcome.

Re: php and batch files

User 171649217-May-10 3:22

User 1716492

17-May-10 3:22

Not knowing exactly what task or tasks you wish to batch perform, and not being a mind reader, may I suggest you visit web sites such as http://www.hotscripts.com/category/php/[^] and look to see if anything there (or elsewhere for that matters) jumps up and says "try me"!

modified 1-Aug-19 21:02pm.

Re: php and batch files

simpocoder17-May-10 4:10

simpocoder

17-May-10 4:10

The script is as shown below

<?php
session_start();
$userid=$_SESSION['userid'];
$res=exec('bat\diff_coursework.bat',$shell);
echo '<a href="content/differentiation_coursework/main.pdf"><input name="Download" type="button" value="Download" />';
include ("config.php");
$query="insert into access values('$userid','differentiation','coursework',NOW())";
mysql_query($query);
?>

It calls the batch file diff_coursework.bat and then display a download button for the main.pdf file.
I have several files to be run the same way therefore I need a general script for that instead of creating a new script for every file.

Re: php and batch files

cjoki17-May-10 11:43

cjoki

17-May-10 11:43

since this part is just a string being passed

'bat\diff_coursework.bat'

maybe an array might help

$bats_arr = array('diff_coursework.bat','diff_coursework2.bat','diff_coursework3.bat', etc....);

foreach($bats_arr as $bat_file)
{
$res=exec('bat\'.$bat_file,$shell);
}

Re: php and batch files

simpocoder18-May-10 22:53

simpocoder

18-May-10 22:53

Have you tried to implement this?
This will run all the bat files every time it is called.
I want it to be able select the bat files to run.

Thanks for the idea

Re: php and batch files

cjoki1-Jun-10 14:19

cjoki

1-Jun-10 14:19

Then in your code reference the array by the index via a link.

That will give you the selection you want and a single file to manage them all.

Using SAX

vho12317-May-10 2:17

vho123

17-May-10 2:17

Hi guys i have this small class task that i'm having trouble with. I need to create a PHP file using SAX to generate the display shown below from an XML file.

*** This is the xml source code from which i need to generate the display: ***

<orders>
  <order>
    <count>37</count>
    <price>49.99</price>
    <book>
      <isbn>0130897930</isbn>
      <title>Core Web Programming Second Edition</title>

      <authors>
    	  <count>2</count>
        <author>Marty Hall</author>
        <author>Larry Brown</author>
      </authors>
    </book>
  </order>

  <order>
    <count>1</count>
    <price>9.95</price>
    <yacht>
      <manufacturer>Luxury Yachts, Inc.</manufacturer>
      <model>M-1</model>
      <standardFeatures oars="plastic" lifeVests="none">false</standardFeatures>

    </yacht>
  </order>
  <order>
    <count>3</count>
    <price>22.22</price>
    <book>
      <isbn>B000059Z4H</isbn>

      <title>Harry Potter and the Order of the Phoenix</title>
      <authors>
    	  <count>1</count>
        <author>J.K. Rowling</author>
      </authors>
    </book>
  </order>

*** what the expected output to look like below. ***
[IMG]http://img13.imageshack.us/img13/6950/75914446.jpg[/IMG]

">" problem in PHP code

SNArruda15-May-10 6:09

SNArruda

15-May-10 6:09

Hi,

I try to execute a php code that stop when find a ">" char.

I new in web developing and i think that my feel experiencie is the real problem.

some one can help me ?

The messege i received on top of the page in preview is

setQuery("*", "people"); // If were called using ajax, only display the table, not the page body if > (EyeDataGrid::isAjaxUsed()) { $x->printTable(); exit; } ?>

The code i wish to execute is:

<?php
require 'class.eyemysqladap.inc.php';
require 'class.eyedatagrid.inc.php';

// Load the database adapter
$db = new EyeMySQLAdap('localhost', 'root', '', 'codes');

// Load the datagrid class
$x = new EyeDataGrid($db);

// Set the query
$x->setQuery("*", "people");

// If were called using ajax, only display the table, not the page body
if (EyeDataGrid::isAjaxUsed())
{
$x->printTable();
exit;
}
?><HTML><HEAD><TITLE>EyeDataGrid Example 1</TITLE><LINK href="table.css" type=text/css rel=stylesheet><META content="MSHTML 6.00.6002.18130" name=GENERATOR></HEAD><BODY>
<H1>Basic Datagrid</H1>
<P>This is a basic example of the datagrid</P>
<?php$x->printTable();
?>

</BODY></HTML>

Re: ">" problem in PHP code

mdusyl15-May-10 7:52

mdusyl

15-May-10 7:52

Can you please post the error message with error line number?
Also please check is there any whitespace before <?php , if there is any then try removing it.

Smile | :)

http://www.halalit.net

Re: ">" problem in PHP code

cjoki17-May-10 11:37

cjoki

17-May-10 11:37

just a basic look at the code it seams that you are missing a space in this part of the code.

<?php$x->printTable();

try
<?php $x->printTable();

Re: ">" problem in PHP code

polluks1-Jun-10 8:36

polluks

1-Jun-10 8:36

I can't understand the question/problem, but the cjoki is right. You must format the code more clearly and carefully. There isn't white space betwen <?php$x->printTable(); ...

Entry point in linux kernel

rupeshkp72811-May-10 23:40

rupeshkp728

11-May-10 23:40

Whats the entry point in the linux kernel?

Re: Entry point in linux kernel