2608 comments found.
hello,
field DataBinding does not work at all (I use Version 3.4) I use $pdocrud->fieldDataBinding(“location_alias_name”, “locations”, “id”, “alias_name”, “db”); If I want to edit the entry, the dropdown is set on “choose”, although there is already an entry in the column. So if you want to edit, it you have to rechoose, although there is already an entry.
I am also using a callback function and it changes value and key – so within the callback I receive the id (=key) in the value field of the $data array.
How can I send an error message from a callback (e.g. beforeUpdate)? if there is an error within the callback or the validation I do within the callback?
There are also so many other bugs, that I do not even want to write them… e.g. You say it is boostrap4 – ready. There is no more pull-right in bootstrap 4 – it is float,...
or the success – message window on the top is shown all the time. I guess the reason is, that bootsrap4 does not have hidden any more and invisible or d-none instead.
As a programmer I know, that no script is without errors, and I guess you really spent a lot of time in writing this. But I also spend so much time with this buggy script and it is annoying – many things do not work… sorry to say that!
When I have a little more time, I will write you a list.
Although thanks for your answer in advance, Bernhard
hi,
Field databinding works properly. Please check http://pdocrud.com/demo/pages/field-data-binding I have added a entry to show it works in edit also.Please show your code as it might be something else. Regarding bootstrap4, we have added it as template in last version only while other users can also directly add it and modify it.
Callback function has $obj also and it can be used to set error message. Yes, no script is completely bug free and we are adding more and more features to make it more useful so some recently function may sometime have some bugs but we immediately remove them as we got to know about them. Thanks for your information.
Thanks
Hi, sorry – the fieldDataBinding was my fault – I attached it on the value field an not on the key field… it works now.
Some other issues: 1.) Where and how can I place an error in the $obj so that it will be shown in the message area on top of the table/form? 2.) How can I solve the problem with the message area shown all the time in bootstrap4? 3.) I tried to insert an action Switch like in the manual: //action type switch – on click on column, value will be changed and saved $action = array(“1”=>”0”,”0”=>”1”);//action to be performed, like when value is 1 set it to 0 $text = array(“1” => “geprüft”,”0”=>”nicht geprüft”); $pdocrud->enqueueActions($action,”switch”,$text,””,array()); What happens is, that a modal with a new table in it pops up… 4.) I need European Date formats. Although I have entered the proper format in config.php, the table displays mysql format. The advanced search between two dates shows the european format after selecting from the calendar. So search does not work and entering dates within an update ends up in the database with 00-00-00 00:00:00 – if a date is change before update. 5.) Is there a way to start search immediately when letters are entered? or at least with hitting return instead of clicking on the search-button? 6.) is there a way to define the fields that are shown in the dropdown – search? no one needs columns like id,... 7.) inline edit does not work for me – what happens is a modal with very small columns next to each other – no inline… 8.) is there a function to remove the save – button from the forms? The problem is, that if the user clicks it twice, the entry is saved twice… 9.) is there a way to exit the save or edit routine within a callback function, if an error occurs (e.g. after checking, if the entry exists already – or some other validation fails)?
Thanks in advance, bernhard
Hi,
1. You need to put $obj function inside the callback function and call the set error function to set error message. 2. You can use css to hide the message. We will add it in next version. 3. Please show your complete code to understand it as modal popup is not related to switch. 4. You can format date in callback function before insert or before select. 5. We have already added this feature in next versions list. 6. It is same as the columns of the grid. 7. Please show your complete code. 8. Yes, you can show hide any button. Please check config. 9. Yes, callback function can be used with die function.
Thanks
Hi,
@1: I would really appreciate, if your answers would be a little more detailed – I am sure it helps also all other people who have similar problems… the Object is an instance of PDOCrud – right? There is not setError() – which is the right function?
@2 what css prpberty? hidden does not work with bootstrap 4 and I guess there will be a problem, if a message has to be shown (wether error or success)
@3 you can find the code at the end.
@4 Ok – I added a callback before insert. The problem is, that the fields are not searchable with date-range.. How can I perform a date-range search with the date shown in european style?
@5 fine! any idea, when the next update will be out?
@6 in my case it is not the same as the columns of the grid – but I guess the same as the columns that have extra added names. The thing is I need to give every column a name, because otherwiseI have ugly names in the Details view, which shows all columns… or is there an option to hide columns in the details View? And so the filter dropdown contains al columns…
@7 code underneath
thanks, Bernhard
$pdocrud = new PDOCrud();
// Namensvariablen - kann dann in der Tabelle und im Formular verwendet werden
// Es müssen die Namen von allen Feldern pretty Name bekommen, weil in der Detailansicht alle Felder sichtbar sind
$columnames = array(
"id" => "ID",
"jobdate" => "JobDatum",
"start_time" => "JobBeginn",
"end_time" => "JobEnde",
"location_id" => "Location", // der Name dard nicht ID lauten, weil in den Formularen das Dropdown eigentlich die Spalte Location_id ist und der Name Location ID komisch aussehen würde
"location_alias_name" => "Locationname",
"user_id" => "Personal ID",
"staff_number" => "Personal ID",
"first_name" => "Vorname",
"last_name" => "Nachname",
"time_approved" => "geprüft",
"approved_by_user_id" => "geprüft von ID",
"approved_by_bfs_id" => "geprüft von ID",
"approoved_by_user_first_name" => "geprüft von Vorname",
"approved_by_user_last_name" => "geprüft von Nachname",
"approved_date_time" => "geprüft am",
"exported" => "exportiert",
"export_date" => "exportiert am",
"last_change" => "letzte Änderung",
"created" => "Eintrag vom",
);
// Spalten weder Tabelle, noch Form
$columns_not_show_crud_and_form_obj = new Array_builder_numeric();
$columns_not_show_crud_and_form_obj->add_value_to_array("id");
$columns_not_show_crud_and_form_obj->add_value_to_array("user_id");
$columns_not_show_crud_and_form_obj->add_value_to_array("approved_by_user_id");
$columns_not_show_crud_and_form_obj->add_value_to_array("approved_by_bfs_id");
$columns_not_show_crud_and_form_obj->add_value_to_array("approoved_by_user_first_name");
$columns_not_show_crud_and_form_obj->add_value_to_array("approved_date_time");
$columns_not_show_crud_and_form_obj->add_value_to_array("last_change");
$columns_not_show_crud_and_form_obj->add_value_to_array("created");
$columns_not_show_crud_and_form = $columns_not_show_crud_and_form_obj->get_array_to_return();
// Spalten nur Tabelle nicht
$columns_not_show_crud_obj = new Array_builder_numeric();
$columns_not_show_crud_obj->add_value_to_array($columns_not_show_crud_and_form);
// Location_id -daraus wird das Dropdoen für die Location
$columns_not_show_crud_obj->add_value_to_array("location_id");
$columns_not_show_crud = $columns_not_show_crud_obj->get_array_to_return();
// Felder die im hinzufügen - Form nicht angezeigt werden sollen
$columns_not_show_form_obj = new Array_builder_numeric();
$columns_not_show_form_obj->add_value_to_array($columns_not_show_crud_and_form);
$columns_not_show_form_obj->add_value_to_array("location_alias_name");
// staff number dropdown ist das Feld user_id und nicht staff_number daher da eine hinzu und das andere weg
$columns_not_show_form_obj->remove_value_from_array("user_id");
$columns_not_show_form_obj->add_value_to_array("staff_number");
$columns_not_show_form_obj->add_value_to_array("first_name");
$columns_not_show_form_obj->add_value_to_array("last_name");
$columns_not_show_form_obj->add_value_to_array("approved_by_user_last_name");
$columns_not_show_form_obj->add_value_to_array("approved_date_time");
$columns_not_show_form_obj->add_value_to_array("approved_date_time");
$columns_not_show_form_obj->add_value_to_array("export_date");
$columns_not_show_form_obj->add_value_to_array("exported");
$columns_not_show_form = $columns_not_show_form_obj->get_array_to_return();
// Felder, die bei Edit im Form nicht angezeigt werden sollen
$columns_not_show_form_edit_obj = new Array_builder_numeric();
$columns_not_show_form_edit_obj->add_value_to_array($columns_not_show_form);
$columns_not_show_form_edit_obj->add_value_to_array("staff_number");
$columns_not_show_form_edit = $columns_not_show_form_edit_obj->get_array_to_return();
// Tabelle auswählen
$pdocrud->dbTable("hours");
// Überschrift
$pdocrud->tableHeading(' Stundenliste');
// Spalten nicht anzeigen:
$pdocrud->crudRemoveCol($columns_not_show_crud);
// Checkboxspalte
$pdocrud->setSettings("checkboxCol", false);
// Dropdown Einträge pro Seite
$pdocrud->setSettings("recordsPerPageDropdown", true);
// Info Einträge total
$pdocrud->setSettings("totalRecordsInfo", true);
// Spalten umbenennen
foreach ($columnames as $key => $value)
{
$pdocrud->colRename($key, $value);
}
// Zeitformat Tabelle
$pdocrud->tablecolFormatting("start_time", "time", array("format" => "h:m"));
// Where Bedingungen
if(!empty($filter))
{
switch ($filter)
{
case "exported":
$pdocrud->where("exported", "1","=");
break;
case "not_exported":
$pdocrud->where("exported", "1","!=");
break;
case "time_approved":
$pdocrud->where("time_approved", "1","=");
break;
case "time_not_approved":
$pdocrud->where("time_approved", "1","!=");
break;
case "not_exported_not_approved":
$pdocrud->where("exported", "1", "!=");
$pdocrud->where("time_approved", "1", "!=");
break;
case "none":
break;
default:
break;
}
}
//set the search column data type
$pdocrud->setSearchColumnDataType("jobdate", "date-range");// other options are time-range, datetime-range
$pdocrud->setSearchColumnDataType("appproved_date_time", "date-range");// other options are time-range, datetime-range
$pdocrud->setSearchColumnDataType("export_date", "date-range");// other options are time-range, datetime-range
$pdocrud->setSearchColumnDataType("last_change", "date-range");// other options are time-range, datetime-range
$pdocrud->setSearchColumnDataType("created", "date-range");// other options are time-range, datetime-range
// Zeitrange
$pdocrud->setSearchColumnDataType("start_time", "time-range");// other options are time-range, datetime-range
$pdocrud->setSearchColumnDataType("end_time", "time-range");// other options are time-range, datetime-range
//action type switch – on click on column, value will be changed and saved $action = array(“1”=>”0”,”0”=>”1”);//action to be performed, like when value is 1 set it to 0 $text = array(“1” => “approved”,”0”=>”unapproved”); $pdocrud->enqueueActions($action,”switch”,$text,”time_approved”,array());
//action type switch - on click on column, value will be changed and saved
$action = array("1"=>"0","0"=>"1");//action to be performed, like when value is 1 set it to 0
$text = array("1" => "geprüft","0"=>"nicht geprüft");
$pdocrud->enqueueActions($action,"switch",$text,"exported",array());
// Callback Funktionen
$pdocrud->addCallback("format_table_data", "formatTableDataCallBack_be_hours");
$pdocrud->addCallback("before_sql_data", "beforeSQLDataCallBack_be_hours");
$pdocrud->addCallback("before_update", "beforeUpdateCallBack_be_hours");
$pdocrud->addCallback("before_insert", "beforeInsertCallBack_be_hours");
#
- Formular ### // als Modal $pdocrud->formDisplayInPopup(); // Labels benennen foreach ($columnames as $key => $value) { $pdocrud->fieldRenameLable($key, $value); } // Felder ausblenden: $pdocrud->formRemoveFields($columns_not_show_form);
// Felder für edit
// hier wird eine positive Liste der Feldnamen benötigt - also eine Lister derer die im Formular vorkommen sollen und nicht eine Negativliste,
//welche nicht vorkommen sollen - also vorher ein entsprechendes Array generiert werden
$columns_show_form_edit = array();
// für alle Spaltennamen
foreach ($columnames as $key => $value)
{
// wenn feld nicht bei denen ist, die nicht angezeigt werden sollen, dann zum Return dazugeben
if(!in_array($key, $columns_not_show_form_edit))
{
array_push($columns_show_form_edit, $key);
}
}
$pdocrud->editFormFields($columns_show_form_edit);
// Dropdown Kunden
$pdocrud->fieldTypes("location_id", "select");//change type to select
//function fieldDataBinding($fieldName, $dataSource, $key, $val, $bind = "db") - wenn man nicht den key, sondern wie in diesem Fall den Value
// gespeichert haben will, dann auch bei key die spalte für den value angeben
$pdocrud->fieldDataBinding("location_id", "locations", "id", "alias_name", "db");//add data using another table name country
// Dropdown BFS-ID
$pdocrud->fieldTypes("user_id", "select");//change type to select
//function fieldDataBinding($fieldName, $dataSource, $key, $val, $bind = "db") - wenn man nicht den key, sondern wie in diesem Fall den Value
// gespeichert haben will, dann auch bei key die spalte für den value angeben
$pdocrud->fieldDataBinding("user_id", "as_users", "user_id", "username", "db");
// Archiviert - Radio Button
$pdocrud->fieldTypes("exported", "radio");
$pdocrud->fieldDataBinding("exported", array("nein","ja"), "", "","array");//add data for radio button
$pdocrud->fieldTypes("time_approved", "radio");//change gender to radio button
$pdocrud->fieldDataBinding("time_approved", array("nein","ja"), "", "","array");//add data for radio button
// Abbrechen Button ausblenden - der ist für nichts
$pdocrud->buttonHide($buttonname="cancel");
//$pdocrud->buttonHide($buttonname="submitBtn");
// Nicht verpflichtende Felder
$pdocrud->fieldNotMandatory("client_number");
// Rendern
echo $pdocrud->render();
and here the callback functions so far:
#
- be_hours.php
#######
function formatTableDataCallBack_be_hours($data, $obj)
{
// var_dump($data);
foreach ($data as $row => $rowdata)
{
$data$row = General_time_functions::make_european_date_from_sql_date($rowdata[‘jobdate’]);
}
return $data;
}
function beforeSQLDataCallBack_be_hours($data, $obj) { var_dump($data); }
function beforeUpdateCallBack_be_hours($data, $obj) {
//var_dump($data);
// das Dropdown Location kommt nur die Location_id zurück - daher hier noch den namen der Location heraussuchen
$location_id = $data'hours';
$location_obj = new Locations();
$location_res = $location_obj->load_location_data_from_id($location_id);
$data'hours' = $location_res['alias_name'];
$data'hours' = $location_res['id'];
// TODO Datumsformat auf SQL ändern
// Todo Spalte Eintrag geändert und von wem - ausser es geht nur um Sachen wie geprüft
// TOdo eventuell eigene TABELLE, in der die Änderungen protokolliert werden
// Zeit runden
$data'hours' = General_time_functions::up_or_down_round_time_minutes_15($data'hours', true);
$data'hours' = General_time_functions::up_or_down_round_time_minutes_15($data'hours', true);
// TOdo prüfen, ob es sich mit einem bestehendem Eintrag überlappt
return $data;
}
function beforeInsertCallBack_be_hours($data, $obj) { //var_dump($data); //echo “
";
//var_dump($obj);
// Jobdate - wenn es im Kalender ausgewählt wird, hat es das Format 14-09-2018
// muss für SQL Eintrag umgewandelt werden
$data['hours']['jobdate'] = General_time_functions::make_sql_date_from_date_european($data['hours']['jobdate']);
// das Dropdown Location kommt nur die Location_id zurück - daher hier noch den namen der Location heraussuchen
$location_id = $data['hours']['location_id'];
$location_obj = new Locations();
$location_res = $location_obj->load_location_data_from_id($location_id);
$data['hours']['location_alias_name'] = $location_res['alias_name'];
$data['hours']['location_id'] = $location_res['id'];
// das Dropdown BFS_id (eigentlich user_id) kommt nur die user_id zurück - daher hier noch die staff_number, den Vor und den Nachnamen heraussuchen
$user_id = $data['hours']['user_id'];
$users_obj = new Users();
$user_res = $users_obj->load_complete_userdata_with_join_from_id($user_id);
$data['hours']['user_id'] = $user_res['user_id'];
$data['hours']['staff_number'] = $user_res['username'];
$data['hours']['first_name'] = $user_res['first_name'];
$data['hours']['last_name'] = $user_res['last_name'];
// TODO Datumsformat auf SQL ändern
// Zeit runden
$data['hours']['start_time'] = General_time_functions::up_or_down_round_time_minutes_15($data['hours']['start_time'], true);
$data['hours']['end_time'] = General_time_functions::up_or_down_round_time_minutes_15($data['hours']['end_time'], true);
// prüfen, ob es den gleichen Eintrag schon mal gibt - das kann sein, wenn beim Insert - Formular 2x aus Speichern gedrückt wird
// das muss nach dem runden erfolgen, weil ein eventuell bestehender Eintrag ja auch gerundet wurde
$check_if_double = Hours::check_if_same_entry_exists_already($data['hours']);
if($check_if_double)
{
// Todo abbrechen und Fehlermeldung
echo "<br />FEHLER: doppelter Eintrag!<br />";
$obj->setErrors("Das ist ein Testfehler");
}
// TOdo prüfen, ob es sich mit einem bestehendem Eintrag überlappt
return $data;
}
########
# EO be_hours.php
#######
one mire question – 10.) how can I predefine the table to show only entries between two dates in the date column? It is important, that it stays still searchable with the search – field…
Hi, 1. it will be something like %obj->addError($error) inside the callback function. 2. we will add that css property in next update.You just need to add css property that can hide the message. 3. ok 4. inside the callback function, you need to change the date format again to yyyy-mm-dd date format. 5. I am not sure about exact date but we will try to release as soon as possible. 6. Currently it supports column in this way. in case you want certain column to be removed, you can jquery to remove it easily. 7. Can you send code via email, as all formatting gone here. 10. You can use where condition with between operator. Thanks
can you create a login with facebook using this script in a future version?
Hi,
We will try to add this but we are not sure as facebook and other apis keep changing their apis so difficult to maintain it. But we will try. Also, your support has expired so please renew it. Thanks
Is possible to place the column value not the primary key value in : $action = “{pk}”;//{another example of adding url {} text will be replaced by the primary key value $pdocrud->enqueueActions($action,”url”,””,”url”,array(“onclick”=>’coco(this)’));
Hi
Yes, it replaces the primary key value as mentioned in example. Thanks
I replace the primary key in my sql estructured or in $action = “{pk}”; i replaced in action in format {key} and this dont apply anything change.
Hi
You mean you are using {pk} or some column {col}? It works with {pk} only as explained in demo. Let me know. Also, your support has expired, please purchase support. Thanks
Hi developer !!!
4 days ago, i send you an email with the access information in order to support me. Through your profile page. I would like to know the status of this support. Do you need extra information? I have not any email with your response or any notification.
Please, can you tell me if all is ok?, when i can start using this product without these problems? or.. if there are something i can do?
Thanks.
Hi
I haven’t received your email. Please resend. My email id is digidreamstech@gmail.com. Thanks
Ready. The email was re-sent. Please, check the information.
The issue was solved. Thanks for the support.
Can you have more than two tables in a nested table?
Yes, you can have more than 2 tables in nested tables. Thanks
Honored whether one video tutorial can begin
it reports me: Direct access not allowed
hi
Are you trying to open index.php file. This message comes when you access index.php file. You need to create a php file and include the script/pdocrud.php file. After that you can run any code examples to check it. Make sure to do config settings. It will be better to check demo and documentation before start.
I am not sure about your video tutorial message.Please explain more.
Thanks
You need to create a php file and include the script/pdocrud.php file,with code require_once “script/ pdocrud.php”;Have you made a video tutorial on the joutube for beginners
Hi
Yes, We have created a general video https://www.youtube.com/watch?v=XtRERHWYbqIPlease feel free to ask any question if you have. Thanks
I do not understand the installation
In case you are not able to follow it, please send me details of your server, we will do installation. Thanks
can you give me an email address to send you the data of the server
Hi Please send email to digidreamstech@gmail.com Thanks
when I use this in the key recovery form it does not work
$ pdocrud-> addCallback (“before_select”, “beforeloginCallback”);
function beforeloginCallback ($ data, $ obj) { $ data “users” = md5 ($ data “users”); return $ data; }
How else can I encrypt the key?
HI
try to print the data and check in console to understand the data structure. This is correct way to encrypt. Thanks
How do I print on the console? Sorry, I’m a bit of a novice in this. can you help me please?
in xcrud this is simpler and does not require a callback to do it with this line of code
$ xcrud-> change_type (‘user_pass’, ‘password’, ‘md5’, array (‘maxlength’ => 10, ‘placeholder’ => ‘enter password’));
Can not you do an encryption with no call back in the next version?
Hi,
You can just print_r($data) and check in browser console (network tab). I will check what we can do for default encryption. Thanks
thanks, I’m very happy with the last update
When I do that, this message appears. Do you see the error?
Notice: Undefined index: pass in C: \ xampp \ htdocs \ school \ script \ pdocrud.php on line 25 Array ([users] => Array ([user] => contact@danielhuerta.cl [pass] => d41d8cd98f00b204e9800998ecf8427e)) Warning: Invalid argument supplied for foreach () in C: \ xampp \ htdocs \ school \ script \ classes \ PDOCrud.php on line 2233 Could not instantiate mail function. {“Message”: “Great !, The password was sent to your email”, “error”: [], “data”: [{“user_id”: “1”, “user” : “demo@prueba.cl”, “pass”: “jPOYh @ AG20”, “Avatar”: “http: \ / \ / 190.160.70.90 \ / colegio \ / script \ / uploads \ /1537417213_default.png”, Full_name demo ”, Group Admin ”, Permissions All “}, { user_id 2 ”, user contact@danielhuerta.cl ”, pass 1234 ”, Avatar http: \ / \ / 190.160.70.90 \ / school \ / script \ / uploads \ /1537459592_avatar7.png ”, Full_Name Daniel Huerta ”, Group Basic ”, Permissions Edit pages “}], redirectionurl “}
When I do that, this message appears. Do you see the error?
Notice: Undefined index: pass in C: \ xampp \ htdocs \ school \ script \ pdocrud.php on line 25 Array ([users] => Array ([user] => contact@danielhuerta.cl [pass] => d41d8cd98f00b204e9800998ecf8427e)) Warning: Invalid argument supplied for foreach () in C: \ xampp \ htdocs \ school \ script \ classes \ PDOCrud.php on line 2233 Could not instantiate mail function. {“Message”: “Great !, The password was sent to your email”, “error”: [], “data”: [{“user_id”: “1”, “user” : “demo@prueba.cl”, “pass”: “jPOYh @ AG20”, “Avatar”: “http: \ / \ / 190.160.70.90 \ / colegio \ / script \ / uploads \ /1537417213_default.png”, Full_name demo ”, Group Admin ”, Permissions All “}, { user_id 2 ”, user contact@danielhuerta.cl ”, pass 1234 ”, Avatar http: \ / \ / 190.160.70.90 \ / school \ / script \ / uploads \ /1537459592_avatar7.png ”, Full_Name Daniel Huerta ”, Group Basic ”, Permissions Edit pages “}], redirectionurl “}
Yes, you are accessing $data[“user”] while it should be $data“users”. Thanks
I’m using Plugin file input. Which callback do I have to use if I want to set a session variable with the value of one of the form fields? It’s not clear for me what each callback function does. Thanks
I have this code: $pdocrud->formRedirection("detail.php?f=12");
$pdocrud->addPlugin("bootstrap-fileinput-master");//to add plugin
$pdocrud->fieldTypes("File_path", "image");//change field type
$pdocrud->formFields(array("File_path","File_name","typeid"));
$pdo_crud->setUserSession("TypeSelected", "typeid");
$pdocrud->fieldTypes("typeid", "select");//change type to select
$pdocrud->fieldDataBinding("typeid", "FileType", "typeid", "name", "db");
$pdocrud->tableColUsingDatasource("typeid", "FileType", "typeid", "name", "db");
$pdocrud->setLangData("save", "Upload!");
echo $pdocrud->dbTable("imports")->render("insertform");
echo $pdocrud->loadPluginJsCode("bootstrap-fileinput-master","input[type=file]");
and this code on detail.php?f=12:
echo $_SESSION["TypeSelected"];
but TypeSelected value never changed.
Sorry, I changed $pdo_crud by $pdocrud and it’s not already working .
Trying to check sessions I’ve just write this. $pdo_crud is defined before:
$pdo_crud->setUserSession("lastLoginTime", date("now"));
echo $pdo_crud->getUserSession("lastLoginTime");>
and I get the following error: Notice: Array to string conversion in /detail.php on line 214
Finally I’ve used session variables from php and $pdo_crud->addCallback(“before_insert”, “beforeInsertCallBack”);. I’m unable to do with setUserSession.
Hi, how can insert (no googlemaps) openstreetmap.org (via JavaScript library – Leaflet) into form ? Thanks
Hi
Sorry, I am not able to understand your question. Please provide more details. Thanks
This example uses Googlemap (http://pdocrud.com/demo/pages/google-map) How can I use Openstreetmap (www.openstreetmap.org) ? For example in new pop up form ?
Hello, How can I make a redirection to another url after upload a file? (Only when upload is done). Thanks
And know the path of the uploaded file inside the redirection function… 
ok, resolved.
Could you explain to me how this works that I do not understand please?
http://pdocrud.com/demo/pages/export-dbplease here it is important that the photo not the url appear
https://danielhuerta.cl/img_clinica/view.PNGHi,
1. It exports database. You can execute code as described in the example to export database. 2. This feature is not available currently, we will try to add this in future version. Thanks
In personal tests, in order to find a solution about php default session disabled>
in classes/PDOCrud.php, in method: private function savePDOCrudObj: session $_SESSION“pdocrud_sess” has value and is OK. i put an adicional session for test, and this has value and is OK.
after that, i press any button or link in page, so the image ajax-loader.gif appear forever. Never end (this is the main problem)
then, in classes/PDOCrudAjaxCtrl.php, in method: public function handleRequest: i check $_SESSION“pdocrud_sess”, but now, is NOT set, i mean, is null. Also i check my test session, declared in savePDOCrudObj(), and also is NOT set (Null).
So, i can identify the problem is when i press any button in page, the sessions are deleted !!!
I dont understand why the sessions are deleted but, i still can not use correctly this product.
My web hosting provider says php sessions are enabled, and put an example in my domain: http://mundodan.com/session.phpso, my php sessions must be ok.
Can you support me in order to use correctly this product?
Thanks!!!
Hi,
Please send your access details via email using profile page. We will check. Thanks
Ok. My message has been sent. Please check my e-mail.
Thanks.
Hi, all Links in the “Version details “are 404 (on Firefox) – fore example: http://pdocrud.com/demo/pages/export-db) The problem is the ) at the end. When i remove it It works. ;-))
Hi,
We have update it in description. Thanks
This is amazing product but still i never use this product due to only one reason. I am not able to set image upload path in my php page. i have to configure one time in config file.
Hi, We have already added a function fileSavePath($uploadPath = ””, $downloadPath = ””) to modify the upload and download path. Thanks
thanks you for your reply. i will try to use this.
How can I hide this message that appears when I change the key?
https://danielhuerta.cl/img_clinica/pass_perdida.PNGHi
We are not getting this message. You may have output the js response coming so please check in that direction. You can check on server demo also, it is not showing that message. Thanks
Hi !!! When i try to run a test, i get this error:
Parse error: syntax error, unexpected end of file in /home/MyDomain/public_html/path/EnvatoPDOCrud/script/classes/PDOModel.php on line 1148
I am running the .php test in: http://www.mydomain.com/path/admin.php
i’ve configured all the parameters in config.php
ej: $config[“script_url”] = “http://mydomain.com/path/EnvatoPDOCrud/”; . . . $config[“dbtype”] = “mysql”; . .
Can you helpme? thanks
I found the solution. Using WinSCP client for upload all script filles to my server, causes some files to get corrupted. So i need to compress all script folder and upload only one .zip file. So, in the server extract all files.
Hi
Ok. It happens sometimes that zip files doesn’t get extracted properly.
Let me know if anything else I can help you with. Thanks
Hi ddeveloper. I have a problem. Right now, i have the error: PHP Notice: Undefined index: pdocrud_sess in …/script/classes/PDOCrudAjaxCtrl.php on line 9 PHP Fatal error: Call to a member function render() on boolean in …/script/classes/PDOCrudAjaxCtrl.php on line 32 PHP Fatal error: Call to a member function currentPage() on boolean in …/script/classes/PDOCrudAjaxCtrl.php on line 80
i know, this problem could be caused because default php sessions are not allowed, but the problem is that i can not access directly to php .ini file and make the changes. I use CPanel 74.0 (build
, and, my web hosting provider, does not include the opcions to modifi php .ini through CPanel:
(PHP Configuration Editor and MultiPHP INI Editor are missing).
So, is there any way i can still use this product? i mean, without modifi directly the .ini file? Can you support me in order to be able to use this product with this limitation? is there any way?
This is my first and simple test file, that produce the errors:
<?php session_start(); // i test with/without this opcion, and same error. require_once ‘EnvatoPDOCrud/script/pdocrud.php’ ; $pdocrud = new PDOCrud(); //create object of PDOCrud Class echo $pdocrud->dbTable(“Table”)->render(); // call render function on database table ?>
I hope you can help me. Thanks
Hi,
Currently it requires php default session to be enabled. You can ask your service provide to enable it as most of the hosting company allow it once you ask them to enable. We are also working on adding a feature that will make it work without php session also but it will be some days before that version could be released. Thanks
Thanks very much developer !!!
The web hosting provider says all is ok and sessions are enabled. He show me the next example in my domain: http://mundodan.com/session.php also, he show me the next configuration:phpinfo.php section session:
Session Support enabled, Registered save handlers files user, Registered serializer handlers php_serialize php php_binary wddx,
session.auto_start Off Off, session.cache_expire 180 180, session.cache_limiter nocache nocache, session.cookie_domain no value no value, session.cookie_httponly Off Off, session.cookie_lifetime 0 0, session.cookie_path / /, session.cookie_secure Off Off, session.entropy_file no value no value, session.entropy_length 0 0, session.gc_divisor 1000 1000, session.gc_maxlifetime 1440 1440, session.gc_probability 1 1, session.hash_bits_per_character 5 5, session.hash_function 0 0, session.name PHPSESSID PHPSESSID, session.referer_check no value no value, session.save_handler files files, session.save_path /opt/alt/php56/var/lib/php/session /opt/alt/php56/var/lib/php/session, session.serialize_handler php php, session.upload_progress.cleanup On On, session.upload_progress.enabled On On, session.upload_progress.freq 1% 1%, session.upload_progress.min_freq 1 1, session.upload_progress.name PHP_SESSION_UPLOAD_PROGRESS PHP_SESSION_UPLOAD_PROGRESS, session.upload_progress.prefix upload_progress_ upload_progress_, session.use_cookies On On, session.use_only_cookies On On, session.use_strict_mode Off Off, session.use_trans_sid 0 0
So, Do you know what i need to change in order to enable the php default session? i mean , what is wrong in that configuration? what parameter should be different?
Right now i can`t use this awesome product. I hope there are a way to help me.
Thanks.
My test file online: http://www.mundodan.com/pccore/admin.php
Hi
I have replied to your other message. Thanks
Ok thanks.
But only the pk is always used.
So if i put $action = “http://google.com/?amount={booking_amount}”; i will get “http://google.com/?amount={id}”; instead
Hi, i am interested. But i have a question. Can i modify the value of my table field: “photo_name” that contains: “photo.jpg”, in order to add (concatenate) the full url, and then be able to show the image in the grid? (i have space restrictions, so i can not store the full url of images in the field. ) So, if it is posible, what is the instruction to read the image url and show the image rendered in the table grid? Thanks!!!
Hi,
You need to use the callback function to modify the data before display in table. Thanks
3d06cacc-e291-4d9d-a427-e3e00766b947
where do i apply the require once pdocrud.php string?
Hi,
You need to create a php file and include the pdocrud.php file using require_once statement. Thanks
Is it possible to do this with the calendar?
http://190.160.70.90/crud/