yougapi

yougapi supports this item

Supported

78 comments found.

Hi, i’m having some problems, hope you can help me. First, when i run genClass i get: Notice: Undefined variable: content in C:\xampp\htdocs\Transintercano\mysqlFramework\genClass.php on line 121

The files are created anyway. But when i try to use some of the class files, i get an error: Fatal error: Class ‘Noticias’ not found in C:\xampp\htdocs\Transintercano\noticias.php on line 14

I’m including the db_class.php file and instantializing the the class so i have no idea what the problem is. Thanks in advance!

You need to disable the display of notices on your server

Ok, i found why i’m having problems. the db_class.php is not loading the classes for my tables. If i include them manually, everything works perfectly. Any idea why db_class is not loading the classes?

Send me a link and temporary ftp access and will get a look, thanks

Hey, nevermind, it’s working on my server, it doesn’t work when i use it in my local server. Thanks anyway!

Hello, can I use this tool with CodeIgniter ?

Codeigniter is just a framework, and should have a way to integrate other specific libraries or frameworks ;)

I bought and enjoyed . I wonder how do I make transactions with this framework. I thank your attention .

Sorry i am not familiar with transactions :)

Please send me the documentation.

Forgot to tell..my email etadiguu@gmail.com. Tq

Just sent

Hi,

I am considering to buy this software as it looks promising. One question beforehand:

Lets say I am building a basic weblog and have a MySQL DB with 3 tables (all InnoDB with foreign keys): posts, authors, comments.

Now, I am on a php page which displays a specific post. I want to retrieve information on the author of this post, plus all the comments to this post.

Does your framework understand foreign key relations – will I be able to fetch the author of the post, which is linked to that post with a foreign key in the database? Same with comments?

I am just trying to understand if InnoDB features are supported by your framework…

Thanks in advance! :-)

The script doesn’t fetch data automatically based on foreign keys. You would need to define from which tables you want to requests data. That’s more flexible that a system that would guess for you ;)

Thank you for your answer! I will consider it when I am ready to purchase (at the moment, I am “stuck” with PDOs) :-)

Why the hack to you sell code with ERRORS in it?

In file genClass.php, line 120:

function tab5() {
  $content .= '';
}
$content has local scope, so error.

Which error? Please send me a link and description of your error through my profile page and will get a look, thanks

Well… It’s written above… The variable $content in function tab5() is ANOTHER one then used in other function(s) i.e.: LOCAL and undeclared.

For support please contact me through my profile page as specified, thanks

Hi Yougapi?

Thanks for this great app. Kindly, any idea if it’ll be possible to have this in PDO?

Thanks, tBeza

Just answered your email requesting the same thing. A PDO is not planned since that’s no need to it really :)

hi,

Just bought it, while examining this package I found out that In db_class.php this file is included, “class/tablesList.php”, But there is no such file in package class folder..

Thanks for your purchase. That file will be created when you execute the “genClass.php” file as specified in the documentation

Hi ! I have a weird error :

include_once('core/sql/db_class.php');

// Init SQL Object
$vendor= new Vendors();

// Clean input
$vendorName = $vendor->escape($_GET['vendor']);
$vendorName = isset($vendorName) ? clean($vendorName, "varchar(255)") : "";

// Query SQL for Vendor
$vendorInfos = $vendor->loadByFields("Username",$vendorName);

// Vendor not found ! 
if ( count($vendorInfos)==0 )
{
    header('location: index.php');
    exit;
}

$feeds=new Feedbacks();
$result = $feeds->loadByFields("To",$vendorName); // Error 

if I try : $feeds->loadByFields(“ID”,$id); it works well.

Any idea ? Here is the error : Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in C:\Program Files (x86)\EasyPHP-DevServer-13.1VC11\....\core\sql\MysqlTable.php on line 228

Thank you. :)

Make sure the “To” field exists for ex. Hard to help you without seeing your tables structure. If you can send me more details through my profile page I can check it out, thanks

I’ll when I get some time. For now I bypassed the issue by selecting all then filtering in php. Not the best idea but yeah.. Thanks for the quick reply !

Ok no prob. What you can do also is go in the function executeQuery and display the SQL query. Then run the same in phpmyadmin, if some parameters are wrong you should see it right away as well ;)

Hi, I am trying to do a distinct selection, and seems I am unable to do that or doing it wrong. Does this plugin support distinct statement when doing customQuery? I could not find it in docs. Also, you mention in earlier comment that group by is supported in selectAll, but it is not in the docs that I could find or in the index.php, can you give an example of that parameter used in selectAll() function? Thank you in advance.

For the select all should be added in an array as a second parameter. Ex: selectAll(‘id, name’, array(‘group’=>’name’));

The custom query supports any select SQL query. SO you can construct your SQL you want you want, with or without distinct ;)

ok, thanks man…:)

Hello Yougapi,

I trust that you are doing fine. I am trying to get something but i keep getting stuck. Basically i am building a simple resent password script, and in my database i have a table called tokens, and when you click reset password a reset token is created and alongside your user type.

And basically what i want to be able to do is to check if the token generated actually belongs to the user that has requested the password request, and if true, then echo that token which will be used to validate the password reset request. Below is my table structure:

CREATE TABLE IF NOT EXISTS `tokens` ( `ID` int(16) NOT NULL AUTO_INCREMENT, `token` varchar(255) DEFAULT NULL, `date` datetime DEFAULT NULL, `user` int(16) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;

Form:

<form action=”” method=”post” role=”form”> <?php if (isset($_REQUEST[‘thisToken’])) { ?> </form>


<label for=”newPass”>New Password</label> <input type=”text” name=”newPass” class=”form-control” id=”newPass” placeholder=”New Password”> <label for=”confmPass”>Confirm Password</label> <input type=”text” name=”confmPass” class=”form-control” id=”confmPass” placeholder=”Confirm Password”> <input name=”thisToken” type=”hidden” value=”<?php echo $tokenId ?>” /> <button type=”submit” name=”sendToken” class=”btn btn-success”>Reset Account</button>
<?php } else if (isset($_REQUEST['sendEmail'])) { ?>

Thank you! an email is on its way!

<?php } else { ?>

<label for=”sendToken”>Username or Email</label> <input type=”text” name=”tokenEmail” class=”form-control” id=”sendToken” placeholder=”Enter Email or Username”> <button type=”submit” name=”sendEmail” class=”btn btn-primary”>Send Token</button>
<?php } ?>

Please do let me know how best to approach this :)

Hi,

Thanks for using my class. For support on customization please contact me through my profile page for an estimate, thanks !

Thanks, i sent you also an email with the same effect to your email via your profile! Thanks! Please check and reply!

All right

are this is still working? are you still sell this sir?

Yes sure still working, and we are still using it in our apps or projects :)

This system makes Auto Pagination ?

Not really no, that’s very specific and would need to be done manually :)

Excellent! Thank you for this. Best buy ever in CC. A huge time saver. Best regards Andreas

Thanks !

HI there,

does it support php 5.5.x ??

Yes sure !

I thought this looked very good, i purchased added my mysql details and uploaded then visited /mysqlFramework/genClass.php just a blank page, nothing changed the class folder to 777, still nothing any ideas?

Hi,

I can help you out, please contact me through my profile page with a link and temporary FTP access and will check it out for you.

by
by
by
by
by
by