FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » Reset Auto Increment to lower value
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Reset Auto Increment to lower value [message #180127] Thu, 10 January 2013 17:55 Go to next message
makamo66 is currently offline  makamo66
Messages: 4
Registered: January 2013
Karma: 0
Junior Member
I need to create a tiles table that has a structure like this for http://www.myownmealplanner.com:

user_id sub_tile_id
1 1
1 2
1 3
2 1
2 2
2 3
3 1
3 2
3 3
etc.
I can't just create new tables for new users because I'm using cakephp and that would require new models, views, and controllers for every new table. How do I get the sub_tile_id to auto_increment starting at every new user id? According to the manual I can't restart auto-increment with a lower value than it has already displayed so this needs to be done with php somehow.
Re: Reset Auto Increment to lower value [message #180129 is a reply to message #180127] Thu, 10 January 2013 20:17 Go to previous messageGo to next message
Denis McMahon is currently offline  Denis McMahon
Messages: 634
Registered: September 2010
Karma: 0
Senior Member
On Thu, 10 Jan 2013 09:55:59 -0800, makamo66 wrote:

> I need to create a tiles table that has a structure like this for
> http://www.myownmealplanner.com:
>
> user_id sub_tile_id 1 1 1 2 1 3 2 1 2 2 2 3 3 1
3 2 3 3 etc.
> I can't just create new tables for new users because I'm using cakephp
> and that would require new models, views, and controllers for every new
> table. How do I get the sub_tile_id to auto_increment starting at every
> new user id? According to the manual I can't restart auto-increment with
> a lower value than it has already displayed so this needs to be done
> with php somehow.

You could try using SQL something along the lines of:

insert into table ( user_id, sub_tile_id ) values ( 'current_user_id',
count( select sub_tile_id where user_id = 'current_user_id' ) + 1 );

I *think* something like that should increment sub_tile_id on a per
user_id basis, but it's not really a php solution, more of an sql one.

--
Denis McMahon, denismfmcmahon(at)gmail(dot)com
Re: Reset Auto Increment to lower value [message #180132 is a reply to message #180127] Fri, 11 January 2013 10:05 Go to previous messageGo to next message
Captain Paralytic is currently offline  Captain Paralytic
Messages: 204
Registered: September 2010
Karma: 0
Senior Member
On Jan 10, 5:55 pm, makam...@gmail.com wrote:
> I need to create a tiles table that has a structure like this forhttp://www.myownmealplanner.com:
>
> user_id sub_tile_id
> 1       1
> 1       2
> 1       3
> 2       1
> 2       2
> 2       3
> 3       1
> 3       2
> 3       3
> etc.
> I can't just create new tables for new users because I'm using cakephp and that would require new models, views, and controllers for every new table.. How do I get the sub_tile_id to auto_increment starting at every new user id? According to the manual I can't restart auto-increment with a lower value than it has already displayed so this needs to be done with php somehow..

If you are uaing MySQL then this is the default behaviour:
http://stackoverflow.com/questions/3804845/auto-increment-usage-in-composit e-key
Re: Reset Auto Increment to lower value [message #180133 is a reply to message #180132] Fri, 11 January 2013 13:55 Go to previous messageGo to next message
makamo66 is currently offline  makamo66
Messages: 4
Registered: January 2013
Karma: 0
Junior Member
On Friday, January 11, 2013 5:05:54 AM UTC-5, Captain Paralytic wrote:
> On Jan 10, 5:55 pm, makam...@gmail.com wrote:
>
>> I need to create a tiles table that has a structure like this forhttp://www.myownmealplanner.com:
>
>>
>
>> user_id sub_tile_id
>
>> 1       1
>
>> 1       2
>
>> 1       3
>
>> 2       1
>
>> 2       2
>
>> 2       3
>
>> 3       1
>
>> 3       2
>
>> 3       3
>
>> etc.
>
>> I can't just create new tables for new users because I'm using cakephp and that would require new models, views, and controllers for every new table. How do I get the sub_tile_id to auto_increment starting at every new user id? According to the manual I can't restart auto-increment with a lower value than it has already displayed so this needs to be done with php somehow.
>
>
>
> If you are uaing MySQL then this is the default behaviour:
>
> http://stackoverflow.com/questions/3804845/auto-increment-usage-in-composit e-key

This didn't work
CREATE TABLE `tiles` (
`sub_tile` ENUM('1','2','3') NOT NULL,
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`user_id` INT(22)
)
Re: Reset Auto Increment to lower value [message #180134 is a reply to message #180133] Fri, 11 January 2013 14:05 Go to previous messageGo to next message
M. Strobel is currently offline  M. Strobel
Messages: 386
Registered: December 2011
Karma: 0
Senior Member
Am 11.01.2013 14:55, schrieb makamo66(at)gmail(dot)com:
> On Friday, January 11, 2013 5:05:54 AM UTC-5, Captain Paralytic wrote:
>> On Jan 10, 5:55 pm, makam...@gmail.com wrote:
>>
>>> I need to create a tiles table that has a structure like this forhttp://www.myownmealplanner.com:
--cut
>>
>>> I can't just create new tables for new users because I'm using cakephp and that would require new models, views, and controllers for every new table. How do I get the sub_tile_id to auto_increment starting at every new user id? According to the manual I can't restart auto-increment with a lower value than it has already displayed so this needs to be done with php somehow.
>>
>>
>>
>> If you are uaing MySQL then this is the default behaviour:
>>
>> http://stackoverflow.com/questions/3804845/auto-increment-usage-in-composit e-key
>
> This didn't work

what?

> CREATE TABLE `tiles` (
> `sub_tile` ENUM('1','2','3') NOT NULL,
> `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
> `user_id` INT(22)
> )
>
Re: Reset Auto Increment to lower value [message #180135 is a reply to message #180133] Fri, 11 January 2013 16:18 Go to previous messageGo to next message
Captain Paralytic is currently offline  Captain Paralytic
Messages: 204
Registered: September 2010
Karma: 0
Senior Member
On Jan 11, 1:55 pm, makam...@gmail.com wrote:
> On Friday, January 11, 2013 5:05:54 AM UTC-5, Captain Paralytic wrote:
>> On Jan 10, 5:55 pm, makam...@gmail.com wrote:
>
>>> I need to create a tiles table that has a structure like this forhttp://www.myownmealplanner.com:
>
>>> user_id sub_tile_id
>
>>> 1       1
>
>>> 1       2
>
>>> 1       3
>
>>> 2       1
>
>>> 2       2
>
>>> 2       3
>
>>> 3       1
>
>>> 3       2
>
>>> 3       3
>
>>> etc.
>
>>> I can't just create new tables for new users because I'm using cakephp and that would require new models, views, and controllers for every new table. How do I get the sub_tile_id to auto_increment starting at every new user id? According to the manual I can't restart auto-increment with a lower value than it has already displayed so this needs to be done with php somehow.
>
>> If you are uaing MySQL then this is the default behaviour:
>
>> http://stackoverflow.com/questions/3804845/auto-increment-usage-in-co...
>
> This didn't work
> CREATE TABLE `tiles` (
>         `sub_tile` ENUM('1','2','3') NOT NULL,
>         `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
>         `user_id` INT(22)
>  )

Why would it work, you haven't specified a composite primary key?
Re: Reset Auto Increment to lower value [message #180136 is a reply to message #180133] Fri, 11 January 2013 19:07 Go to previous messageGo to next message
Luuk is currently offline  Luuk
Messages: 329
Registered: September 2010
Karma: 0
Senior Member
On 11-01-2013 14:55, makamo66(at)gmail(dot)com wrote:
> According to the manual

which manual?

> I can't restart auto-increment with a lower value than it has already displayed

if it cannot be donne, according to the manual as you state,
than i cannot be done....

> so this needs to be done with php somehow.

eve with php it cannot be done,
if your manual says that it cannot be done...
Re: Reset Auto Increment to lower value [message #180137 is a reply to message #180127] Fri, 11 January 2013 19:22 Go to previous messageGo to next message
Luuk is currently offline  Luuk
Messages: 329
Registered: September 2010
Karma: 0
Senior Member
On 10-01-2013 18:55, makamo66(at)gmail(dot)com wrote:
> I need to create a tiles table that has a structure like this for http://www.myownmealplanner.com:
>

try fixing this error,
it will give you some knowledge about how to build a php-enabled
website.........

i got it by visiting:
http://myownmealplanner.com/mealplans/edit/13


Missing Method in MealplansController

Error: The action edit is not defined in controller MealplansController

Error: Create MealplansController::edit() in file:
app/Controller/MealplansController.php.
<?php
class MealplansController extends AppController {


public function edit() {

}

}

Notice: If you want to customize this error message, create
app/View/Errors/missing_action.ctp

Stack Trace
•CORE/Cake/Routing/Dispatcher.php line 186 →
Controller->invokeAction(CakeRequest)


•CORE/Cake/Routing/Dispatcher.php line 161 →
Dispatcher->_invoke(MealplansController, CakeRequest, CakeResponse)


•APP/webroot/index.php line 92 → Dispatcher->dispatch(CakeRequest,
CakeResponse)
Re: Reset Auto Increment to lower value [message #180138 is a reply to message #180127] Fri, 11 January 2013 19:37 Go to previous messageGo to next message
makamo66 is currently offline  makamo66
Messages: 4
Registered: January 2013
Karma: 0
Junior Member
I was asked at another forum why I want a sub_tile_id and this is my explanation. I'd like to know if it is even really necessary after all.
The jquery at http://myownmealplanner.com/mealplans/add contains the following code (see the view source):

for (var i=1;i<100;i++){
$( "#draggable" + i ).draggable();
}

Each draggable div uses the primary key of the tiles table to create its own name, for example draggable1, draggable2,..., and on up to draggable100. The tile id (primary key) gives the draggable div its name and I am looping through 100 of these. If I have five users who each have 20 meal tiles then I have already exhausted all of the names available at 100 (5 times 20 being 100). Of course I could just loop over 200 meal tiles instead, keep adding users and keep looping over ever more meal tiles but it seems like a bad idea. Wouldn't the jquery slow down quite a bit if I loop through for example 500 tiles? If instead each user has his own set of meal tiles then I would grab the user id and the sub_tile_id so it would never be more than maybe 10 or 20 to loop through.
Re: Reset Auto Increment to lower value [message #180139 is a reply to message #180138] Fri, 11 January 2013 19:38 Go to previous message
makamo66 is currently offline  makamo66
Messages: 4
Registered: January 2013
Karma: 0
Junior Member
Why did you go to an edit page that doesn't exist? I don't think I have a navigation link to it so why did you look for it?
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: php unit testing - how to find the right person
Next Topic: Anyone have experience with any php debuggers?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 10 04:07:36 GMT 2024

Total time taken to generate the page: 0.03222 seconds